WIS 30650 and Free Hand SQL Reports

[DellSC]

BO 4.2 SP3 Patch 3 Hotfix 1
Oracle
Logged in as Administrator

We're having a problem opening some Webi reports in Rich Client. The reports were created in Rich Client using free-hand SQL.

Each of the reports that's having issues errors with "The action cannot be performed (WIS 30650)". However, the reports open with no problems in the HTML Webi Viewer and Designer. The problem is that we need to see/edit the query, which cannot be done in the online design tool.

I was able to duplicate the issue with a new report using these steps:

1. Create new report in Rich Client with free-hand SQL "Select sysdate from dual".

2. Save the report to the Administrator's favorites folder.

3. Quit Webi Rich Client completely.

4. Run Webi Rich Client again and open report from server - it opens correctly.

5. Modify report in BI Launchpad. Purge the data and save.

6. Try to open report from the server in Webi Rich Client and the error appears. Also, now the local copy of the report will not open.

Based on some research, I restarted the SIA, but that did not help things. I used the Administrator account and favorites folder to get around any potential security issues. I've found several SAP Notes and other posts with this error, but none of them seem to apply to this situation.

-Dell

[denis_konovalov]

This sounds like a possible product issue, i'd open an Incident with SAP under BI-RA-WBI component for a proper investigation.

[DellSC]

Thanks Denis! That was going to be my next step depending on what I found out here.

-Dell

[denis_konovalov]

well, the workflow is fairly simple and nothing you do should make it corrupted, yet it does. So - proper debug is needed.

[DellSC]

The interesting thing is that the report is NOT corrupted. I determined this morning that I can open it in the Java App on IE and get to the SQL with no issues. So it looks like there's something funky going on between the platform and the Webi Rich Client.

-Dell