Skip to main content
R
rajee13-Aquamarine
13-Aquamarine
December 26, 2018
Solved

Error in connecting Oracle database to Thingworx Platform

  • December 26, 2018
  • 1 reply
  • 7669 views

I followed the document https://www.ptc.com/en/support/article?n=CS229265. When i try to test the connection, i am getting an error called, thing not working. I have mentioned the error and details which I included

    Best answer by rajee

    Hi @slangley

     

    I have been using trial version, Now when i used the licensed version, I could connect to oracle database using relational database connector.

    1 reply

    H
    hchanana16-Pearl
    16-Pearl
    December 27, 2018

    Hi @rajee,

     

    Can you please remove the semi-colon (;) from the end of query and try executing the service.

     

    Thanks,

    Himanshu

    S
    Surekha1-Visitor
    1-Visitor
    December 27, 2018

    Hi @hchanana,

       Thank you for your response.We have tried by removing the semi-colon (;)  also, but showing same error

    S
    slangleyCommunity Manager
    Support
    December 31, 2018

    Hi @rajee and @Surekha.

     

    Have you checked the logs at \ThingworxStorage\logs for additional information regarding the failure?  I assume Oracle is running on a different machine.  If so, have you validated that you can connect to the database outside of ThingWorx from the ThingWorx server?

     

    Regards.

     

    --Sharon

    Terms & ConditionsAccessibility statement