satellite-sync fails with ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated

Solution Verified - Updated -

Issue

satellite-sync fails with ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated

Complete error :
Exception Handler Information
Traceback (most recent call last):
  File "/usr/bin/satellite-sync", line 136, in main
    return satsync.Runner().main()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 199, in main
    ret = method()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 313, in _step_errata
    self.syncer.import_errata()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 1704, in import_errata
    sync_handlers.import_errata(chunk)
  File "/usr/share/rhn/satellite_tools/sync_handlers.py", line 417, in import_errata
    importer.run()
  File "/usr/share/rhn/server/importlib/importLib.py", line 617, in run
    self.submit()
  File "/usr/share/rhn/server/importlib/errataImport.py", line 177, in submit
    dml = self.backend.processErrata(self.batch)
  File "/usr/share/rhn/server/importlib/backend.py", line 700, in processErrata
    transactional=1)
  File "/usr/share/rhn/server/importlib/backend.py", line 1325, in __processObjectCollection
    return self.__processObjectCollection__(objColl, parentTable, childDict, **kwargs)
  File "/usr/share/rhn/server/importlib/backend.py", line 1495, in __processObjectCollection__
    return self.__doDML(dml)
  File "/usr/share/rhn/server/importlib/backend.py", line 1603, in __doDML
    self.__doInsert(dml.insert, dml.tables)
  File "/usr/share/rhn/server/importlib/backend.py", line 1609, in __doInsert
    self.__doInsertTable(tname, dict)
  File "/usr/share/rhn/server/importlib/backend.py", line 1621, in __doInsertTable
    insertObj.query(hash)
  File "/usr/share/rhn/server/importlib/backendLib.py", line 419, in query
    executeStatement(statement, values, self.count)
  File "/usr/share/rhn/server/importlib/backendLib.py", line 449, in executeStatement
    count = count + apply(statement.executemany, (), tempdict)
  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 103, in executemany
    return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 159, in _execute_wrapper
    raise apply(sql_base.SQLError, ret)
SQLError: (1, 'ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated\n', 'insert into rhnErrata (advisory_name, advisory, product, description, advisory_type, severity_id, notes, org_id, solution, id, topic, synopsis, last_modified, issue_date, update_date, locally_modified, advisory_rel, refers_to) values (:advisory_name, :advisory, :product, :description, :advisory_type, :severity_id, :notes, :org_id, :solution, :id, :topic, :synopsis, :last_modified, :issue_date, :update_date, :locally_modified, :advisory_rel, :refers_to)')

Environment

Red Hat Network Satellite v5.3

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In