Automate

 View Only

  • 1.  Only 1million lines in the Query result-file

    Posted 01-14-2022 09:47
    Hi all,

    I have a question to our "old" Foundation Platform (version 11.2, Studio clients also 11.2).

    We have some trouble with a limitation of query-runs: the result is always a file with "only" 1million lines, even if there are more lines in the SAP table. I just modified all policies in the foundation... but the result is always the same limit of 1mio lines.


    Does anyone perhaps have an idea?

    Thanksa lot

    Regards, Ruediger

    ------------------------------
    Rüdiger Weiss | Business Application Manager
    Roche Diagnostics GmbH - Penzberg | 08856606008
    ------------------------------


  • 2.  RE: Only 1million lines in the Query result-file

    Posted 01-17-2022 04:46
    I believe Excel's limit for rows in a sheet is a bit over 1 000 000. Could this be the reason?

    ------------------------------
    --
    ------------------------------

    Original Message


  • 3.  RE: Only 1million lines in the Query result-file

    Posted 01-19-2022 01:24

    Hi,
    I use Access for > 1 milj records.

    Had the same issue in Excel, already did multiple download ranges, but it limits searches/lookup's.



    ------------------------------
    John van Schuppen | Masterdata specialist
    JACOBS DOUWE EGBERTS Export NL B.V. | +31646600365
    ------------------------------

    Original Message