Autosequence for Purge is showing Deadlock error.

[Rahulsh]

Purge Historical Totals is giving error in 3700d logs

ri May 29 00:15:01 2020 | SERVER | AutoSeqServer | 0 | Autosequence 10211 step 9 of type S has begun. |
Fri May 29 00:15:01 2020 | SERVER | AutoSeqServer | 0 | Purge Historical Totals |
Fri May 29 00:15:01 2020 | SERVER | Autosequence.dll | 0 | {CALL MICROS.sp_PurgeHistory} |
Fri May 29 00:15:52 2020 | SERVER | Autosequence.dll | [highlight #FCE94F]0 | SQLExecDirect: (40001)[Sybase][ODBC Driver][SQL Anywhere]Deadlock detected |[/highlight] [highlight #FCE94F][/highlight]
Fri May 29 00:15:52 2020 | SERVER | AutoSeqServer | 0 | Autosequence 10211 step 9 of type S has encountered a stored procedure error...Error executing stored procedure. |
Fri May 29 00:15:52 2020 | SERVER | Autosequence.dll | 0 | Step completed. |
Fri May 29 00:15:52 2020 | SERVER | Autosequence.dll | 0 | Autosequence 10211 step 9 of type S has completed in 51 seconds.

Any Idea how we can fix this issue?

 

[Rahulsh]

Really need some help on this.

 

[Wildbar]

Have you tried rebuilding the database?

 

[Rahulsh]

Yes I did sadly it did not work.

 

[jimmymcp02]

What version of res are you using?

 

[Rahulsh]

5.5.3

 

[jimmymcp02]

I would try validating the database to see if you can find further error. note than validating on a live environment might render you db unusable set up a test environment and post back with the findings.