Error while executing function module BICS_PROV_OPEN

I just got access to a NetWeaver 7.5 SP2 and I want to test it with Analysis Office 2.3. So I open Excel and insert a query. And here we go first error: "unable to open data source", so I thought maybe the query is broken and I developed a new query and insert it. Here we go, same error. Maybe queries don't work, so I insert a InfoCube directly. Same error...

 

Now I refresh the insert query and got an Analysis Office message: Error while executing function module: BICS_PROV_OPEN

In the explanation was one line with the hint "wrong parameter type in an rfc call", so I looked into st22 and saw a dump which the message: CALL_FUNCTION_ILLEGAL_P_TYPE

The explanation of this dump is "This error appears if parameters submitted incorrectly in a Remote Function Call."

 

I searched but found nothing which should help me. After a longer research I found in the SCN this thread and the simple solution is:

 

Delete all contents in C:\Users\<your_user>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\cache

 

After deleting the content, close Analysis Office and it works. Either the Analysis Office message or the BW dump explain the solution. But maybe someone has the same issue, this is the solution.

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 € 1
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 € 1

Write a comment

Comments: 2
  • #1

    Ksenia (Thursday, 12 January 2017 15:13)

    Thanks a lot, finally I fixed that issue!

  • #2

    Tobias (Friday, 13 January 2017 11:58)

    You are welcome.