I'll try in a bit ;) thanks again Jan !!! Regards <div class="gmail_quote">On Wed, May 30, 2012 at 10:06 AM, Jan Pazdziora <<a href="mailto:jpazdziora@redhat.com" target="_blank">jpazdziora@redhat.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Tue, May 29, 2012 at 06:09:47PM +0200, stefano ciavarella wrote: > 'SPACEWALK-SCHEMA-1.5-TO-SPACEWALK-SCHEMA-1.6/125-ALTER-INDEX-RHNRAM.SQL.ORACL > ------------------------------------------------------------------------------ > spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle > > > Index dropped. > > ON rhnRam (server_id) > * > ERROR at line 2: > ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found > > > this is the error into spacewalk-schema-1.7.log </div>You may want to patch your spacewalk-schema-1.5-to-spacewalk-schema-1.6 directory with <a href="http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=40cbd633a357c572170f893f6f854f7f17fd3e02" target="_blank">http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=40cbd633a357c572170f893f6f854f7f17fd3e02</a> and then restore your database from backup and rerun the schema upgrade. <div class="HOEnZb"><div class="h5"> -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ 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> </div></div></blockquote></div> -- Stefano Ciavarella