Spotfire: Information link error using Greenplum data source: “Failed to execute query: [Pivotal][Greenplum JDBC Driver][Greenplum]date/time field value out of range:”

Mike Roe

April 28, 2026 17:22
Updated

Date Posted: 2019-08-30
Product: TIBCO Spotfire®

Summary:

Error “Failed to execute query: [Pivotal][Greenplum JDBC Driver][Greenplum]date/time field value out of range:” appears when trying to open an information link based on a green plum data source.

Details:

When creating an information link, based on a greenplum data source, in Information Designer and trying to open the information link, error “Failed to execute query: [Pivotal][Greenplum JDBC Driver][Greenplum]date/time field value out of range:” appears and the information link cannot be opened.

One possible cause behind this error message can be that the information link is querying a database view, that itself queries other views containing date/time columns of different formats.
The error will appear even if the date/time columns are not fetched in the query, as long as the queried view itself rely on other views with the date/time columns of different formats.

Resolution:

Try any of the 2 options below to try to resolve the issue:

1. Make sure the date/time columns in the different views are in the same format.
2. Make sure to keep only date/time columns of the same format in the views.

Your Notifications (0)

Spotfire: Information link error using Greenplum data source: “Failed to execute query: [Pivotal][Greenplum JDBC Driver][Greenplum]date/time field value out of range:”

Comments

Related articles