1416161 - Crystal Reports fail with Database Vendor Code -3535

SAP Knowledge Base Article - Public

1416161 - Crystal Reports fail with Database Vendor Code -3535

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

1332587

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI