I have a scheduled job that generates a xlsx file that should contain over 15k rows. Sometimes when the job runs it contains the correct number of rows, however most of the time it only contains 10k rows with the last row containing the string '...'
The max rows for xlsx I have set to 250k and I also increased the default max rows from 10k to 20k in case that was causing it.
When I run the report manually it contains the correct number of rows every time.
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I've uploaded a 5.3-snapshot file to the nightly folder. Please download and use that in a test environment. Create one job for the file in question and add a DEBUG logger for art.output.StandardOutput and then we can have a look at the logs when only 10k are produced.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been running the job with this version and have not been able to duplicate the problem. I recreated the job in my prod instance and still it randomly has the issue. Maybe I will delete the report and recreate it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a scheduled job that generates a xlsx file that should contain over 15k rows. Sometimes when the job runs it contains the correct number of rows, however most of the time it only contains 10k rows with the last row containing the string '...'
The max rows for xlsx I have set to 250k and I also increased the default max rows from 10k to 20k in case that was causing it.
When I run the report manually it contains the correct number of rows every time.
Thanks!
Not sure what would be causing it. If you run the job manually from the jobs page do you always have the correct number of rows?
Yes I do. Just seems to be with the scheduled job
OK. Could you post your max rows specific setting.
Default max rows: 20000
Specific Max Rows: xlsx:500000
Default max rows: 20000
Specific Max Rows: xlsx:500000
Hi,
I've uploaded a 5.3-snapshot file to the nightly folder. Please download and use that in a test environment. Create one job for the file in question and add a DEBUG logger for art.output.StandardOutput and then we can have a look at the logs when only 10k are produced.
I have been running the job with this version and have not been able to duplicate the problem. I recreated the job in my prod instance and still it randomly has the issue. Maybe I will delete the report and recreate it.
OK. Hope it gets resolved.
Just an FYI I have resolved this issue by increasing the JVM memory and memory of the OS.
Hi Aaron,
Thanks for the note.