cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager thing in Manufacturing App

RajatBain
Contributor

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...

7 REPLIES 7

Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager thing in Man

Hi @RajatBain ,

 

Have you updated the DBConnection configuration in PTC.Factory.C_LaunchPointConfigurationThing_[ReleaseVersion] thing to your PTC.SCA.SCO.MSSQLDatabase.

 

Capture.PNG

 

Please share the screenshot of configuration tab of PTC.SCA.SCO.MSSQLDatabase thing as well.

 

Thanks,

Himanshu

Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager in Manufacturing App

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. 

Snap1.png

 

Also my PTC.SCA.SCO.MSSQLDatabase is configured correctly and it is connected to my SQL DB.

Snap2.png

 

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

@Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager in Manufactu

Hi @RajatBain.

 

What output did you receive when you ran the service?

 

Regards.

 

--Sharon

 

Re: @Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager in Manu

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

Re: @Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager in Manu

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

Re: @Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager in Manu

Hi @MM_9639390.

 

I found an article on this.  Please review and let us know the outcome.

 

Regards.

 

--Sharon

Re: @Re: Unable to execute "CreateTables" service from PTC.SCA.SCO.DatabaseManager in Manu

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

Announcements