Article - CS304222

Windchill installation fails with error during schema creation

Modified: 24-Jul-2023   


Applies To

  • Windchill PDMLink 11.1 to 13.1

Description

  • Windchill installation failed with SQL Server database
  • windchill is reporting an error at about 50% install
  • Error message in PTCSOLNINSTALLER_PtcInstall.log:
INFO   24-07-2023 15:28:22 - ******** Executing 0 pre-schema actions for assembly wlp******** 
INFO   24-07-2023 15:28:22 - ******** Executing 0 pre-schema actions for assembly wsp******** 
INFO   24-07-2023 15:28:22 - ******** Executing 0 pre-schema actions for assembly odata******** 
INFO   24-07-2023 15:28:22 - ******** Executing 0 pre-schema actions for assembly solr******** 
ERROR  24-07-2023 15:28:22 - installDebug: start create and load schema 
INFO   24-07-2023 15:28:22 - DDL Manager - configure DDL for Oracle 
INFO   24-07-2023 15:28:22 - DDL Manager - using multibyte configuration 
INFO   24-07-2023 15:28:22 - ************ Loading schema ************ 
DEBUG  24-07-2023 15:28:22 - loadAllSchema: timer.start 
DEBUG  24-07-2023 15:28:22 - WindchillDDLManager:getJavaArgs - for fresh install scenario, and a recover install of a failed (in premature condition) fresh install - dbUser=PDM12 and dbPassword (is hidden). 
INFO   24-07-2023 15:28:22 - ************ Found Schema to Load ************ 
INFO   24-07-2023 15:28:22 - **** Running: /plm/Windchill_12.0/Windchill/bin/windchill --java=/plm/jdk/amazon-corretto-11.0.13.8.1-linux-x64/bin/java --javaargs=[the value is hidden due to password sensitive information.] wt.tools.sql.SQLCommandTool create_ddl_wt.sql /plm/Windchill_12.0/Windchill/db/sql3 
INFO   24-07-2023 15:28:22 - joining with std out thread 
INFO   24-07-2023 15:28:22 - std out join complete. 
INFO   24-07-2023 15:28:22 - joining with std error thread 
INFO   24-07-2023 15:28:22 - std err join complete. 
FATAL  24-07-2023 15:28:22 - create schema returned non-zero: 2 
DEBUG  24-07-2023 15:28:23 - Installation is Aborting.  The installation cannot continue.
 
FATAL  24-07-2023 15:35:52 - Aborting installation. 
FATAL  24-07-2023 15:35:52 - Installation is Aborting.  The installation cannot continue.
 
FATAL  24-07-2023 15:35:52 - Error during schema creation.  See the logs for more information. 
FATAL  24-07-2023 15:35:52 - aborting: original exit_code = 2 
FATAL  24-07-2023 15:35:52 - aborting: normalized exit_code = 2 
DEBUG  24-07-2023 15:35:52 - SHUTDOWN REQUESTED 
DEBUG  24-07-2023 15:35:52 - (X) commiting registry 
DEBUG  24-07-2023 15:35:52 - (X) shutting down service manager 
DEBUG  24-07-2023 15:35:52 - (X) cleaning up temporary directories 
DEBUG  24-07-2023 15:35:52 - Exiting with exit code: 2 
DEBUG  24-07-2023 15:35:52 - java.lang.NullPointerException 
DEBUG  24-07-2023 15:35:53 - cleanUp() 
DEBUG  24-07-2023 15:35:53 - calling cleanUpUNIX()
  • Following error is reported in <Windchill>/installer/logs/20190408113627154_WindchillDDL_error.log
************  Starting to log at Mon Apr 08 11:36:27 CST 2019************
/apphome/ptc/Windchill_11.1/Windchill/bin/windchill: eval: line 292: syntax error near unexpected token `)'
/apphome/ptc/Windchill_11.1/Windchill/bin/windchill: eval: line 292: `/apphome/ptc/Windchill_11.1/Java/jre/bin/java -Dwt.tools.sql.dataSourceClassName=wt.pds.sqlServer.SQLServerDataSource -Dwt.tools.sql.autoCommit=true -Dwt.tools.sql.verbose=6 -Dwt.tools.sql.warningOutputFileName=STDERR -Dwt.tools.sql.errorOutputFileName=STDERR -Dwt.tools.sql.dbUser=xxxxxx -Dwt.tools.sql.dbPassword=xxxxxxxx) -cp "/apphome/ptc/Windchill_11.1/Windchill/codebase:/apphome/ptc/Windchill_11.1/Windchill/codebase/WEB-INF/lib/*:/apphome/ptc/Windchill_11.1/Windchill/lib/*:/apphome/ptc/Windchill_11.1/Java/lib/tools.jar:/apphome/ptc/Windchill_11.1/Windchill/tomcat/bin/bootstrap.jar:/apphome/ptc/Windchill_11.1/Windchill/tomcat/bin/tomcat-juli.jar" wt.tools.sql.SQLCommandTool create_ddl_wt.sql /apphome/ptc/Windchill_11.1/Windchill/db/sqlServer'
************ Ending log at Mon Apr 08 11:36:27 CST 2019************

 
This is a printer-friendly version of Article 304222 and may be out of date. For the latest version click CS304222