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
Delete the metadata cache for the affected user as per below steps:
- Make sure that all Excel sessions are closed;
- Delete the cache of the BW system in the client machine. The default path is: C:\Users\<USER>\AppData\Roaming\SAP AG\SAP BusinessObjects Advanced Analysis\cache;
- Check whether the issue remains.
The AO 2.8.16 version or higher already identify if the cache file is outdated, delete it automatically and ask the user to reopen the AO add-in. This new behavior is documented in the SAP Note 3255878.
See Also
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