cancel
Showing results for 
Search instead for 
Did you mean: 

Error java.lang.IllegalArgumentException when using getFromUserInstance

joseluisleitao
Explorer
0 Kudos

Hi everyone,

We have several Dashboards with data connections to Web Services, which have been published via Web Intelligences, and based on BEx Queries from BW.

Some of these web services are quite slow so we want to instance them so users don't have to wait 60 seconds or more just to open the dashboard.

The problem is that each User has different authorizations in BW for data and each user will see dashboards with different sets of data.

For this purpose we're using the "getFromUserInstance" parameter in the webservices data connection. We've created a publication and sent the reports to each user's inbox, where they are appearing correctly and with correctly filtered data.

The problem is that when we open the Dashboards we get one "java.lang.IllegalArgumentException" error message per data connection present in the dashboard.

Funny thing is that if I have a dashboard with only one data connection to a webi report and that report is the first one (sorted ascending by date) in the user inbox, the dashboard works fine. All other data connections and dashboards fail with this java error message.

Has anyone had previous experience using the "getFromUserInstance" parameter, and has anyone experienced these issues?

Note: We already have an open message in SAP Support for almost 20 days, but they've been unable to identify the problem.

Thanks,

Jose Luis Leitao

Platform:

SAP BO 4.0 SP02 Patch Level 21

Dashboard Designer 4.0 Patch 21

Accepted Solutions (1)

Accepted Solutions (1)

joseluisleitao
Explorer
0 Kudos

Hi everyone,

Only after escalating the issue to the SAP level 1 support team did we finally have a diagnosis.

Apparently when a Publication is executed with multiple documents, all the documents instances share a single ID for that publication.

The problem is that Xcelsius will select the first available document within that ID causing a mismatch between the webservice and the publication, causing an "IllegalArgumentException".

This is clearly a software bug which has no patch identified for now. I have no indication if this issue occurs also in later SP, so this might also occur in the latest BO versions.

Workaround? Yes, at least there's that.

We had to create multiple Publications, one for each WebIntelligence report. Not the nicest thing to manage but at least it works.

Again, support from SAP was atrocious and overall ineffective. They only showed real concern and involvement when the message was upgraded to Very High.

regards,

Jose Luis Leitao

Answers (3)

Answers (3)

former_member194862
Active Contributor
0 Kudos

Check the fiddler lof at time of error.It will show you the cuid of the query which is failing.

Identify the biws query and check whether prompts are passed or not

Let me know if you need any help in going through fiddler log

nikhil_joy2
Active Contributor
0 Kudos

Hi Jose,

there was a known issue in scheduling webi reports with blank optional prompts with the same error message for BO 4.0 SP02. please search for  the below KBA.

1681507 - Scheduling a Webi report with blank Optional prompts fails with the error "exception raised: java.lang.IllegalArgumentException".

Please check if you have any optional prompts for the reports blocks which you are accessing through the failing web services.

Regards,

Nikhil Joy

joseluisleitao
Explorer
0 Kudos

Hi,

Thanks for your suggestion, but the reports do not have optional prompts, and they schedule correctly.

The webservices do have filters, but even after removing them and republishing the error persists.

regards,

Jose Luis

former_member184594
Active Contributor
0 Kudos

What is your server version, SP and patch level? This might be a bug. I have discovered a couple of bugs with BO 4.0 SP5. SAP should help you.

joseluisleitao
Explorer
0 Kudos

Hi Zahid,

We're on BO4.0 SP02 Patch 21.

We have a message open with SAP, and they've review the logs but they still haven't found the problem.

former_member184594
Active Contributor
0 Kudos

Typical SAP

Are you scheduling your reports as Web Intelligence? If you have Instances scheduled as Excel reports in the users' inboxes for those web services, you get that error as well.

joseluisleitao
Explorer
0 Kudos

Yes, reports are published as Webintelligence to the inboxes. We're not using excel.

former_member184594
Active Contributor
0 Kudos

You can try upgrading your system to SP4 Patch 10 and see if you still have problems. This is probably some kind of bug. The future patches or SPs might fix this issue.

Good luck with SAP support.

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

moved to dashboards forum