Announcement

Collapse
No announcement yet.

ACL Database error..

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ACL Database error..

    Hello,

    I have a problem with the ACLs within Oreon.
    When I try to add a new ACL and then click "Save" the following errors occur:
    Code:
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '1') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '2') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '23') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '25') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '31') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '32') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '33') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '24') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '34') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '39') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '62') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '63') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    DB Error : INSERT INTO lca_define_topology_relation (lca_define_lca_id, topology_topology_id) VALUES ('2', '64') [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    Any suggestions?


    To restore a (Oreon) backup is not an option for me..
    See my signature and look at "Server E" for details about the server config and feel free to ask if you need further information.

    Kind regards
    Thomas
    Last edited by Jogarem; 12 July 2007, 16:44.
    isyVmon 2.4 including Centreon 2.2, we are currently searching for BETA testers ;o)
    isyVmon 2.2 including Centreon 2.1.13, Smartphone APP, Splunk integration, Windows Monitoring and many more

    see http://www.isyVmon.com for more details in our FREEWARE Centreon appliance!

    (isyVmon is a product of Nagios & Centreon enthusiasts started in 2007 and is the very first ready-to-run appliance based on Centreon including Enterprise support and Enterprise features)

  • #2
    selfsolved..

    I've dropped the table "lca_define_topology_relation" and insert it again.
    No errors anymore and ACL works fine...
    isyVmon 2.4 including Centreon 2.2, we are currently searching for BETA testers ;o)
    isyVmon 2.2 including Centreon 2.1.13, Smartphone APP, Splunk integration, Windows Monitoring and many more

    see http://www.isyVmon.com for more details in our FREEWARE Centreon appliance!

    (isyVmon is a product of Nagios & Centreon enthusiasts started in 2007 and is the very first ready-to-run appliance based on Centreon including Enterprise support and Enterprise features)

    Comment

    Working...
    X