Yesterday my AE (V.10) processes was stopped with the below error. I searched and found it was about MQWP identity reached the limitation.( https://support.microsoft.com/en-gb/help/2686673/arithmetic-overflow-occurred-error-is-generated-in-the-avicode-interce)
Luckily that it happened to the non-production system. So I stopped and started the system with Coldstart and problem was solved.
U0003592 UCUDB - Status: '22003' Native error: '8115' Msg: 'Arithmetic overflow error converting IDENTITY to data type int.'
U0003592 UCUDB - Status: '01000' Native error: '3606' Msg: 'Arithmetic overflow occurred.'
U0003594 UCUDB Ret: '3590' opcode: 'INSR' SQL Stmnt: 'INSERT INTO MQWP (MQWP_System, MQWP_CAddr...
Do we have other ways to reset this MQWP identity value "without doing the Coldstart" to avoid this error/situation in the Production system?
Thank you very much.