The SAP BEx extraction stops working after upgrade to SAP BW 7.50 SP14 (or later service pack).
An error occurs at reload of BEx connector script with the following error message:
‘RfcAbapRuntimeException: Access using a 'ZERO' object reference is not possible’.
The same error could also occur by opening a BEx query in the select dialog, however the error message, in that case, is the following one:
‘RfcAbapRuntimeException: Invalid subfield access: Offset negative‘.
The error only occurs for extraction from BEx queries with a certain configuration so not all BEx queries in the system are affected.
Environment:
SAP BW 7.50 Service Pack 14 introduced a change in an SAP delivered function module that Qlik uses for retrieving metadata about the currency and unit fields in the BEx query. Previously this function module did not fail with a dump when called with a Key Figure InfoObject but with SP14 (or later service packs) it fails with a short dump that is propagated out to the query execution code.
Resolution:
This is resolved in 7.0.4.
If no upgrade is possible, a patch is available from Qlik in the form of a transport file that needs to be imported into the SAP BW system. The patch is a correction of the BEx Connection code to make sure the function module is only called with characteristic InfoObjects. The patch does not affect the format or content of the data that is extracted from SAP.
The patch requires the transports for Qlik SAP Connectors version 7.0.2 to be installed first since it is only valid for the 7.0.2 version.
Note: With the 7.0.2 version of the BEx connector data type mapping was added to the connector. That might affect the outcome of existing BEx scripts. There is a connection string property that can be set to preserve the old behaviour of the BEx extractions. Please read the Release notes for 7.0.2 before upgrading the Qlik SAP connectors.
Please contact Qlik Support for further details on patch download and instructions.
Internal Investigation ID(s):
SAP-1985
