3170798 - Error "CALL_FUNCTION_ILLEGAL_P_TYPE" in Analysis Office

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.

SAP Analysis for Microsoft Office

The issue might be caused by a corrupted cache file of the BW system in client machine.

Delete the metadata cache for the affected user as per below steps:

1. Make sure that all Excel sessions are closed;
2. 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;
3. 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.

• KBA - 2436298 - Error "Dereferencing of the NULL reference (RS_EXCEPTION-000)" when refreshing a workbook in AO
• SAP Note - 3255878 - The AO Metadata Cache needs to be updated

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