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:

---
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@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@spacewalk setup]#
---


Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to