Automate

 View Only

  • 1.  What is the allowed maximum volume of data in a query?

    Posted 03-01-2023 01:42

    Hello All,

    Can someone please, assist me with this case?

    I am trying to retrieve data from SAP S4 Hana, table MARC via Winshuttle. The file has about 113000 rows, which is a lot, but not the world. But, even if I limit the rows to 5000 (which is extremely little if you need large amounts of data), I still get the following error message: "The query exceeds the allowed Maximum length."

    Question:  What is the allowed maximum volume of data in a query?

    Thanks in advance.

    Marcel



    ------------------------------
    Marcel Dohnjenkah Gwangwaa
    Vitra IT Services GmbH
    ------------------------------


  • 2.  RE: What is the allowed maximum volume of data in a query?

    Employee
    Posted 03-09-2023 10:05
    Edited by Sigrid Kok 03-09-2023 10:07

    Hi Marcel 

    We don't impose any limits in the amount of data extracted. If extracted to Excel, it has 1M row limits, and SAP may have some limits on run time.

    Can you please share your query?  We might impose limits on the actual query.  For example the number of values in an IN operator.   Support article on this topic as an example: Customer Community

    https://customer.precisely.com/s/article/Error-Query-cannot-be-executed-because-the-query-length-exceeds-65536-characters-360023442352?language=en_US 

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: What is the allowed maximum volume of data in a query?

    Posted 03-10-2023 03:05

    is this from when you are running a query using the parameter of "in" using a dynamic lookup list?

    i get the same, there is definately a limit on the number of items you can search for in a dynaic list, i just dont know if that is a SAP limitation or Winshuttle, but i can get away with about 2000.

    if you are trying to query more data could you get what you need using a transaction to extract?



    ------------------------------
    Mick Jones
    NOBIA HOLDINGS U K LTD
    Darlington
    ------------------------------

    Original Message


  • 4.  RE: What is the allowed maximum volume of data in a query?

    Posted 03-16-2023 08:31

    Hello Sigrid,

    Sorry that it took me long to reply you. I had to request the query and the script from the end user first.

    He just sent them to me. You will find them as an attachments.

    Kind regards,

    Marcel

     

     


    Vitra IT Services GmbH
    Charles-Eames-Strasse 2, D-79576 Weil am Rhein
    T +49 7621 70 20, F +49 7621 702 32 42, info@vitra.com, www.vitra.com
    Geschäftsführung: Sonja Hornberger, Paula Indermühle, Christian Schneider
    Registergericht: Freiburg HRB 413546, Sitz der Gesellschaft: Weil am Rhein
    Datenschutzhinweise / Data protection notes




    Original Message