Question
Cognitonic Systems India Pvt Ltd
IN
Last activity: 11 Feb 2025 1:22 EST
Job scheduler is getting failed
Hi Team, There is an activity used in one of the job schedulers. When I run the activity standalone, no errors occur. However, when the activity is executed through the job scheduler, I encounter an error. What maybe the reason?
Error message: A commit cannot be performed because a deferred save of instance DATA-WORKATTACH-FILE Temp-Demo-XYZ-WORK D-2346!20241129T084128.367 GMT failed: code: SQLState: Message:
Maantic Inc
IN
There is a deferred save happening on a file which is failing. Can you check if there's a lock being held in Data-WorkAttach-File while running manually?
Cognitonic Systems India Pvt Ltd
IN
The Job Scheduler is working with the access group but not with the system runtime context.
Rulesstack Private Limited
IN
When the activity is executed through the job scheduler, it could be contending for database resources (e.g., multiple instances of the job trying to access the same resource) or encountering locking issue. A deferred save could fail if another process is holding a lock on the data or if the data is being accessed in a conflicting manner.
Solution: Check if there are any database locking issues or concurrent processes that could be affecting the deferred save. You can enable additional logging on database access to track any locks
Regards,
Mohd Qizer Uddin