Automic Workload Automation

Expand all | Collapse all

How to increase the row limitation in Automic vara

Jump to Best Answer
  • 1.  How to increase the row limitation in Automic vara

    Posted 07-04-2018 07:39 AM

    I have about 20000 records in Automic read table job but only 13000 records are getting stored in Automic vara.

    Is there any logic to increase the limit in Automic vara?



  • 2.  Re: How to increase the row limitation in Automic vara

    Posted 07-05-2018 06:02 AM

    Hi

     

    As far as I know there does not exist any hard coded ROW limitation.

     

    Do you get an error message?

     

    Which AE Version do you use?

     

    cheers, Wolfgang



  • 3.  Re: How to increase the row limitation in Automic vara

    Posted 07-05-2018 06:11 AM

    I don't get any error message. Instead I am unable to store the whole data in vara.

    I use Automic 2015 version



  • 4.  Re: How to increase the row limitation in Automic vara

    Posted 07-11-2018 03:00 AM

    Hi @Wofgang ,I am using Automic Version 11.2.0.2347.



  • 5.  Re: How to increase the row limitation in Automic vara

    Posted 07-11-2018 12:39 PM

    Like Wolfgang mention, I also don't recall on any hard coded limitation on the row of normal vara itself..

     

    The only one that i know of is with regards to sqlvara (SQLVARA_MAX_ROWS) but that setting normally just limit the maximum number of line that can be return by a sql/sqli vara itself...  



  • 6.  Re: How to increase the row limitation in Automic vara

    Posted 07-11-2018 02:10 PM

    which script do you use and how dose the report look.

     

    do you have any PRINT statements for further diagnosis in the report?

     

    cheers, Wolfgang



  • 7.  Re: How to increase the row limitation in Automic vara

    Posted 07-12-2018 01:43 AM

    Hi @Wolfgang. Below is the script I am using to store the data in vara.

     

     

    For the above script I am getting in the last report(Post Processing Tab) as the no. of records as 23437.

    Whereas is in Report tab I am getting 13200 records.

    So finally in the vara I am getting 13200 records.



  • 8.  Re: How to increase the row limitation in Automic vara
    Best Answer

    Posted 07-12-2018 02:38 AM

    Hi

     

    strange...

     

    You can put a GET_PROCESS_INFO below the PREP_PROCES_XXto check how many Rows it would process, just for debugging purposes:

    :SET &LNR# = GET_PROCESS_INFO(&HND#, ROWS)

    : PRINT "Amount: &LNR#"

     

    cheers, Wolfgang



  • 9.  Re: How to increase the row limitation in Automic vara

    Posted 07-12-2018 05:24 AM

    Hi @Wolfgang, Thanks for your update on the above.It is very helpful. Will update once if any more queries on this