2 Replies Latest reply: Jan 9, 2017 7:13 AM by Peter Cammaert RSS

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

    Jacques Van Den Berg

      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.