Arithmetic overflow occurred at Insert in MQWP

Products

• CA Automic Operations Manager

Issue/Introduction

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

Environment

Release : 12.X

Component : AUTOMATION ENGINE using MSSQL database

Cause

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.

Resolution

Workaround:

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.

 

Solution:

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

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver15

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.