DateTimeOffset data type of SQL Server fails in Spotfire. Error Message, "Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)"

DateTimeOffset data type of SQL Server fails in Spotfire. Error Message, "Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)"

book

Article ID: KB0075469

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

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.

Environment

All Supported OS

Resolution

Change the driver from SQL Server JDBC thin driver to SQL Server (Data Direct) driver of SQL Server datasource. 
 
Note: We generally do not recommend the Data Direct driver be used in production because of performance issues.

Issue/Introduction

DateTimeOffset data type of SQL Server fails in Spotfire. Error Message, "Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)"

Additional Information

http://blogs.msdn.com/b/jdbcteam/archive/2008/09/28/working-with-sql-server-2008-date-time-data-types-using-v1-2-jdbc-driver.aspx

Attachments

DateTimeOffset data type of SQL Server fails in Spotfire. Error Message, "Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)" get_app
DateTimeOffset data type of SQL Server fails in Spotfire. Error Message, "Unsupported JDBC data type in query result: datetimeoffset (HRESULT: 80131500)" get_app