Skip to main content
R
RajatBain1-Visitor
1-Visitor
December 9, 2020
Question

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

  • December 9, 2020
  • 1 reply
  • 3968 views

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

    1 reply

    H
    hchanana16-Pearl
    16-Pearl
    December 9, 2020

    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

      R
      RajatBain1-VisitorAuthor
      1-Visitor
      December 10, 2020

      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

      M
      MM_96393905-Regular Member
      5-Regular Member
      January 6, 2021

      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

      Terms & ConditionsCookie settingsAccessibility statement