cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Rest API not working in Thingworx

Yedukrishnan
Amethyst

Rest API not working in Thingworx

Response while passing a REST API. API is working well with Postman but not in Thingworx
result
{"headers":"","RestFaultElement":{"summary":"Exception occurred when binding was invoked.\nException occurred during invocation of JCA binding: \"JCA Binding execute of Reference operation 'WO_PlugInCUpd' failed due to: Set object error.\nError binding the value of parameter P_EAM_WO_COMP_REC.\nAn error occurred when binding the value of parameter P_EAM_WO_COMP_REC in the APPS.BPEL_WO_PLUGINCUPD.EAM_PROCESS_WO_PUB$PROCESS_WO API. Cause: java.sql.SQLException: Inserted value too large for column: \"1.0\"\nCheck to ensure that the parameter is a valid IN or IN/OUT parameter of the API. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value \"-17072\" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.\n\". \nThe invoked JCA adapter raised a resource exception.\nPlease examine the above error message carefully to determine a resolution.\n","code":"17072","detail":"Inserted value too large for column: \"1.0\""}}
1 REPLY 1

Re: Rest API not working in Thingworx

A little more context maybe? The provided error message seems to be an SQL error message.

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.