SAP Knowledge Base Article - Public

3170798 - Error "CALL_FUNCTION_ILLEGAL_P_TYPE" in Analysis Office

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:

  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.

See Also

  • 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

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

Product

SAP Analysis for Microsoft Office all versions