Symptoms
Periodic task Check for available minor updates and hotfixes fails with with the following error:
Duplicate key violates unique constraint 'hotfixes_available_pkey' while executing 'error executing work'.
According to poa.log, the task tried to insert duplicate records in OA database:
com.parallels.pa.service.db.ejb.DBServiceBean Executing update: ' INSERT INTO hotfixes_available (name, display_name, build) VALUES( ?, ?, ? )' Parameters: [poa-6.0-3517_update03_KB125298, KB125298, poa-6.0-3517] [sqlpid: 9491]
com.parallels.pa.service.db.ejb.DBServiceBean Executing update: ' INSERT INTO hotfixes_available(name, display_name, build) VALUES( ?, ?, ? )' Parameters: [poa-6.0-3517_update03_KB125298, KB125298, poa-6.0-3517] [sqlpid: 9491]
Cause
There were duplicate records in repository http://download.automation.odinc.om/pa/6.0/updates/updates.xml. The issue has been reported as POA-99174 Task taskCheckAvailableHotfixes is failed in case hotfix duplicates in updates.xml.
Resolution
The files have been fixed on public repositories, now the periodic task Check for available minor updates and hotfixes completes successfully.