SAP Knowledge Base Article - Public

1574460 - Incorrect data in Crystal Reports with more than PacketSize records from BW via MDX after updating Transports

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

  1. Update Crystal Reports MDX Connectivity Transports in BW
  2. 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
, KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , Bug Filed

Product

Crystal Reports 2008 V1

Attachments

ADAPT01528342-FixedTransports.zip