2747788 - ODBC Teradata Driver Invalid date or a character string failed conversion to a numeric value in Crystal Reports

• 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.

• SAP Crystal Reports 2016 SP06
• Teradata ODBC driver version 16.20 

1. Update ODBC DSN to Teradata driver version 16.20
2. In Crystal Reports refresh existing report that used to work with earlier versions of the driver
3. Fails with an error

Date field reads differently in the new driver version, see attached Document. See deprecated Integer Time (page 282)

Modify existing reports in CR Designer to accommodate new format or revert the DSN back to the previous version of the driver.

1338845 - How to find Product Availability Matrix (PAM) / Supported Platforms Documentation for SAP BusinessObjects products

ODBC, Teradata, DateTime , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem