Dear Experts,
We are running Automic on V21 SP5 HF1 with alternative Schema. Few days earlier, we had an outage of around 8 hours and in the Automic CP logs, we noticed the following error.
0240914/021829.575 - 61 U00045014 Exception 'com.automic.database.api.DBException: "INSERT INTO MQ1WP (MQWP_BAcv,MQWP_BAddr,MQWP_BSRName,MQWP_BTable,MQWP_CAcv,MQWP_CAddr,MQWP_CSRName,MQWP_DRole,MQWP_FAddr,MQWP_Len,MQWP_Msg,MQWP_Priority,MQWP_SchedTime,MQWP_Status,MQWP_System) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,convert(datetime,convert(varchar(max),getutcdate(),20),20),?,?)"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():573'.
20240914/021829.575 - 61 U00045015 The previous error was caused by 'com.microsoft.sqlserver.jdbc.SQLServerException: "Arithmetic overflow error converting expression to data type int."' at 'com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError():265'.
20240914/021829.575 - 61 U00003620 Routine 'com.automic.kernel.impl.DBAction' forces trace because of error.
20240914/021829.575 - 61 U00003450 The TRACE file was opened with the switches '0000000000000000'.
20240914/021829.762 - 61 U00003449 Output to the TRACE file is finished.
We checked from different angles and noticed the data sequence on the MQ database has the datatype as bigint. We have int in our development and quality system and not sure how it got changed to bigint only in our production systems.
So we changed the minimum and Maximum value as below .
Post change, system is able to startup and operations could be resumed.
Does anyone faced similar issue in your environment ?
Our Automic production systems runs non stop for the last 10 months with average executions of 25Million per month. Not sure whether it is linked with the executions sequence numbers ?
Your inputs are highly welcomed.
Regards
Vimalan