SAP Knowledge Base Article - Public

1483189 - Error: 'Failed to retrieve data from the database' while creating Crystal Report using Teradata Stored Procedures

Symptom

  • Unable to use Teradata Stored Procedures for creating reports in Crystal reports.
  • Following error message appears while selecting stored procedure:
    'Failed to retrieve data from the database. Details: HY000: [NCR][ODBCTeradataDriver][Teradata Database]"..."is not a macro [Database Vendor Code: -3845]'

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • Teradata
  • ODBC

Reproducing the Issue

  1. Create a stored procedure in the Teradata database.
  2. Create a 32-bit System DSN connecting to the Teradata database using the ODBC driver
  3. Log on to Crystal Reports Designer
  4. Go to File > New > Database expert > Create new ODBC connection > Select the DSN
  5. Expand the database tab to select the stored procedure.

Cause

Crystal Reports does not fully support Teradata stored procedures with ODBC as middleware.

Resolution

Workaround: Use Teradata Macros instead of Teradata Stored Procedure.

Keywords

CR using SP, Teradata, Stored Procedure, SP, cr, crystal report , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013