Symptom
- Error in File ~tmp...rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: -2665 ]
- Failed to retrieve data from the database. Details: 22008: ODBC Teradata Driver Invalid date. Database Vendor Code: -2665.
- Failed to retrieve data from the database. Details: 22003: ODBC Teradata Driver. A character string failed conversion to a numeric value.Database Vendor Code: -3535.
Environment
- SAP Crystal Reports 2016 SP06
- Teradata ODBC driver version 16.20
Reproducing the Issue
- Update ODBC DSN to Teradata driver version 16.20
- In Crystal Reports refresh existing report that used to work with earlier versions of the driver
- Fails with an error
Cause
Date field reads differently in the new driver version, see attached Document. See deprecated Integer Time (page 282)
Resolution
Modify existing reports in CR Designer to accommodate new format or revert the DSN back to the previous version of the driver.
See Also
1338845 - How to find Product Availability Matrix (PAM) / Supported Platforms Documentation for SAP BusinessObjects products
Keywords
ODBC, Teradata, DateTime , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2016
Attachments
2526-108K (5).zip |