Symptom
- com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: At least one BEx variable is missing a required value. Use the "Set Variables" to provide the missing values error when list of values is retrieved for WebI Query level filter.
- With the second refresh it gives "com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)" error.
Environment
- SAP BusinessObjects Business Intelligence Platform 4.0
Reproducing the Issue
- Create Mandatatory filter in Characteristic Restriction of BEx designer (eg date range).
- Add some dimension and key figures in rows and columns.
- Save the query.
- Create a WebI report based on BICS connection on top of same BEx query in BI 4.0 .
- Drag some dimension and key figures in Result Objects and add one Dimension as Query filter and make its as prompt.
- Refresh the report, prompt screen appears.
- Prompt screen displays two prompts which are mandatory date range filter coming from BEx query and second coming from Webi quey filter.
- Ignore BEx level prompt and navigate to WebI query filter.
- Enter '*' to retrieve the list of values for WebI prompt.
- WebI prompt gives "com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: At least one BEx variable is missing a required value. Use the "Set Variables" to provide the missing values" error.
- With the second refresh it gives "com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270)" error.
Cause
- As the BEx level filter is mandatory, input value for mandatory BEx filter should be given first.
- This is expected behavior with BI 4.0( See KBA 1984983 )
- Starting from BI 4.1, if BEx query has Mandatory prompts Set Variable pops up first before going to Query Panel.
- This is not case with BI 4.0, it gives Query Panel directly even if BEx query has Mandatory filters.
Resolution
- Navigate to "Set Variables" and provide a default input value for Mandatory BEx filter and click Ok.
- Run the report
Keywords
KBA , BI-RA-WBI , Web Intelligence , Problem
Product
Crystal Reports 2008 V0