Information link fails with error "ORA-01861(literal does not match format string)" while connecting to oracle data source

Information link fails with error "ORA-01861(literal does not match format string)" while connecting to oracle data source

Versions: 7.0.x and higher

Details

TIBCO Spotfire Analyst throws the following error when running an Information Link based on Oracle Datasources.

==========================

Error message: Could not open information link.

ImportException at Spotfire.Dxp.Data: Failed to execute data source query. (HRESULT: 80131500) InformationModelException at Spotfire.Dxp.Data: Failed to execute query: ORA-01861: literal does not match format string (HRESULT: 80131500)

==========================

The same query runs fine when executed using SQL tools outside of Spotfire.

Resolution

To resolve the above error, apply date conversion explicitly to the date column elements in the information link queries.

Here is an example:

TO_DATE('2016/01/01' , 'YYYY/DD/MM')