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