Symptom
WRE 99998 and IES 109010 errors in Live Office universe query based on SAP BW datasource with optional prompt.
Environment
- BI 4.0 Sp02 patch 5.
- Windows 2008 64 bit.
- Tomcat 5.5
Cause
In Live Office, reporting against a universe based on SAP BW that has an optional prompt, and you select a prompt value longer than 3 characters, the query returns an error similar to Getdocumentinformation Exception (Error: WRE 99998) Database error: the MDX query SELECT { [MDX QUERY] } Failed to execute with the error Invalid MDX command. (IES 109010).
Resolution
Resolved via support patch 2.7
Keywords
Error: WRE 99998, Failed to execute with the error Invalid MDX command. (IES 109010) , KBA , BI-RA-WBI , Web Intelligence , Problem