1539835 - Errors 'Syntax error in program /CRYSTAL/SAPLPERS' and 'XML is invalid' in Universe Designer; errors 'Getting levels for hierarchy XXX (WIS 10901)' in WebIntelligence document.

SAP Knowledge Base Article - Public

1539835 - Errors 'Syntax error in program /CRYSTAL/SAPLPERS' and 'XML is invalid' in Universe Designer; errors 'Getting levels for hierarchy XXX (WIS 10901)' in WebIntelligence document.

Symptom

  • error 'syntax error in program /CRYSTAL/SAPLPERS' when testing universe connection
  • error 'XML is invalid' when parsing universe filter
  • error 'getting levels for hierarchy XXX (WIS 10901)' running WebI report

Errors/failures shown in the SOFA logs:

  • ThreadID<XXXX> SAPMODULE : RFC function call MDDataProviderBW.GetHierarchies failed
  • ThreadID<XXXX> SAPMODULE : Error getting hierarchies for dimension
  • RFC function MDDataProviderBW.GetHierarchies return with error code 18
  • RFC_ERROR_GROUP of RFC_ERROR_SYSTEM_FAILURE with reason Syntax error in program /CRYSTAL/SAPLPERS

Environment

  • Business Objects Enterprise XI 3.1 Service Pack 3 FixPack 3.1 (SP3 FP3.1)
  • Infoview and WebI Rich Client XI 3.1 SP3 FP3.1
  • SAP Integrated Solutions XI 3.1 SP3 FP3.1
  • SAP BW 7.0 EHP1 SP6

Reproducing the Issue

  • create a universe connection from BEx queries
  • generate a universe from BEx queries
  • parse a filter in the universe
  • refresh a WebI report created from the universe

Cause

The transport files provided by the SAP Integration Kit have not (or have incorrectly) been imported into the BW system.

Resolution

Make sure the BW system is up to date with the transports provided by the SAP Integration Kit.
The Transport directory of the SAP Integration Kit lists the transports that need to be imported in the BW system.
Use transaction code STMS to import the transports.

See Also

SAP note 1484086 - TABLE /CRYSTAL/PERS_ could not be activated when importing transports for SAP Integration XI 3.1 SP3

Keywords

KBA , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , BI-RA-WBI , Web Intelligence , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008