U00045009 Error is shown in the message window of the CA Automic Web Interface 12.1.1

Document ID : KB000100125
Last Modified Date : 03/07/2018
Show Technical Document Details
Issue:
After an update to CA Automic Workload Automation Version 12.1.1 an error message can be shown in the message window of the CA Automic Web Interface.
 
U00045009 Error during execution of message 'TIMER' the following exception was thrown: 'com.automic.database.api.DBException:INSERT INTO PMIA (PMIA_MsgInsert,PMIA_PMID_Idnr,PMIA_Timestamp) VALUES (?,?,?)'.
U00011801 Error in Server routine 'com.automic.performance.IssueTracker', Server: 'XX#WP019' AE-System: 'XX'
 
The message is caused by the JAVA WORK PROCESS (JWP).
 
In the JWP Logfile the following information about this error is available:
U00003525 UCUDB: ===> 'SELECT PMMA_Idnr, PMMA_PMMD_Idnr, PMMA_Timestamp, PMMA_WP_Name, PMMA_TcpIpAddr, PMMA_SrvType, PMMA_Interval FROM PMMA WHERE PMMA_PMMD_Idnr = ? and PMMA_Timestamp > ? AND PMMA_Timestamp <= ? ORDER BY PMMA_Timestamp desc '
U00045014 Exception 'com.automic.database.api.DBException: "INSERT INTO PMIA (PMIA_MsgInsert,PMIA_PMID_Idnr,PMIA_Timestamp) VALUES (?,?,?)"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():388'.
U00045015 The previous error was caused by 'java.sql.SQLIntegrityConstraintViolationException: "ORA-00001: Unique Constraint (XX.PK_PMIA) violated
"' at 'oracle.jdbc.driver.T4CTTIoer.processError():450'.
Cause:
This error is caused by the JWP while tracking issues in parallel with the JCP.
Resolution:
The bug is fixed with the following version:

Component: Automation Engine

Automation.Engine 12.2.0 - available to download
Automation.Engine 12.1.2 - available to download
Automation.Engine 12.1.1 HF1 - available to download