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

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

Mon, 26 Jan 2026 21:26:37 GMT

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.

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

trm — Thu, 24 Nov 2016 08:20:09 GMT

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

Peter_Cammaert — Mon, 09 Jan 2017 12:12:12 GMT

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