Arithmetic overflow occurred at Insert in MQWP
search cancel

Arithmetic overflow occurred at Insert in MQWP


Article ID: 216128


Updated On:


CA Automic Operations Manager


U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR   ', '01000', 'Arithmetic overflow occurred.'


Release : 12.X

Component : AUTOMATION ENGINE using MSSQL database


This error occurs when the maximum count reached in your MQ tables. (MQWP_PK or MQWP_System)

Due to this, you will receive an arithmetic error.



To resolve the error follow below steps:

1.First truncate all MQ* tables mentioned below.

truncate table mqcp001
truncate table mqcp002
truncate table mqcp003
truncate table mqcp004
truncate table mqcp005
truncate table mqpwp
truncate table mqdwp
truncate table mqls
truncate table mqmem
truncate table mqsrv
truncate table mqwp

2. After truncating the MQ tables, a STARTMODE=COLD (Coldstart) of WP Server Processes is required.



Update to a fix version listed below or a newer version if available.

Fix version:

Component(s): Automation Engine


Automation.Engine 12.3.8 - Available

Automation.Engine 21.0.2 - Available


Additional Information

Below is the documentation for the Max value and its limitations from Microsoft documentation

The max value is: 2,147,483,647

MAXINT or INT_MAX is the highest number that can be represented by a given integer data type. In SQL Server this number for the INT data type is 2,147,483,647. The highest number you can store using the BIGINT data type is 9,223,372,036,854,775,807.