Skip to main content
J
jisingh5-Regular Member
5-Regular Member
June 8, 2017
Solved

I am facing error while doing local setup "ThingWorx 7.4 with MSSQL database"

  • June 8, 2017
  • 2 replies
  • 2986 views

I am facing error while doing local setup "ThingWorx 7.4 with MSSQL database" ERROR:-017-06-08 17:02:39.358+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Failed to create com.thingworx.persistence.mssql.MssqlPersistenceProviderPackage. Cause was due to 'null']

2017-06-08 17:02:39.359+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***

Please assist me how i will remove this error.

Best answer by dupatel

Jitender Singh​: I faced the same issue and it seems you have missed the step of placing the JDBC jar file as mentioned in the installation guide

Copy the sqljdbc42-6.0.<build_number>.jar file to the lib directory of the Tomcat installation: (<TOMCAT_HOME>/lib).

Please refer document : Getting Started with MS SQL Server and ThingWorx for complete details.

2 replies

S
supandey5-Regular Member
5-Regular Member
June 8, 2017

Jitender have you verified if the MS SQL's schema is setup correctly and you have all the required schema generated from the script?

P
posipova20-Turquoise
20-Turquoise
June 8, 2017

In addition to Sushant's questions, please ensure your tcp/ip is enabled  and the port you configured your mssql with is open. Also verify the password in platform-settings.json file.

J
jisingh5-Regular MemberAuthor
5-Regular Member
June 9, 2017

My TCP/IP ports are enabled, related to configured port with MS-Sql i  am not aware is it open or not. i don't know how to check it.

If possible please help me how to check port open or not.

Password is correct in platform-settings.json file.

D
dupatel5-Regular MemberAnswer
5-Regular Member
June 13, 2017

Jitender Singh​: I faced the same issue and it seems you have missed the step of placing the JDBC jar file as mentioned in the installation guide

Copy the sqljdbc42-6.0.<build_number>.jar file to the lib directory of the Tomcat installation: (<TOMCAT_HOME>/lib).

Please refer document : Getting Started with MS SQL Server and ThingWorx for complete details.

    Terms & ConditionsAccessibility statement