I'm using the Advanced Excel Forge component to open a template, fill in cells and then download. I've done this many times without issues, but this time I'm exporting over 48,000 rows with 115 columns each.
After a while, I get a "Request failed with status 504" error. I understand this is a server timeout, but I have the server request timeout set for over 4 hours. I get the error well before that. When in debug mode, no error is triggered in Service Studio.
What's going on here? How can I avoid this error?
Thanks for the update. Looks like it's a memory issue on the Platform Server while processing this data . You can see that the Virtual Memory has reached 2TB which is not normal. Could you try adjusting the strategy to fetch data and create the Excel file in batches?
Does not look it's a timeout issue. Can you repeat the process with may be half / quarter the rows from the same data set to see if the issue persist ? Also it's worthwhile to check the error log in Service Center to see if it's issue with the data.
It worked with around 22,000 rows.
Working on it already!
I'm creating a binary file and passing it back and forth to/from the server action that fills in the cells. The batch files will run from 1 to 22,000+ records. There will be around 20 batches.
I'm testing now and will let you know the outcome.
That worked. Thanks!
Happy to hear that it is working :)
hallo @Jeff Kest ,
can you please share service center error
TenantUsers
User (23)
Session Id+bQfSXpYqEebHbCz7xSr1g==
ServerE3T24-DV58T0
Source
MessageRequest failed with status 504
Environment InformationeSpaceVer: Id=10334, PubId=0, CompiledWith=11.21.0.39357RequestUrl: https://rsc-dev.outsystemsenterprise.com/CBATracking/moduleservices/log?clientTimeInMillis=1730013270643 (Method: POST)AppDomain: /LM/W3SVC/1/ROOT/CBATracking-902-133744832524243629FilePath: D:\OutSystems\Platform Server\running\CBATracking.01698531328\ClientIp: 10.14.108.193 X-Forwarded-For: 76.223.242.55Locale: en-USDateFormat: yyyy-MM-ddPID: 5244 ('w3wp', Started='10/11/2024 6:24:50 AM', Priv=2284Mb, Virt=2117276Mb)TID: 127Thread Name:.NET: 4.0.30319.42000Client Runtime Packages: client-runtime-core= 3.31.0;client-runtime-view-framework-react= 3.9.0;client-runtime-widgets= 3.15.0;Client-Side Log
StackAction Name: Report_SpecTimeline_ExportDatabaseEndpoint: screenservices/CBATracking/MainFlow/rptSpecClient_Parameters/ActionReport_SpecTimeline_ExportDatabase CommunicationException: Request failed with status 504 at https://rsc-dev.outsystemsenterprise.com/CBATracking/scripts/OutSystems.js?5X3ZVRM+Rn2sb_x7+4GgkQ:3:6619 at XMLHttpRequest. (https://rsc-dev.outsystemsenterprise.com/CBATracking/scripts/OutSystems.js?5X3ZVRM+Rn2sb_x7+4GgkQ:3:2648)