[Spacewalk-list] Problem enabling Monitoring

[Jan Hutař]

On Thu, 23 May 2013 08:06:44 +0000 "Kelle-Emden, Andreas"
<kelle-emden at rz.rwth-aachen.de> wrote:

> Hi all,
> 
> I'm trying to enable monitoring features on Spacewalk 1.9.
> Trying to enable it on the WebUI (Admin->Spacewalk
> Configuration->General) gives me the following error message:

Hello,
I have tried this on SWnightly (both PostgreSQL and OracleXE
backends) and can not reproduce.

Do you have upgraded Satellite? What does `rhn-schema-version`
say? What is your OS version? Can you find relevant pieces of
these logs?

/var/log/httpd/*error_log
/var/log/tomcat/catalina.out

Regards,
Jan



> ---
> Internal Server Error
> 
> The server experienced a problem which prevented your request
> from being filled out. It may not be possible to execute this
> action at this time.
> 
> Please help us correct this problem by contacting us with
> details of how you received this message.
> ---
> 
> Using the rhn-enable-monitoring.pl script on the console leads
> to the error below. Can you give me some directions what I
> have to do?
> 
> Thanks in advance!
> Andreas
> 
> ---
> [root at spacewalk setup]#
> /usr/share/spacewalk/setup/upgrade/rhn-enable-monitoring.pl
> --enable-scout error creating scout shared key.  Error:
> RHN::Exception: DBD::Oracle::st execute failed: ORA-02291:
> integrity constraint (SPACEWALK.RHN_SATCL_PHSLC_PHYS_LOC_FK)
> violated - parent key not found (DBD ERROR: OCIStmtExecute)
> [for Statement " INSERT INTO rhn_sat_cluster (
>       RECID,
>       TARGET_TYPE,
>       CUSTOMER_ID,
>       DESCRIPTION,
>       LAST_UPDATE_USER,
>       LAST_UPDATE_DATE,
>       PHYSICAL_LOCATION_ID,
>       VIP,
>       DEPLOYED
>     )
>     VALUES (
>       :recid,
>       'cluster',
>       :customer_id,
>       :description,
>       :last_update_user,
>       CURRENT_TIMESTAMP,
>       1,
>       :vip,
>       1
>     )
>   " with ParamValues: :customer_id="1", :description='RHN
> Monitoring
> Satellite', :last_update_user='installer', :recid="79", :vip='134.61.112.70']
>   RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 117
> RHN::Exception::DB::throw
>   RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 455
> RHN::DB::handle_error
>   RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 404
> RHN::DB::st::execute_h
>   RHN::DB::SatCluster /usr/share/perl5/vendor_perl/RHN/DB/SatCluster.pm
> 203 RHN::DB::db::do_h
>   main /usr/share/spacewalk/setup/upgrade/rhn-enable-monitoring.pl
> 63 RHN::DB::SatCluster::create_new
>   main /usr/share/spacewalk/setup/upgrade/rhn-enable-monitoring.pl
> 62 (eval)
> 
> Offending Query:
>     INSERT INTO rhn_sat_cluster (
>       RECID,
>       TARGET_TYPE,
>       CUSTOMER_ID,
>       DESCRIPTION,
>       LAST_UPDATE_USER,
>       LAST_UPDATE_DATE,
>       PHYSICAL_LOCATION_ID,
>       VIP,
>       DEPLOYED
>     )
>     VALUES (
>       :recid,
>       'cluster',
>       :customer_id,
>       :description,
>       :last_update_user,
>       CURRENT_TIMESTAMP,
>       1,
>       :vip,
>       1
>     )
> 
> Deploying config
> [root at spacewalk setup]#
> ---
> 
> 


-- 
Jan Hutar     Systems Management QA
jhutar at redhat.com     Red Hat, Inc.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130528/9590598b/attachment.sig>