Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager thing in Manufacturing App
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager thing in Manufacturing App
I have imported Manufacturing App in Twx8.5.1 and followed all the instructions from Thingworx Help Center. But while performing Post Import Database Configurations, I am unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager thing. I am getting following error
Error executing service CreateTables. Message :: An error has occurred. Contact your administrator for further details. - See Script Error Log for more details.
Note: I have set my database using MSSQL and it is connected. I don't know what I am missing. Please help...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RajatBain ,
Have you updated the DBConnection configuration in PTC.Factory.C_LaunchPointConfigurationThing_[ReleaseVersion] thing to your PTC.SCA.SCO.MSSQLDatabase.
Please share the screenshot of configuration tab of PTC.SCA.SCO.MSSQLDatabase thing as well.
Thanks,
Himanshu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hchanana ,
Thank you for your reply.
Yes,I have updated the DBConnection in PTC.Factory.C_LaunchPointConfigurationThing_8.5.1_01 thing to my PTC.SCA.SCO.MSSQLDatabase.
Also my PTC.SCA.SCO.MSSQLDatabase is configured correctly and it is connected to my SQL DB.
I don't know what I am missing here. But when I am updating the DBConnection in PTC.Factory.C_LaunchPointConfigurationThing_8.5.1_01 thing to my PTC.SCA.SCO.PostgresDatabase, my application is working properly.
So, now I know that the issue with my MSSQL BD connection, just cant figure it out.
Thanks,
Rajat Bain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @slangley ,
I am getting the same error trying to execute the "CreateTables" service from PTC.SCA.SCO.DatabaseManager. We're getting the error discussed in this support article, and everything seems correct up to this last step.
When I try to execute the service, I get the message " Error executing service CreateTables. Message :: An error has occurred. Contact your administrator for further details. - See Script Error Log for more details." and I see the same message when I look in logs (Monitoring->ApplicationLog)
Thanks!
Matt
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MM_9639390.
It's possible that the tables have already been created. I'll have to reach out to the TWX Apps support team to determine how to verify.
Regards.
--Sharon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MM_9639390.
I found an article on this. Please review and let us know the outcome.
Regards.
--Sharon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For the sake of others in the community, while working with @MM_9639390, we found that the database thing (PTC.SCA.SCO.PostgresDatabase or PTC.SCA.SCO.MSSQLDatabase) did not reflect the correct connection information in the jdbc string.
Regards.
--Sharon
