KBI 310682 Numerous An error condition has been detected by ArgSoft_DAL.cpp In Logs

Version

Argent AT — all versions

Date

Friday, 27 Sep 2013

Summary

In the Argent AT service logs, the following error messages appear:


27 Sep 2013 14:06:43.060 SVR1 ARG\admin ***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp (D6320_Commit_DB_Operation) at line 

                                        5131: DAL could not modify the record set. Microsoft Error Code = Update or Delete failed.. 



27 Sep 2013 14:06:43.060 SVR1 ARG\admin RelatorList::PrepareWaterMarkList: Failed to update ODBC table 'ARGSOFT_ARGENT_GUARDIAN_ULTRA_JOBWATERMARK'. 

                                        Retry in 3 seconds... 

Technical Background

This is typical when dealing with large environments where the database is being constantly updated with tasks

The JOBWATERMARK table holds updates to the status of running tasks (Running, Pending, Cancelled, Skipped, etc.)

As tasks complete, this database table is updated, which subsequently updates the “Scheduled Monitoring Tasks” screen in the GUI

When numerous tasks are being updated at the same time (and especially with Non-Stop Motor environments), frequent database locking can occur which results in the error message above

The “Retry in 3 seconds…” may be repeated multiple times until the record is successfully updated (e.g. the table-lock has been released)

Resolution

N/A