View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1245 | RackTables | default | public | 2014-06-03 16:57 | 2014-06-05 00:23 |
Reporter | igorozco | Assigned To | adoom42 | ||
Priority | urgent | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Platform | Virtual Machine on ESXi | OS | Ubuntu | OS Version | 14.04 |
Product Version | 0.20.7 | ||||
Target Version | 0.20.8 | Fixed in Version | 0.20.8 | ||
Summary | 1245: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'parent_entity_id' cannot be null (23000) | ||||
Description | We 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 Reproduce | Configure management object and use the UCS-Autopopulate option. | ||||
Additional Information | https://communities.cisco.com/docs/DOC-36827 Using UcsSdk-0.8.1.tar.gz | ||||
Tags | No tags attached. | ||||
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. |
|
The reporter confirmed that the added rules solved the problem. The change has been committed to 0.20.8. | |
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 |