Skip to main content
N
nkhoja1-Visitor
1-Visitor
March 17, 2020
Solved

MSSQL server 2016 and ThingWorxFoundationMSSQL-8.5.4-x64.

  • March 17, 2020
  • 1 reply
  • 7448 views

Trying to install ThingWorx Foundation using the installer provided. 

MSSQL server has been setup using these instructions https://support.ptc.com/WCMS/files/172634/en/Getting_Started_with_MS_SQL_Server_and_ThingWorx_1.pdf

The Install builder is giving me an error at the ThingWorx Foundation for MSSQL Setup part.

At this point after I enter all the server connection/login information and I hit next I get this error 

"thingworx database has tables prior to ThingWorx installation. Please drop tables or use a different database."

I also tried creating a new database and giving it a different name (thingworkx instead of thingworx) but that didn't help either. I am really new to the ThingWorx world so any help is greatly appreciated. See screen shots for reference. I found one article but that was for PostgreSql and now MSSQL. Here is the link to that https://www.ptc.com/en/support/article/CS320445 

Best answer by slangley

Hi @nkhoja.

 

While working the case we found that a 32-bit version of Java 8 was installed.  In addition, Java 13 was installed and the installer was trying to use this version, which is not supported.  By removing both versions and installing the 64-bit version of the Java SDK 8, we were able to resolve the issues resulting in a successful installation.

 

If you are in agreement regarding the solution posted here, please mark this as the Accepted Solution for the benefit of others with the same issue.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity Manager
Community Manager
March 18, 2020

Hi @nkhoja.

 

If you are using one of the installers, you simply need to create the database and set the appropriate options.  You should not run the scripts indicated in the documentation you referenced as the installer will take care of creating and populating the tables.  Please refer to these instructions and let us know if you still have questions.

 

Regards.

 

--Sharon

    N
    nkhoja1-VisitorAuthor
    1-Visitor
    March 18, 2020

    Hello Sharon, 

    Hoping you are doing well.

    Thank you for the prompt response :), I did what you said and it did go through the process but the installation failed and prompted me to check the logs. I am attaching the log file. Also I tried re-running the installer and it asked me to uninstall the previous installation (which I did and rebooted the server as well) not sure what bit is blocking it. Attaching the 2 log files that have been generated this morning. 

     

    Regards

    Nadir

    S
    slangleyCommunity Manager
    Community Manager
    March 18, 2020

    Hi @nkhoja.

     

    You may have to search the registry and delete any entries related to the install.  (Note:  take care in doing so as a mistake could render your system inoperative.)  Also, make sure any folders that were created, get removed.  Finally, restart the operating system to ensure a clean startup.

     

    Please let us know if you continue to have issues.

     

    Regards.

     

    --Sharon

     

      Terms & ConditionsCookie settingsAccessibility statement