Sorry Edwind but i receive the same error... <img goomoji="344" style="margin: 0pt 0.2ex; vertical-align: middle;" src="cid:344@goomoji.gmail"> Error Message: ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 916 ORA-06512: at line 1 Error Class Code: 23 Error Class Info: Could not update database entry. <div class="gmail_quote">2009/7/24 Edwind Richzendy Contreras Soto <<a href="mailto:richzendy@gmail.com">richzendy@gmail.com</a>> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> 2009/7/25 Tommaso Rossetto <<a href="mailto:tommaso.rossetto@gmail.com">tommaso.rossetto@gmail.com</a>>: <div><div></div><div class="h5">> Hi all, > > when I launch rhnpush I get this error message : > > Using POST request > Error pushing base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm: Error > 500Error Message: > ORA-12899: value too large for column > "SPACEWALK"."RHNPACKAGECHANGELOG"."TEXT" (actual: 3002, maximum: 3000) > Error Class Code: 54 > Error Class Info: > Package Upload Failed due to uniqueness constraint violation. > Make sure the package does not have any duplicate dependencies or > does not already exists on the server (500) > Waiting 1 seconds and trying again... > Uploading package base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm > Using POST request > Error pushing base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm: Error > 500Error Message: > ORA-12899: value too large for column > "SPACEWALK"."RHNPACKAGECHANGELOG"."TEXT" (actual: 3002, maximum: 3000) > Error Class Code: 54 > Error Class Info: > Package Upload Failed due to uniqueness constraint violation. > Make sure the package does not have any duplicate dependencies or > does not already exists on the server (500) > Waiting 4 seconds and trying again... > Uploading package base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm > Using POST request > Error pushing base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm: Error > 500Error Message: > ORA-12899: value too large for column > "SPACEWALK"."RHNPACKAGECHANGELOG"."TEXT" (actual: 3002, maximum: 3000) > Error Class Code: 54 > Error Class Info: > Package Upload Failed due to uniqueness constraint violation. > Make sure the package does not have any duplicate dependencies or > does not already exists on the server (500) > Waiting 2 seconds and trying again... > > > and this in the final : > > > Error Message: > ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated > ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 916 > ORA-06512: at line 1 > Error Class Code: 23 > Error Class Info: Could not update database entry. > > xargs: rhnpush: exited with status 255; aborting > > > Could someone help me to resolve it please? > There is something wrong in my oracle settings? > > many thanks. > </div></div>login in oracle using sqlplus, set max conections to 400, use this commands: # sqlplus spacewalk@xe SQL> alter system set processes = 400 scope=spfile; SQL> alter system set "_optimizer_filter_pred_pullup" = false scope=spfile; SQL> alter system set "_optimizer_cost_based_transformation" = off scope=spfile; SQL> alter system set query_rewrite_enabled = true; SQL> quit and restart oracle: # /sbin/service oracle-xe restart > > _______________________________________________ > Spacewalk-list mailing list > <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> > <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> > _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </blockquote></div> -- Tommaso Rossetto vicolo I Maggio , 13 Maserada sul Piave - 31052 (TV)