Information link fails with error "ORA-01861(literal does not match format string)" while connecting to oracle data source
Article ID: KB0081939
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.0.x and higher |
Description
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.
==========================
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.
Issue/Introduction
Information link fails with the error, "ORA-01861(literal does not match format string)" while connecting to an Oracle data source.
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')
Here is an example:
TO_DATE('2016/01/01' , 'YYYY/DD/MM')
Feedback
Yes
No
Powered by
