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?
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?
I don't get any error message. Instead I am unable to store the whole data in vara.
I use Automic 2015 version
Hi @Wofgang ,I am using Automic Version 126.96.36.1997.
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...
which script do you use and how dose the report look.
do you have any PRINT statements for further diagnosis in the report?
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.
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#"
Hi @Wolfgang, Thanks for your update on the above.It is very helpful. Will update once if any more queries on this