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

      S
      slangleyCommunity Manager
      Community Manager
      December 10, 2020

      Hi @RajatBain.

       

      What output did you receive when you ran the service?

       

      Regards.

       

      --Sharon

       

      Terms & ConditionsCookie settingsAccessibility statement