Automate

 View Only

  • 1.  Winshuttle Query - limitations

    Posted 04-28-2021 11:52
    Hello does anyone know if the Query portion of Winshuttle has limitations as to how many lines it can read? I had a population of ~2000 lines and it returned me values for only around 1009.

    Also, my query reads data 'IN' an excel spreadsheet but the data output is not aligned with the original data in the sheet. Is there a way to ensure that Winshuttle only populates the corresponding rows that it was able to get the info on rather than sorting the output data in some other order?

    Thanks!

    ------------------------------
    Deepa Prashant | Consultant
    Lam Research Corp. |
    ------------------------------


  • 2.  RE: Winshuttle Query - limitations

    Employee
    Posted 04-28-2021 16:18
    Hi Deepa

    There is no defined limit on how much data Query can return.  There are factors, however, that can limit output:

    • Excel is limited to 1M rows.  You can alternately write to an Access DB or to SQL if you have Foundation/Studio Manager/Evolve.
    • SAP has a timeout.  If the datasets are large, then we recommend using Throttling and Chunk sizes to return data in chunks rather than all at once.
    • There entire SELECT statement it builds cannot exceed 65,536 characters (see the doc), which affects how many values can be used in an IN operator:  https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-connect/12/in-operator.htm
    • Suggest you also recheck your search criteria, as well.  Perhaps remove some (other than the IN operator) to see if perhaps you're inadvertently filtering the results.

    Hope this helps,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message