Java.lang.NullPointerException in dashboard with BIWS

[Former Member]

Hello Experts,

I have a dashboard with 12 Query as a Web Service connections (via BIWS). In the WSDL URL, GetReportBlockMethod, I have enabled filters (e.g.. State) to be passed. So in the input values section, I have assigned value to cell F3 and Operator is =

At any point of time, cell F3 may have a value, if not it will be blank. When I preview the dashboard, cell F3 will be blank, until the user selects a state and that is when cell F3 gets populated..Similar to this, I have another 5 fillter values that can be a blank or not a blank.

When I preview the dashboard, I run into the below pop up message which is annoying, although the data rendered is correct.

Is there anyway I can suppress this popup or how can I avoid it?

Thanks in advance,

Ann

[Former Member · Accepted solution]

Please check the link below which points towards the root cause of this issue..

http://scn.sap.com/thread/1260464

[Former Member · Accepted solution]

Hi Durga, are you certain that the issue I am facing is related to the one mentioned in the thread?

I am going to have to try it out. Thanks.

[Former Member · Accepted solution]

YEs .. The root cause of the issue is what mentioned in this thread..

[Former Member · Accepted solution]

Hi Durga, we made the necessary changes as per the thread. Unfortunately, I am still getting the pop up exception message

Ann

[mike_howles4 · Accepted solution]

Use an HTTP monitor like Fiddler or Charles when you run the dashboard so you can see perhaps some more error text coming from the dswsobje service from BOE.

We run up against this often and the error showing in the dashboard alone is not usually enough.  I suspect you have a mismatched QaaWS filter or webservice issue that may be resolved by republishing the web service and/or reimporting it and rebinding in data connections.  Just a thought, based on our experience on this error.

Also, operator I believe should technically be 'EQUAL' and not '='

[former_member190855]

You can either Uncheck "pop up error message" option in the connector

OR

Unchek refresh on load for the conenctor and set it to refresh only when the cell F3 changes.

[Former Member]

Where can I find pop up error message option in the connector?

Thanks!

[former_member190855]

Ann

Sorry, I mixed up that option with a different custom cache connector.

May be, try the second option I mentioned or What Durga suggested.

Runali