Skip to main content
A
AM_99305866-Contributor
6-Contributor
July 31, 2023
Solved

CWC install failure code 25002

  • July 31, 2023
  • 2 replies
  • 3244 views

Hello all,

 

I've been doing an install of Thingworx with CWC, and have been running into a strange error.

 

Installer message:

ERROR 2023-07-31 17:55:49.379 Install Applications - Error Code: 25002
CORE Creating database entities: Failed to establish a connection to the database

 

Script Log:

THINGWORX APP INSTALLATION - CORE : Step #6 => Creating database entities; Failed to establish a connection to the database

 

We're using Thingworx v9.3.1 Postgres, currently installed and working fine on an Azure Windows VM with a hosted DB. SQL Server is installed locally with a Developer license, with a blank DB and user made ready for Mfg Apps. We're using SP8_ThingWorx-CWC-310 for our CWC installer, following the clean install steps.

 

The proper JDBC connector has been added, and we're able to run "VerifyMnfgAppsTableExistence" on the SQL entities that were created during the CWC install attempt. It correctly shows that we have no tables yet installed into the SQL DB, and seems to be querying properly.

 

In summary: Why can't the CWC installer connect to the database here? I've been able to connect within Thingworx, and the installer is able to connect to Thingworx and the SQL DB during the pre-check.

 

Has anyone else seen this happen? I've searched around, and have yet to find any more details on what this error might be.

 

 

 

Best answer by Ivens

Hello,

 

    Since you are running Thingworx on Postgres and CWC requires a Microsoft SQL Server to run I suggest two different things to verify:

  • Check if you included the JDBC for Microsoft SQL Server on your Tomcat/lib folder (restart tomcat after doing this)
  • Check if your JDBC version is not the 12, it seems this reason is not working fine. I recommend using the 9.4.0
  • Check if your JDBC version is compatible with the Java version you are running, the package brings several JAR files, each one for a different JAva version.

2 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
August 1, 2023

Article - "Unable to install Connected Work Cell ThingWorx Apps": https://www.ptc.com/en/support/article/CS395732

A
AM_99305866-ContributorAuthor
6-Contributor
August 1, 2023

Hello,

 

I've seen this link when searching. I can verify that DBO is set as the default schema for the twADmin DB user.

I
Ivens12-AmethystAnswer
12-Amethyst
August 1, 2023

Hello,

 

    Since you are running Thingworx on Postgres and CWC requires a Microsoft SQL Server to run I suggest two different things to verify:

  • Check if you included the JDBC for Microsoft SQL Server on your Tomcat/lib folder (restart tomcat after doing this)
  • Check if your JDBC version is not the 12, it seems this reason is not working fine. I recommend using the 9.4.0
  • Check if your JDBC version is compatible with the Java version you are running, the package brings several JAR files, each one for a different JAva version.
A
AM_99305866-ContributorAuthor
6-Contributor
August 1, 2023

Tomcat has `mssql-jdbc-12.2.0.jre11.jar` placed in the lib folder, and I've restarted the platform.

 

The `PTCFSU.CoreSQLThing` and `PTC.FSU.CORE.MSSQL_TG` things were both left in Thingworx after the failed install, but I've filled out their connection details. They're able to run "VerifyMnfgAppsTableExistence" against the SQL DB.

 

 

Terms & ConditionsCookie settingsAccessibility statement