How to increase the row limitation in Automic vara

[MohammedNawazuddin613134]

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?

[FrankMuffke]

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

[MohammedNawazuddin613134]

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

I use Automic 2015 version

[MohammedNawazuddin613134]

Hi @Wofgang ,I am using Automic Version 11.2.0.2347.

[LuuLe]

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...  

[FrankMuffke]

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

[MohammedNawazuddin613134]

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.

[FrankMuffke]

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

[MohammedNawazuddin613134]

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