PSI Fails with " Error during schema Creation , while adding columns "

[aachanta]

Hi All,

I am trying to install Windchill 11.0 M030-CPS11 on Windows 10 machine. I am getting the attached error and the installation is then getting aborted.

I have seen a PTC Case where it was said to run the below command

xconfmanager -s wt.db.maxBytesPerChar=3 -t codebase\wt.properties –p

But even after the property value got changed the installation is getting aborted. The PSI Installer error is as below

Updating database schema... be patient.
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0
joining with std out thread
std out join complete.
joining with std error thread
std err join complete.
AddColumns -u -s process returned non-zero: 1
Installation is Aborting. The installation cannot continue.
Aborting installation.
Installation is Aborting. The installation cannot continue.
Error during schema creation, while adding columns. See the logs for more information.
aborting: original exit_code = 2
aborting: normalized exit_code = 2
SHUTDOWN REQUESTED
commiting registry
(X) shutting down service manager
(X) cleaning up temporary directories
Exiting with exit code: 2
cleanUp()
calling cleanUpWin32()

Best Regards,

Aditya

[ravimane27]

You can try by unselecting shortcut creation option. I had got same error multiple times and after removing shortcut creation it worked. 

[kavitha]

Did you create the db user via PSI or used existing db schema ?

i'm using existing db schema and its failing with error " Error during Schema Creation".

[ravimane27]

If its a cluster setup and this is your second installation you have to select existing user and also you have to uncheck "create database schema" and "import data" options. 

[kavitha]

I'm doing fresh installation and we don't have option to select "Create database user" do to limitation at DB end.



Hence creating user manually and installing it, but failing with Error during schema creation.

[ravimane27]

For fresh installation you must select create DB user and you must provide DB system user credentials to complete the installation, no other way. You need to contact DB team and get system user/password. 

[LSuek]

Was there any resolution for this? I am seeing this same error after my installation failed due to another issue.