topic Error in ODSMaxRows=10000000 in QlikView https://community.qlik.com/t5/QlikView/Error-in-ODSMaxRows-10000000/m-p/527405#M197096 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I have a problem I encounter in connection QvSAPDSOConnector.dll is a condition that has the connection string that allows read-only 10 million</P><P>record, this is the function that coast in the connection string: ODSMaxRows = 10000000. And when I change or exclude this value it returns me error.</P><P></P><P>And put it in a condition Where in the script, to decrease the size of data read so I can draw for smaller pieces of 10 million records,</P><P>but when I put Where the function, it returns me error in reading too.</P><P></P><P>Below is the script I'm using: </P><P></P><P><SPAN style="font-size: 15.0pt; font-family: 'Courier New'; color: blue;">CUSTOM</SPAN><SPAN style="font-size: 15.0pt; font-family: 'Courier New';"> <STRONG style="color: blue;">CONNECT</STRONG> <SPAN style="color: blue;">TO</SPAN> <SPAN style="color: maroon;">"Provider=QvSAPDSOConnector.dll;ASHOST=sp19in;SYSNR=12;CLIENT=302;ODSMaxRows=10000000;XUserId=DLdMGadNPDbSGbVMJLKB;XPassword=eXHEAadNNDdeWWFGSZMIF;"</SPAN>;<BR /> <BR /> <BR /> [0SD_O06]:<BR /> <STRONG style="color: blue;">Load</STRONG> *;<BR /> <STRONG style="color: blue;">SQL</STRONG> Select (NoKey) <BR /> 0BILL_CAT,<BR /> 0BILL_DATE,<BR /> from 0SD_O06<BR /> WHERE (0BILL_CAT) = 'A';<BR /> <STRONG style="color: blue;">STORE</STRONG> [0SD_O06] <SPAN style="color: blue;">INTO</SPAN> <STRONG><EM style="color: gray;">$(vEXTRATOR)</EM></STRONG>0SD_O06_PROD_01.QVD;<BR /> <SPAN style="color: green;">Drop table [IC_PNL_04/QIC_PNL_04]; </SPAN></SPAN></P><P></P><P><SPAN style="color: green; font-size: 15.0pt; font-family: 'Courier New';"><SPAN style="font-size: 10pt; color: #000000;">Any idea? Thnaks, </SPAN><BR /></SPAN></P></BODY></HTML> Mon, 01 Jul 2013 15:46:58 GMT 2013-07-01T15:46:58Z Error in ODSMaxRows=10000000 https://community.qlik.com/t5/QlikView/Error-in-ODSMaxRows-10000000/m-p/527405#M197096 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I have a problem I encounter in connection QvSAPDSOConnector.dll is a condition that has the connection string that allows read-only 10 million</P><P>record, this is the function that coast in the connection string: ODSMaxRows = 10000000. And when I change or exclude this value it returns me error.</P><P></P><P>And put it in a condition Where in the script, to decrease the size of data read so I can draw for smaller pieces of 10 million records,</P><P>but when I put Where the function, it returns me error in reading too.</P><P></P><P>Below is the script I'm using: </P><P></P><P><SPAN style="font-size: 15.0pt; font-family: 'Courier New'; color: blue;">CUSTOM</SPAN><SPAN style="font-size: 15.0pt; font-family: 'Courier New';"> <STRONG style="color: blue;">CONNECT</STRONG> <SPAN style="color: blue;">TO</SPAN> <SPAN style="color: maroon;">"Provider=QvSAPDSOConnector.dll;ASHOST=sp19in;SYSNR=12;CLIENT=302;ODSMaxRows=10000000;XUserId=DLdMGadNPDbSGbVMJLKB;XPassword=eXHEAadNNDdeWWFGSZMIF;"</SPAN>;<BR /> <BR /> <BR /> [0SD_O06]:<BR /> <STRONG style="color: blue;">Load</STRONG> *;<BR /> <STRONG style="color: blue;">SQL</STRONG> Select (NoKey) <BR /> 0BILL_CAT,<BR /> 0BILL_DATE,<BR /> from 0SD_O06<BR /> WHERE (0BILL_CAT) = 'A';<BR /> <STRONG style="color: blue;">STORE</STRONG> [0SD_O06] <SPAN style="color: blue;">INTO</SPAN> <STRONG><EM style="color: gray;">$(vEXTRATOR)</EM></STRONG>0SD_O06_PROD_01.QVD;<BR /> <SPAN style="color: green;">Drop table [IC_PNL_04/QIC_PNL_04]; </SPAN></SPAN></P><P></P><P><SPAN style="color: green; font-size: 15.0pt; font-family: 'Courier New';"><SPAN style="font-size: 10pt; color: #000000;">Any idea? Thnaks, </SPAN><BR /></SPAN></P></BODY></HTML> Mon, 01 Jul 2013 15:46:58 GMT https://community.qlik.com/t5/QlikView/Error-in-ODSMaxRows-10000000/m-p/527405#M197096 2013-07-01T15:46:58Z Re: Error in ODSMaxRows=10000000 https://community.qlik.com/t5/QlikView/Error-in-ODSMaxRows-10000000/m-p/527406#M197097 <HTML><HEAD></HEAD><BODY><P>Have you read <A _jive_internal="true" href="https://community.qlik.com/thread/6338">this discussion</A> already? </P></BODY></HTML> Tue, 02 Jul 2013 18:34:19 GMT https://community.qlik.com/t5/QlikView/Error-in-ODSMaxRows-10000000/m-p/527406#M197097 Gysbert_Wassenaar 2013-07-02T18:34:19Z