Product: TIBCO Spotfire®
Information link fails with error "ORA-01861(literal does not match format string)" while connecting to oracle data source
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
The same query runs fine when executed using SQL tools outside of Spotfire. 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')