I am facing error while doing local setup "ThingWorx 7.4 with MSSQL database"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am facing error while doing local setup "ThingWorx 7.4 with MSSQL database"
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.
Solved! Go to Solution.
- Labels:
-
Install-Upgrade
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Jitender have you verified if the MS SQL's schema is setup correctly and you have all the required schema generated from the script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes Sushant, I have checked MS SQL schema is setup correctly and i am able to see ThingWorx related tables under ThingWorx database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.