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
- In Crystal Reports, create a new report off an SAP BW BEx Query that contains a hierarchy.
- Set the hierarchical grouping options.
- Drag and drop a field which has a long property technical name on the report.
- 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 Server , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , Bug Filed
Product
Crystal Reports 2008 V1