Red Hat Bugzilla – Bug 1092608
ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID"): Package Upload Failed due to uniqueness constraint violation.
Last modified: 2017-02-01 04:30:05 EST
Description of problem: There is an error when syncing from arbitrary dump. Version-Release number of selected component (if applicable): spacewalk-backend-tools-1.2.13-82.el5sat.noarch spacewalk-schema-1.2.21-19.el5sat.noarch satellite-schema-5.4.0.28-1.el5sat.noarch How reproducible: always Steps to Reproduce: 1. Sync from arbitrary dump Actual results: 06:37:29 Red Hat Network Satellite - file-system synchronization 06:37:29 mp: /<somepath>/rhel5-i386-x8664-cloners-300pkgs-200erratas 06:37:29 db: rhnsat/<password>@rhnsat [...] 06:42:06 Importing channel errata 06:42:06 Importing *relevant* errata: clone-rhel-i386-server-5 (200) ________________________________________ Downloading:######################## SYNC ERROR: unhandled exception occurred: (Check logs/email for potentially more detail) <rhnFault class (code = 54, text = 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID") ')> (54, 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNERRATAPACKAGE"."PACKAGE_ID")\n', '\n Package Upload Failed due to uniqueness constraint violation.\n Make sure the package does not have any duplicate dependencies or\n does not already exists on the server\n ') +++ sending log as an email +++ Expected results: Sync should succeed.
We have re-reviewed this bug, as part of an ongoing effort to improve Satellite/Proxy feature and bug updates, review and backlog. We're closing this Bugzilla due to the Satellite 5 version this bug was reported against having been EOL (End-of-Life) [1]. Please re-open if the issue still exists in the latest Satellite 5 version. Tomas and Xixi [1] Satellite Life Cycle page: https://access.redhat.com/support/policy/updates/satellite