Symptom
Incorrect data in Crystal Reports with more than PacketSize records from BW via MDX after updating Transports including the following symptoms
- Fewer Records than MDX Test
- More Records than MDX Test
- Data from the wrong column
- Data from the wrong row
By Default PacketSize is 10000 as defined in [HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\SAP\BW MDX Query Driver]
Environment
SAP BW
- SAP BW 701 SP2 with SAP Note 1232751 applied and later
SAP CR Integation Kit
- XI 3.1 + Service Pack 3 + Fix Pack 3.5
- crdb_bwmdx.dll version 12.3.5.925
- MDX Query Connectivity Transports K900034.R72 and R900034.R72
- XI 3.1 + Service Pack 3 + Fix Pack 3.1, 3.2, 3.3, 3.4
- crdb_bwmdx.dll versions 12.3.1.684, 12.3.2.753, 12.3.3.812, 12.3.4.895
- MDX Query Connectivity Transports K900007.R72 and R900007.R7
- XI 3.1 + Service Pack 2 + Fix Pack 2.8, 2.9, 2.10, 2.11
- crdb_bwmdx.dll versions 12.2.8.638, 12.2.9.698, 12.2.10.810, 12.2.11.906
- MDX Query Connectivity Transports K900025.r68 and R900025.r68
- Crystal Reports 2011
- Crystal Reports 2011 + Support Pack 1
- BOE 4.0
- BOE 4.0 + Support Pack 1
- Embedded Analytics in Business Suite
Reproducing the Issue
- Update Crystal Reports MDX Connectivity Transports in BW
- Create or Refresh a Crystal Report via MDX from BW with more than PacketSize* records
* By Default PacketSize is 10000 as defined in [HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\SAP\BW MDX Query Driver]
Cause
Regression in Crystal Reports MDX Connectivity Transports described in ADAPT01528342
Resolution
Ask your SAP BW Administrator to install the attached Crystal Reports MDX Connectivity Transports into your SAP BW System.
With the resolution of ADAPT01528342 these updated Crystal Reports MDX Connectivity Transports will be included in the following releases.
- XI 3.1 Fix Pack 2.12
- XI 3.1 Fix Pack 3.6
- XI 3.1 Service Pack 4
- Crystal Reports 2011 Support Pack 1 + Critical Patch 2
- Crystal Reports 2011 Support Pack 2
- BOE 4.0 Support Pack 1 + Critical Patch 2
- BOE 4.0 Support Pack 2
- BOE 4.1
See Also
Please See KBA 1767542 to increase the default PacketSize
Keywords
- Crystal Reports
- MDX
- BW
- Incorrect Data
- Columns mismatched
- Values shifted
Product
Attachments
ADAPT01528342-FixedTransports.zip |