1556056 - Error: 'Database Connector Error: BAPI Error #:0 Invalid MDX Command 2' when refreshing a report based off a BEx Query in Crystal Reports

SAP Knowledge Base Article - Public

1556056 - Error: 'Database Connector Error: BAPI Error #:0 Invalid MDX Command 2' when refreshing a report based off a BEx Query in Crystal Reports

Symptom

  • Error: 'Database Connector Error: BAPI Error #:0 Invalid MDX Command 2'
  • When attempting to refresh a report based off a BEx Query with a Hierarchy in Crystal Reports, it fails with the above error.

Environment

  • Crystal Reports 2008
  • SAP Integration Kit for Business Objects Enterprise XI 3.1
          
  • SAP NetWeaver 7.01

Reproducing the Issue

  1. In Crystal Reports, create a new report off an SAP BW BEx Query that contains a hierarchy. 
  2. Set the hierarchical grouping options.
  3. Drag and drop a field which has a long property technical name on the report.
  4. When refreshing the report, it fails with the error:  'Database Connector Error: BAPI Error #:0 Invalid MDX Command 2'

Cause

  • The technical name of the dimension property is too long.
  • The issue has been identified and tracked under ADAPT01491845

Resolution

  • The issue is resolved in the following product update and above:
       
    • Crystal Reports 2008
      • Fix Pack 3.5
          
    • SAP Integration Kit for Business Objects Enterprise XI 3.1
      • Fix Pack 3.5

Keywords

KBA , BI-BIP-CRS , SAP Crystal Reports Server , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , Bug Filed

Product

Crystal Reports 2008 V1