search cancel

MS-SQL 2000: Arithmetic overflow occurred

book

Article ID: 89902

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): 6.00A

MS-SQL 2000: Arithmetic overflow occurred

Environment

Release:
Component: AAUTEN

Resolution

Detailed Description and Symptoms

?U0003590 DB-Fehler: 'SQLExecDirect', 'ERROR   ', '01000', 'Arithmetic overflow occurred.'

followed by:

U0003590 DB-Fehler: '', '', '', ''


Investigation

Check Serverlogs and/or Utility Logs for the 2 error messages:

U0003590 DB-Fehler: 'SQLExecDirect', 'ERROR   ', '01000', 'Arithmetic overflow occurred.'

U0003590 DB-Fehler: '', '', '', ''


Solution

?First truncate all MQ* tables, for version 6.00A it is the following:

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

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