Skip to main content
newieKek14-Alexandrite
14-Alexandrite
Jan 19, 2022 9:48 AM UTC
Solved

Unable to Create database in Thing: PTC.Factory.C_LaunchPointConfigurationThing_9.1.0_02

Hi,

 

I am installing AMU in the Thingworx 9.3, and had encounter issue at step 11 of the Core 310 installation.

The error shown is as per below when i "Create Database"

Error in: PTC.SCA.SCO.DefaultProductionOrderManager.CreateEnumeration javascript service. Message ::An error has occurred. Contact your administrator for further details.

 

I am not sure what is should check further?

Do advise, i have checked the connection to the MSSQL database is connected.

newieKek_0-1642585466320.png

 

And i hope to clarify, when i install the MSSQL db setup the Collation is 

newieKek_1-1642585572326.png

But in the installation guide, at Step 12, they ask for.

newieKek_2-1642585636593.png

Should i create a new database?

Hope someone can help me on the step 11 !!

 

Thank you

Newbie Kek

 

 

Answer
Feb 14, 2022 11:50 AM UTC

Now it is working fine. I have given wrong Connection string. If i change the connection string from SELECT NOW() to SELECT GET DATE(), am able to connect to database.

thank you for the guidance

View in thread

8 replies

VladimirN24-Ruby IV
24-Ruby IV
Jan 19, 2022 1:59 PM UTC

 Hi,

 

Read this article - "Executing CreateDatabase service failed when installing Real-Time Production Performance Monitoring (RTPPM)": https://www.ptc.com/en/support/article/CS354637 

Translate
newieKek14-AlexandriteAuthor
14-Alexandrite
Jan 20, 2022 2:44 AM UTC

Hi,

I hope to clarify further, when i install the MSSQL Thingworx foundation

it stated the following:

newieKek_0-1642643785149.png

So i created a  database call thingworx, with the collation Latin1_General_100_CS_AS_SC.

The article show i required Collation SQL_Latin1_General_CP1_CI_AS.

Does that meant i need to create another database? as i cannot change the Collation in the exisitng database.

 

I followed the step in Install Guide CORE 3.1.0 Clean Install, and Chapter 11, "PTC.SCA.SCO.MnfgCommonDatabaseInstaller" services Create Database. I got the error. 

I read in the Chapter 12 of Install Guide CORE 3.1.0, ""CoreStoredProcedureConcatenated.sql" will create and required Collation SQL_Latin1_General_CP1_CI_AS.

 

But i had issue at the "Core" and not able to proceed to Chapter12, as i encounter the problem above error. 

 

I hope to check, i installed the AMU over an existing Manufacturing Apps with some setup, should i delete anything? is there any guides in regards.

 

Do advise.

Best regards

Newbie Kek

 

 

Translate
slangleyCommunity Manager
Support
Jan 31, 2022 9:44 PM UTC

Hi @newieKek.

 

I worked with R&D on this question a couple of years ago, so I can confirm that you need to use Latin1_General_100_CS_AS_SC.  I was advised that with varchar based data, there are small but significant differences with the sorting and comparison of data which may have an impact on upgrades and other unexpected consequences.

 

Here's an article that may help you to change the collation.  Here's another article that may also be helpful.   Be sure to create good backups before beginning the process.

 

Regards.

 

--Sharon

Translate
Anonymous
Answer
Feb 14, 2022 11:50 AM UTC

Now it is working fine. I have given wrong Connection string. If i change the connection string from SELECT NOW() to SELECT GET DATE(), am able to connect to database.

thank you for the guidance

Translate
    slangleyCommunity Manager
    Support
    Feb 14, 2022 7:54 PM UTC

    Hi @unknown and @newieKek.

     

    I'm glad you found the solution for your connection issue.  Please mark your last post as the Accepted Solution for the benefit of others with the same issue.

     

    I'm following up on the collation question.  It seems I misread your response the first time.  I want to be sure I'm providing accurate information.

     

    Regards.

     

    --Sharon

     

    Translate
      slangleyCommunity Manager
      Support
      Feb 18, 2022 9:47 PM UTC

      Hi @unknown and @newieKek.

       

      I just wanted to let you know that the recommended collation for ThingWorx Platform and RTPPM are different, as you pointed out.  As you discovered, RTPPM does require a separate database.

       

      Thank you for sharing your findings with the community.

       

      Regards.

       

      --Sharon

       

      Translate
        newieKek14-AlexandriteAuthor
        14-Alexandrite
        Feb 25, 2022 2:37 AM UTC

        Hi Slangley,

         

        I re-installed everything, and discover, a sentence in Page 19/35 of Core310 installation manual.

        * It mentioned: <DATABASE_NAME>: name of the database where you install the ThingWorx Manufacturing Apps. ( ThingWorx Manufacturing Apps and ThingWorx Apps are to coexist on the same database)

         

        When I install the ThingWorx with Mssql, i used the thingWorxMssqlDBSetup.bat, when i install the Manufacturing Apps, i connect my Manufacturing apps to the database created by the bat file. 

         

        So in order to fulfilled the installation of the AMU/RTPPM, i need to create a New database with Latin1_General_100_CS_AS_SC. So i had successfully install the AMU and RTPPM, now struggling with the configuration of the app. 

         

        Sorry for the late replied. 

        Thank you!! 

        Best regards

        Newbie Kek

        Translate
        Terms & ConditionsAccessibility statement