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