cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Amethyst

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

AddingColumns.PNGHi 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

6 REPLIES 6

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

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

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

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".

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

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. 

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

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.


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

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. 

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

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