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.
