Error "Failed to get data: An error occurred while converting the varchar value to JDBC data type INTEGER."

Created
October 08, 2021 23:19

Date Posted: 2019-06-27
Product: TIBCO Spotfire®

Problem:

Solution:

When executing or fetching data from an Information Link, the following error may occur.

ERROR 2017-06-02T12:37:05,276+0530 [1, #25, #381] api.common.InformationModelServiceCommon: Failed to get data: An error occurred while converting the varchar value to JDBC data type INTEGER.
com.spotfire.ws.api.common.InformationModelWebServiceException: Failed to get data: An error occurred while converting the varchar value to JDBC data type INTEGER.
   at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:654)
   at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:582)
   at com.spotfire.ws.api.query.QueryManagerService.getDataBlockFromDAT(QueryManagerService.java:1149)
The above exception may be encountered if the order of the Information Link elements as specified in the Information Designer and the SQL query are not consistent. To resolve this, compare "Original SQL" and "Modified SQL" in the Edit SQL dialog and check for sequence of column elements. Make sure that the sequence of column elements is same. Or try to click "Reset to Original" on the Edit SQL window if there is nothing modified in the WHERE clause of SQL.