[rhn-users] Deleteing system from a satellite server

[Clifford Perry @ Red Hat]

The rhn-satellite-users list would be a better place to post this
question. 

I would recommend to contact support. I suspect that this system has an
older database schema which is the cause of this. The system you are
trying to delete was activated to allow the RHN Applet program to work
with it. 

Regards,
Clifford. 

On Thu, 2005-04-21 at 21:01 +0100, Nick Bruton wrote:
> Hi,
> 
> I am unable to delete a system from my satellite-server (Version 3.4.0)
> 
> The error message is .....
> 
> [Thu Apr 21 15:01:15 2005] [error] Execution of 
> /var/www/html/network/systems/details/delete_confirm.pxt failed at Thu Apr 
> 21 15:01:15 2005: RHN::Exception: DBD::Oracle::st execute failed: 
> ORA-02292: integrity constraint (REDHAT.RHN_SERVER_UUID_SID_FK) violated - 
> child record found!ORA-06512: at "REDHAT.DELETE_SERVER", line 95!ORA-06512: 
> at line 2 (DBD ERROR: OCIStmtExecute) [for statement ``BEGIN! 
> delete_server(?);!END;!'' with params: :p1='1000010121'])!  RHN::DB 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/RHN/DB.pm 214 
> RHN::Exception::DB::throw!  RHN::DB::Server 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/RHN/DB/Server.pm 1052 
> RHN::DB::handle_error!  RHN::DB::Server 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/RHN/DB/Server.pm 1045 (eval)! 
> Sniglets::Servers 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/Sniglets/Servers.pm 1049 
> RHN::DB::Server::delete_server!  PXT::ApacheHandler 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/PXT/ApacheHandler.pm 608 
> Sniglets::Servers::delete_server_cb!  PXT::ApacheHandler 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/PXT/ApacheHandler.pm 107 
> PXT::ApacheHandler::pxt_parse_data!  PXT::ApacheHandler 
> /usr/lib/perl5/site_perl/5.6.1/i386-linux/PXT/ApacheHandler.pm 107 (eval)! 
> main /dev/null 0 PXT::ApacheHandler::handler!  main /dev/null 0 
> (eval)!!Offending Query: BEGIN!  delete_server(?);!END;!
> 
> Can anyone help please
> 
> Thanks Nick
> 
> ----------------------------------------------------------------------------
> Nick Bruton                                          PADI Divemaster #624215
> University of Bristol                                Yamaha YZF R1
> Computing Service
> Tyndall Avenue
> Bristol BS8 1UD
> Tel: 0117 9288193
> 
> _______________________________________________
> rhn-users mailing list
> rhn-users at redhat.com
> https://www.redhat.com/mailman/listinfo/rhn-users