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:
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.
Comments
0 comments
Article is closed for comments.