Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

SAP Connector 6.3.1 - Object reference not set to an instance of an object

Hi everyone

Updated SAP connector at a client from "SAP Connector 5.8" to "SAP Connector 6.3.1".

New Connection string = CUSTOM CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=1;MSHOST=*HOSTNAME*;CLIENT=100;SYSID=prd;GROUP=*GROUP NAME*;Timeout=3600;SNC_MODE=false;SNC_QOP=9;advancedProperties=false;ConvRoutine=false;CheckSeparator=false;Nulldate=true;RemoveAllBlanks=false;ReplaceNullvalue=true;Trace=false;DataTypeLegacyMode=false;PacketSize=20000;FetchBuffers=99999999;BufferPercentage=10;TimeOutBatch=600;TimeOutFetch=1200;TimeOutStartBatch=2400;BatchJobName=/QTQVC/READ_DATA;SenseVersion=11, 20, 12904, 0;XUserId=QOdOJRdORDbSWVJOGbYCK;XPassword=SbBLLYFMTbcOXXJOELJEDBBIUDdYWSNEVJJCTQB;";

Previously when running the following script it executed without any problems:

"INSPECTION LOT RESULTS":

LOAD

      [PRUEFLOS]   as [Inspection Lot Number],

      [VORGLFNR]   as [Node Number],

      [MERKNR]    as [Inspection Char Number],

      [ORIGINAL_INPUT]  as [Result];

SQL SELECT QAMR~PRUEFLOS QAMR~VORGLFNR QAMR~MERKNR QAMR~ORIGINAL_INPUT

FROM  QALS

JOIN  QAMR ON (QAMR~PRUEFLOS = QALS~PRUEFLOS);

Now after the Connector update I get the following error when running the script:

Object reference not set to an instance of on object.

SQL SELECT QAMR~PRUEFLOS QAMR~VORGLFNR QAMR~MERKNR QAMR~ORIGINAL_INPUT

FROM  QALS

JOIN  QAMR ON (QAMR~PRUEFLOS = QALS~PRUEFLOS);

Any advise will be greatly appreciated.

2 Replies
Employee
Employee

Re: SAP Connector 6.3.1 - Object reference not set to an instance of an object

Hi Jacques,

We fixed this error in SAP Connector v6.3.2:

"A degrade occurring only in release 6.3 could cause a very limited number of SQL statements to fail (for example a statement containing JOIN in this Jira issue). The error is now resolved" (From release notes for v6.3.2)

So upgrading to version 6.3.2 should resolve your issue.

Regards,

// Thomas Örnmarker

SAP Connectors

Re: SAP Connector 6.3.1 - Object reference not set to an instance of an object

Indeed, it did solve my situation in which the same error occurred while trying to execute a simple SELECT ListOfAllFields FROM KNA1; No JOIN involved, and the error seems SAP system-dependent as I was trying to extract the same table simultaneously from multiple SAP systems. Only one failed.

Thanks for the solution.

Peter