Hello everyone,
I’m facing an error while generating an iOS mobile app in OutSystems. The build process fails with a database execution timeout.
Error message:
"Error executing query. Execution Timeout Expired.The timeout period elapsed prior to completion of the operation or the server is not responding.Operation cancelled by user. The statement has been terminated."
Context:
The error occurs during the mobile build cleanup process (DeleteApp_Mobile_Build_Source)
It is triggered by the ActionTimer_NativeBuildTracker
The request is executed via Service Center (_TimerHandler.asmx)
The stack trace indicates a SQL execution timeout (SqlCommand.ExecuteNonQuery)
Environment details:
Platform version: 11.36.0.45214
Service Center running locally (127.0.0.1)
iOS native build
I’ve attached the full build log for reference.
Has anyone encountered this issue before or knows how to resolve it? Any guidance would be greatly appreciated.
The Build log generate is going attached.Thank you in advance!
Hi @José Pedro Mascarenhas ,
This error is a DB execution timeout during the mobile build cleanup (DeleteApp_Mobile_Build_Source) triggered by ActionTimer_NativeBuildTracker. This usually means the DELETE is taking too long due to large data volume or DB performance.
Few Suggested fixes:
Run the clean-up in small batches (e.g. DELETE TOP(1000) in a loop) so each transaction finishes quickly and avoids timeouts.
If needed, increase the Platform Default Query Timeout in the Platform Configuration Tool (use with caution as it affects system queries).
Increase the Timer Effective_Timeout for the cleanup job in Service Center.
Hope this helps.
Regards,
Manish Jawla
Hi Manish, We’re on a self-managed DEV environment and are hitting DB execution timeouts on the mobile build cleanup triggered by ActionTimer_NativeBuildTracker (DeleteApp_Mobile_Build_Source).
To avoid unsupported manual deletes on OSSYS_* tables, could you please provide:
The exact list of DB tables (and key columns) affected by DeleteApp_Mobile_Build_Source in our Platform Server version (11.36.0.45214).
The official/supported SQL script to run cleanup in small batches (e.g., DELETE TOP(n) loop), including the safe order to avoid orphaned records / FK issues.
Any recommended index/statistics maintenance specifically for the affected tables to reduce cleanup duration.
Confirmation of the recommended Timer Effective_Timeout value for NativeBuildTracker cleanup in Service Center for this scenario.
Best regards,Pedro Mascarenhas