Information link error using Greenplum data source: “Failed to execute query: [Pivotal][Greenplum JDBC Driver][Greenplum]date/time field value out of range:”
Article ID: KB0077334
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | - |
Description
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.
Environment
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.
Issue/Introduction
Additional Information
Keywords: greenplum, information designer, information link, Failed to execute query: [Pivotal][Greenplum JDBC Driver][Greenplum]date/time field value out of range
Feedback
