Has anyone been able to successfully configure Thingworx 7.4 to use MS SQL Server?

[gmontgomery-2]

I'm keen to connect Thingworx to SQL Server as the persistence provided now that it is an option with 7.4. However I am struggling to make the database connection. My ApplicationLog.log persists in showing message: Unable to initialize and start system: Connections could not be acquired from the underlying database! ​despite everything I've tried.

I've confirmed that my user/password is the same I used to create the SQL Server db using the PTC provided scripts. I confirmed this by logging in to the db via SQL Developer and a JDBC driver.

I've attached my ApplicationLog.log file along with my platform-settings.json file (user/password is twadmin/wcadmin for dev environment sake)

If anyone has successfully connected could you share your platform-settings.json along with any tips you might have uncovered?

Thank you!

Greg

[cmorfin]

Hi Greg

I was able to make ThingWorx works with SQL Server as Persistence Provider.

I have attached my simple platform-settings.json file for reference.

I would think the current error is because you are missing the element PersistenceProviderPackageConfigs in your json

I also had to execute the steps from Matthew Felton at Thingworx 7.4 MSSQL Install Errors

After that it worked all right

Hope this helps

Kind regards

Christophe

[posipova · Accepted solution]

To add to what Christophe said, you may look into this Troubleshooting MS SQL connection to Thingworx 7.4 in Windows

[gmontgomery-2]

Christophe and Polina,

Thank you both for taking the time to respond. I apologize for not replying sooner. The 7.4 installation with SQL Server was very challenging for me and there were so many possibly root failure points to work through, inconsistent sample platform-settings.json, similar sounding but unrelated failure modes etc. It was very frustrating. In the end I bit the bullet and dropped the SQL Server database and reran the database and schema installation scripts and finally the server started up like a charm. The issue was not in my platform-settings.json after all. I was thrown off the scent I think because the initial installation had resulted in a number of tables being created in the database. As soon as I ran it the second time I noticed right away there were many more tables than the first time and so it appeared that the script had failed mid way through for some reason.

I had seen mentions elsewhere to re-install the database in case of issues but I was too stubborn to go there. Thanks to Polina for pointing out the fact that there is JIRA ticket pertaining to intermittent script failures. That was the nudge in the right direction that I needed.

Thank you both again and for anyone else having trouble installing with SQL Server, don't hesitate to clean the database and rerun the installation scripts. I'm very happy now because the restart times for my 7.2 / H2 instance was on the order of 6 minutes and now with SQL Server that's down to 45 seconds.

Regards,

Greg