2 Replies Latest reply: Dec 17, 2012 11:52 AM by Daniel Baksa RSS

    SAP DSO Connector Failure - (No more memory available to extend an internal table).

    Daniel Baksa

      I have started receiving the following error (No more memory available to extend an internal table) when extracting data using the SAP DSO connector. We are currently using version 5.60.1064 and plan to upgrade as soon as able to the latest connector release. If I upgrade will this issue resolve itself or is this a BASIS configuration setting on the SAP side.

       

      Right now I can get the extraxcts to run if I reduce the column count in the select statement, my work around at this point is to adjust the selects and break them into smaller extracts. Is there a configuration settting I can add to the conection string to resolve this issue? I have included our connection string and a sample select statement.

       

      Thanks You,

       

      Dan Baksa

      Dawn Foods - QV Developer

       

       

       

      CUSTOM CONNECT TO "Provider=QvSAPDSOConnector.dll;MSHOST=SAPPB1.dawnfoods.com;R3NAME=PB1;GROUP=Production;CLIENT=300;ODSMaxRows=10000000;PacketSize=5000;XUserId=MDVeZYRNJbaMXUVMXbXKXZJOEE;XPassword=bEOGQWNGDLaSHbVGJTbMWRC;";

       

       

      COPA_FACT_DSO_PART1:

      LOAD *;

      SQL Select (NoKey)

      0COMP_CODE,

      0CURTYPE,

      0CUSTOMER,

      0DISTR_CHAN,

      0PROFIT_CTR,

      0DOC_NUMBER,

      0FISCPER,

      0FISCYEAR,

      0MAT_SALES,

      0MATERIAL,

      0PLANT,

      0POST_DATE,

      0PROD_HIER,

      0S_ORD_ITEM,

      0SALES_DIST,

      0SALES_OFF,

      0SALESEMPLY,

      0SALESORG,

      0SHIP_TO,

      ZRPOSN,

      ZZUSNAM,

      ZFRGTC,

      ZSALE_QTY,

      ZVV100,

      ZVV101,

      ZVV201,

      ZVV300,

      ZVV301,

      ZVV302,

      ZVV303,

      ZVV304,

      ZVV305,

      ZVV308,

      ZVV309,

      ZVV310,

      ZVV313,

      ZVV400,

      ZVV401,

      from ZCOPAD01;

        • Re: SAP DSO Connector Failure - (No more memory available to extend an internal table).

          Dear Dan Baska,

           

          this is not really a QlikView problem. The problem occurs on the SAP side. Please get in touch with your SAP basis admin. He can check the details of the shortdump in the SAP system. It could be that your SAP admin will extend the parameters for the memory of internal tables or he will get in contact to you that you have to do some more restrictions in your query.

           

          Because the reason is that the amount of data, that will be collected by your query, is too huge for the current internal tables. There are some SAP parameteres that restricts the max. size of internal tables. These parameter can be adjusted if there is enough memory on your SAP servers.

           

          Best regards!

           

          Werner