Skip to main content
S
Sheetal_sable1-Visitor
1-Visitor
June 18, 2019
Solved

Facing an issue while installing thingworx 8.4 on top of sql

  • June 18, 2019
  • 6 replies
  • 3195 views

Hi,

     I am installing thingworx 8.4 on top of sql server 2017. After Installation when I go to Composer, message showing as "503 Service Unavailable". So I have checked the Application Log showing message as "message: Unable to initialize and start system: Connections could not be acquired from the underlying database!".

     For reference I have attached Application log, platform-setting.json.

We are following the document for installation as https://support.ptc.com/WCMS/files/172634/en/Getting_Started_with_MS_SQL_Server_and_ThingWorx_1.pdf.

Could you please help to resolve this.

 

Thanks,

Sheetal

    

   

Best answer by slangley

Hi @Sheetal_sable.

 

Did you download the jdbc driver?  I have attached it here.

 

Unzip it first, then drop it into <tomcat_home>\lib, then restart Tomcat.

 

Regards.

 

--Sharon

6 replies

R
Rajesh_Sayana5-Regular Member
5-Regular Member
June 18, 2019

Please take a look at this article: Debug ThingWorx Platform and MSSQL database connectivity

The steps provided in the article might help with the resolution.

 

Best regards,

Rajesh.

S
Sheetal_sable1-VisitorAuthor
1-Visitor
June 19, 2019

hi @Rajesh_Sayana ,

  I followed all the steps as provided here 'Please take a look at this article: Debug ThingWorx Platform and MSSQL database connectivity' .Also tried validation techniques provided by community still not fixed the problem.But still i am facing issue (attached screenshot of it) and Application log and platform-setting is attached. 

 

I have queries:

1. which jdbc driver is used for sql server 2017.

2. Is attached platform-settings.json file correct.

3. need to set any environment variables?

 

Can you Please provide detailed procedure from start to end sequentially for installing thingworx 8.4 on top of SQL 2017.

I have also searched for customer care details but no success, could you please provide the customer care details as well

 

Please help me regarding this.

 

 

 

J
Janakiraman-P1-Visitor
1-Visitor
June 19, 2019

Hi,

 

Make sure %JAVA_HOME%\bin   and    %JRE_HOME%\bin   are available in environment path variable.

 

 

Terms & ConditionsAccessibility statement