Symptom
The following error occurs in Analysis Office:
-------------------
Invalid program status\: RFC call BICS_PROV_OPEN returned an exception: RFC_ERROR_SYSTEM_FAILURE: Wrong parameter type in an RFC call - CALL_FUNCTION_ILLEGAL_P_TYPE
... or ...
ABEND RS_EXCEPTION (000): Dereferencing of the NULL reference
-------------------
This issue might occur only on specific PCs, but not all.
Environment
SAP Analysis for Microsoft Office
Cause
The issue might be caused by a corrupted cache file of the BW system in client machine.
Resolution
- Make sure that all Excel sessions are closed;
- Delete the cache of the BW system in the client machine. The default path is the following:
-> C:\Users\<USER>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\cache - Check whether the issue remains;
See Also
2436298 - Error "Dereferencing of the NULL reference (RS_EXCEPTION-000)" when refreshing a workbook in AO
Keywords
refresh, refreshing, error, existing, connection, cache, query, exception, error, nested, metadata, connect, RFC_ERROR_SYSTEM_FAILURE, CALL_FUNCTION_ILLEGAL_P_TYPE , KBA , BI-RA-AO-XLA , Excel Addin , Problem