Article ID: 129667, created on Oct 23, 2016, last review on Oct 23, 2016

  • Applies to:
  • Operations Automation 6.0

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.

Search Words

Failed Periodic Task "Check for available minor updates and hotfixes" fails

Failing Task: Check for available minor updates and hotfixes

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF