View Issue Details

IDProjectCategoryView StatusLast Update
1245RackTablesdefaultpublic2014-06-05 00:23
Reporterigorozco Assigned Toadoom42  
PriorityurgentSeverityminorReproducibilityalways
Status closedResolutionfixed 
PlatformVirtual Machine on ESXiOSUbuntuOS Version14.04
Product Version0.20.7 
Target Version0.20.8Fixed in Version0.20.8 
Summary1245: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'parent_entity_id' cannot be null (23000)
DescriptionWe are having an issue will launching the auto-populate for the UCS feature for Racktables. It looks to fail adding an entry into EntityLink for the info below. If change from ‘object’ to rack and insert the same information directly into the database, the create is successful. There is something with item type object that the database doesn’t link. Any pointers would be greatly appreciated.

Pdo exception: PDOException
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'parent_entity_id' cannot be null (23000)
at file /var/www/racktables/inc/database.php, line 3739
/var/www/racktables/inc/database.php:3739 execute(Array
(
    [0] => object
    [1] => 65
    [2] => object
    [3] => 67
)
)
/var/www/racktables/inc/database.php:1089 usePreparedInsertBlade('EntityLink', Array
(
    [parent_entity_type] => object
    [parent_entity_id] => 65
    [child_entity_type] => object
   [child_entity_id] => 67
)
)
/var/www/racktables/inc/ophandlers.php:3146 commitLinkEntities('object', '65', 'object', '67')
autoPopulateUCS()
/var/www/racktables/index.php:235 call_user_func('autoPopulateUCS')
Error info:
Array
(
    [0] => 23000
    [1] => 1048
    [2] => Column 'parent_entity_id' cannot be null
)
Parameters:
GET
module redirect
page object
tab ucs
op autoPopulateUCS
POST
object_id 65
ucs_login admin
ucs_password Password-removed
submit_x 13
submit_y 16
COOKIE
PHPSESSID 4u0m7n0d0qvk3da5jvfel05l91
Steps To ReproduceConfigure management object and use the UCS-Autopopulate option.
Additional Informationhttps://communities.cisco.com/docs/DOC-36827
Using UcsSdk-0.8.1.tar.gz

TagsNo tags attached.

Activities

adoom42

adoom42

2014-06-03 19:15

administrator   ~0002339

0.20.7 introduced DB triggers which enforce some rules. Please go to Configuration -> Object container compatibility, add two entries, then try to discover your UCS again.

- Parent / Child -
Management interface / Network switch
Management interface / Server chassis

If that resolves the problem, I'll add the entries to the 0.20.8 release.
adoom42

adoom42

2014-06-05 00:23

administrator   ~0002341

The reporter confirmed that the added rules solved the problem. The change has been committed to 0.20.8.

Issue History

Date Modified Username Field Change
2014-06-03 16:57 igorozco New Issue
2014-06-03 19:15 adoom42 Note Added: 0002339
2014-06-03 19:15 adoom42 Assigned To => adoom42
2014-06-03 19:15 adoom42 Status new => feedback
2014-06-05 00:23 adoom42 Note Added: 0002341
2014-06-05 00:23 adoom42 Status feedback => closed
2014-06-05 00:23 adoom42 Resolution open => fixed
2014-06-05 00:23 adoom42 Fixed in Version => 0.20.8
2014-06-05 00:23 adoom42 Target Version => 0.20.8