PSI fails with error as "Installation is Aborting. The installation cannot continue."

[Thulasiraman]

INFO 2021-02-18 16:29:54 - Processing type: com.ptc.arbortext.windchill.siscore.translation.XliffLink...
INFO 2021-02-18 16:29:55 - ERROR : com.ptc.core.lwc.server.addColumns.DatabaseColumns - Cannot create SQL statement
INFO 2021-02-18 16:29:55 - ERROR : com.ptc.core.lwc.server.addColumns.DatabaseColumns - Cannot get SQL meta data
INFO 2021-02-18 16:29:55 - wt.util.WTException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'LWCColumnAllocation'.
INFO 2021-02-18 16:29:55 - Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'LWCColumnAllocation'.
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
INFO 2021-02-18 16:29:55 - at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:677)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.addColumns.DatabaseColumns.calculateUnallocatedColumns(DatabaseColumns.java:206)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.addColumns.DatabaseColumns.<init>(DatabaseColumns.java:126)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.addColumns.DatabaseColumns.newDatabaseColumns(DatabaseColumns.java:168)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.addColumns.DatabaseToSchemaFileSynchronizer.synchFromDatabase(DatabaseToSchemaFileSynchronizer.java:81)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.addColumns.AddColumnsImpl.syncFromDBToSchemaFile(AddColumnsImpl.java:455)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.addColumns.AddColumnsImpl.performAction(AddColumnsImpl.java:143)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.AddColumns.addColumns(AddColumns.java:70)
INFO 2021-02-18 16:29:55 - at com.ptc.core.lwc.server.AddColumns.main(AddColumns.java:46)
INFO 2021-02-18 16:29:55 - Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
INFO 2021-02-18 16:29:55 - joining with stdout thread
INFO 2021-02-18 16:29:55 - std out join complete.
INFO 2021-02-18 16:29:55 - joining with std error thread
INFO 2021-02-18 16:29:55 - std err join complete.
FATAL 2021-02-18 16:29:55 - add columns sync process returned non-zero: 1
DEBUG 2021-02-18 16:29:55 - Installation is Aborting. The installation cannot continue.

FATAL 2021-02-18 16:30:37 - Aborting installation.
FATAL 2021-02-18 16:30:37 - Installation is Aborting. The installation cannot continue.
Error during the schema sync process, while adding columns. See the logs for more information.
FATAL 2021-02-18 16:30:37 -
FATAL 2021-02-18 16:30:37 - aborting: original exit_code = 2
FATAL 2021-02-18 16:30:37 - aborting: normalized exit_code = 2
DEBUG 2021-02-18 16:30:37 - SHUTDOWN REQUESTED
DEBUG 2021-02-18 16:30:37 - (X) commiting registry
DEBUG 2021-02-18 16:30:38 - (X) shutting down s

[BjoernRueegg]

It looks like the Installer has a problem with adding new attributes.

Perhaps the DB and the installation (java classes) have not the same amount of attributes defined.

Please try following command in the Windchill shell:

AddColumns -syncFromDB

Otherwise you need to provide PTC the upgrade logs.

[Thulasiraman]

I ran the command as mentioned but the following error is thrown again,

D:\ptc\Windchill_11.1\Windchill>AddColumns -syncFromDB
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
Found 75 TypeManaged types to synchronize from database.
Processing D:\ptc\Windchill_11.1\Windchill\conf\type\AddColumnsSchema.xml... (File will be backed up and a new version will be created.)

Processing type: com.ptc.arbortext.windchill.siscore.translation.XliffLink...
ERROR : com.ptc.core.lwc.server.addColumns.DatabaseColumns - Cannot create SQL statement
ERROR : com.ptc.core.lwc.server.addColumns.DatabaseColumns - Cannot get SQL meta data
wt.util.WTException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'LWCColumnAllocation'.
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'LWCColumnAllocation'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:677)
at com.ptc.core.lwc.server.addColumns.DatabaseColumns.calculateUnallocatedColumns(DatabaseColumns.java:206)
at com.ptc.core.lwc.server.addColumns.DatabaseColumns.<init>(DatabaseColumns.java:126)
at com.ptc.core.lwc.server.addColumns.DatabaseColumns.newDatabaseColumns(DatabaseColumns.java:168)
at com.ptc.core.lwc.server.addColumns.DatabaseToSchemaFileSynchronizer.synchFromDatabase(DatabaseToSchemaFileSynchronizer.java:81)
at com.ptc.core.lwc.server.addColumns.AddColumnsImpl.syncFromDBToSchemaFile(AddColumnsImpl.java:455)
at com.ptc.core.lwc.server.addColumns.AddColumnsImpl.performAction(AddColumnsImpl.java:143)
at com.ptc.core.lwc.server.AddColumns.addColumns(AddColumns.java:70)
at com.ptc.core.lwc.server.AddColumns.main(AddColumns.java:46)
AddColumns failure. Review the console error message and upgrade_tool.log in the current directory for more information.

D:\ptc\Windchill_11.1\Windchill>

[BjoernRueegg]

I would suggest to open up a case.