topic Re: SAP Connector in Connectivity & Data Prep

SAP Connector

eckromahn — Wed, 18 Mar 2020 15:12:14 GMT

Dear Support,

we have a SAP Connector and transports for 7.0.3 and the following error pop up when I chosse a query:

Invalid subfield access: offset negative.

Could you please explain us what is not correct in our query?

Thanks in advance

Eckhard

Re: SAP Connector

Hakan_Ronningberg — Wed, 18 Mar 2020 15:38:06 GMT

Hi,

Please give some more information about which connector you are using (in which situation does the error occur) and attach the connector log if possible. In this document you can read about where to find the log files (page 3):

https://community.qlik.com/t5/QlikView-Documents/Qlik-Connector-for-SAP-Tips-and-Tricks-v2-1/ta-p/1651783

Regards,
Håkan

Re: SAP Connector

eckromahn — Thu, 19 Mar 2020 07:42:47 GMT

Hi Håkan,

we are using 7.0.3. the latest Version oft the SAP connector.

And that is the Error Message in the log:

>> Info entry 2020-03-19 08:35:29.509 [Thread 1]
Trace directory changed from .\ to C:\ProgramData\Qlik\Custom Data\QvSAPBExConnector\Log\QvSAPBExConnector-3\19\
>> Error entry 2020-03-19 08:35:30.141 [Thread 1]
[SERVERTYPE=0 ASHOST=deabaepas02.grtgroup.com CLIENT=100 SYSNR=02 LANG=EN USER=GO-QLIK_BAE PASSWD=******** BEX_LEGACY=0 SNC_MODE=0 SNC_SSO_USER_UPPERCASE=0 SNC_SSO_TYPE=UN SNC_QOP=9 NAME=DefaultDestination]
SAP.Middleware.Connector.RfcAbapRuntimeException: Invalid subfield access: Offset negative
   at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
   at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count)
   at SAP.Middleware.Connector.RfcConnection.ReadRfcIDBegin(Int32& length)
   at SAP.Middleware.Connector.RfcConnection.ReadUpTo(RFCGET readState, RfcFunction function, RFCID toRid)
   at SAP.Middleware.Connector.RfcConnection.RfcReceive(RfcFunction function)
   at SAP.Middleware.Connector.RfcFunction.RfcDeserialize(RfcConnection conn, IRfcIOStream stream)
   at SAP.Middleware.Connector.RfcFunction.RfcCallReceive(RfcConnection conn, IRfcIOStream stream, RFCID rid)
   at SAP.Middleware.Connector.RfcFunction.Invoke(RfcDestination destination)

Thanks in Advance

Eckhard

Re: SAP Connector

Hakan_Ronningberg — Thu, 19 Mar 2020 07:54:32 GMT

Hi Eckhard,

Is there a more extensive BEx connector log in the path: below?
C:\ProgramData\Qlik\Custom Data\QvSAPBExConnector\Log

Can you attach the used script or does the error occur when you are creating the script?

Regards,
Håkan

Re: SAP Connector

eckromahn — Thu, 26 Mar 2020 07:18:21 GMT

Hi Hakan,

we implement a new patch for two transports and we are testing in the moment if our problem is solved.

Regards

Eckhard