SAP Knowledge Base Article - Preview

2423211 - Database column names showing as Expr1000 when reporting off Amazon Redshift in Crystal Reports

Symptom

  • Fields name appear like: Expr1000, Expr1001, ...
  • When connecting to an Amazon Redshift data source from Crystal Reports via an ODBC connection, the database fields name display like: Expr1000, Expr1001,...
  • When refreshing a report based off an Amazon Redshift data source in Crystal Reports, it fails with the error: 
            
    "Failed to retrieve data from the database."       
    "Details: HY000:[Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: column <Table Name>.expr1000 does not exist. [Database Vendor Code: 30]"


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • Amazon Redshift

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

CR, redshift , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.