[Spacewalk-list] Problem enabling Monitoring

[Kelle-Emden, Andreas]

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 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]#
---


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5550 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130523/06c1dbd3/attachment.p7s>