AnsweredAssumed Answered

Resetting MQWP IDENTITY value

Question asked by WimonchaiW. on Jun 13, 2018
Latest reply on Jun 22, 2018 by treal04

Hi,

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...

 

Question:

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.

Outcomes