Grid2pdf timeout and memory problems = multiple page row bug

Suite and Optimus Suite 5
#1

I’m posting this issue in hopes someone else has come across it.
We have dhtmlxSuite_v26_pro_110318 and when exporting a grid to pdf we are hitting "Fatal error: Maximum execution time of 60 seconds exceeded " errors. When I add a set_time_limit(0); to the php file we then hit memory exhasution errors.

After much troubleshooting I’ve come to the conclusion that some of our results have too much data in the cells. The problem seems to be that wrapping a single row of cells across multiple pages causes the errors described above. When I limit the amount of text being exported in this particular column I get a pdf file generated.

Has anyone seen anything like this?
Is there a resolution for this?

#2

have too much data in the cells.
And how much is it?
( We can’t reconstruct issue locally, but maybe we are using too small data for testing )

#3

mygrid.setInitWidths(“30,55,80,120,80,80,80,300,80,80,80”);

the majority of columns have minimal text or descriptions.
One column (300 width) has a bunch of input and of course all of it needs to be displayed on this report.
I’ve already asked about restructuring the report to work around the issue but for the time being we’re stuck with this bug.

I piped the text through wc and it yields:
29 lines
365 words
2096 bytes

I cannot paste the text here as it contains sensitive data.

#4

Is there any update on this? We are seeing this same issue on a grid we are attempting to export.

Thanks

#5

With such amount of data export works correctly in our case, at least it produces valid excel file.
If issue still occurs in your case you can try to use java version of export or hosted version
viewtopic.php?f=23&t=18333