Symptom
Migrated Crystal Reports fail with Database Vendor Code -3535
Environment
- BusinessObjects XI R3.1
- Crystal Reports 2008
- Teradata V12 Reporting datasource
- ODBC
- Teradata V12 client
Cause
Crystal 2008 is generating the sql differently than Crystal XI R2 with regard to timestamps. The DSN's are set up the same way:
Crystal XI R2 works
"TABLE"."DATEFIELD"<={d '2009-11-30'}
Crystal 2008 gets -3535 error:
"TABLE"."DATEFIELD"<='2009-11-30'
The issue has been identified and logged under Problem Report ID ADAPT01233938.
Resolution
This issue is scheduled to be addressed in a future Fix Pack or Service Pack.
See Also
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem