Product: TIBCO Spotfire®
DateTimeOffset data type of SQL Server fails in Spotfire. Error Message, "Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)"
Below error message can appear while using the DateTimeOffset data type column in the information link with SQL Server.
======================================
Error message: Could not open information link.
TargetInvocationException at Spotfire.Dxp.Framework:
Exception has been thrown by the target of an invocation. (HRESULT: 80131604)
Stack Trace:
at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)
at Spotfire.Dxp.Forms.Data.InformationDesigner.DesignerFormController.ExecuteInformationLink(CachedInformationLinkElement informationLink)
ImportException at Spotfire.Dxp.Data:
Failed to execute data source query. (HRESULT: 80131500)
Stack Trace:
at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
at Spotfire.Dxp.Data.DataFlow.Execute()
at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.ExecuteQueryCore2()
at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
....(Full Error message attached)
InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)
======================================
Root Cause: DateTimeOffset data type column is not supported in Spotfire while making use of SQL Server JDBC thin driver.
Change the driver from SQL Server JDBC thin driver to SQL Server (Data Direct) driver of SQL Server datasource.
Comments
0 comments
Article is closed for comments.