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:
Sent: 03-09-2023 10:04
From: Sigrid Kok
Subject: What is the allowed maximum volume of data in a query?
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.
Original Message:
Sent: 03-01-2023 01:41
From: Marcel Dohnjenkah Gwangwaa
Subject: What is the allowed maximum volume of data in a query?
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." <o:p></o:p>
Question: What is the allowed maximum volume of data in a query?<o:p></o:p>
Thanks in advance.
Marcel
------------------------------
Marcel Dohnjenkah Gwangwaa
Vitra IT Services GmbH
------------------------------