EcoStruxure IT forum
A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Posted: 2020-07-04 05:54 PM
This question was originally posted on DCIM Support by Lai Yuan Jiun on 2018-05-22
We have done the DCO ETL Export Database and we can connect to the tables. We had browse the tables and most have data in them except the below 2:
Our DCO has custom properties and also cages so these two tables should contain data. Please advise how do we troubleshoot this?
(CID:131963469)
Posted: 2020-07-04 05:54 PM
This answer was originally posted on DCIM Support by Ed Tarento on 2018-05-23
I would delete the External System, drop the DB then recreate DB and External System.
Let us know how that goes
(CID:131964211)
Posted: 2020-07-04 05:54 PM
This comment was originally posted on DCIM Support by Ed Tarento on 2018-05-22
Hi Lai
Which DCO version?
Does the configuration_item table have rows?
Ed
(CID:131963498)
Posted: 2020-07-04 05:54 PM
This comment was originally posted on DCIM Support by Lai Yuan Jiun on 2018-05-23
DCO ver 8.2.2
Configuration_item table has data/row.
(CID:131964155)
Posted: 2020-07-04 05:54 PM
This answer was originally posted on DCIM Support by Ed Tarento on 2018-05-23
I would delete the External System, drop the DB then recreate DB and External System.
Let us know how that goes
(CID:131964211)
Posted: 2020-07-04 05:54 PM
This comment was originally posted on DCIM Support by Ed Tarento on 2018-05-23
Hi Lai
I created a Floor Plan and a cage with a row and some racks.
I was able to see a cage and its size via ETL export DB and some more details via the REST API. The doco entry at ETL Export Database (snip below) is not 100% clear to me w.r.t how to get the Free Space but it looks like you have to calculate it based on what's in the cage? I hope not.
Cages and Rows
In the internal StruxureWare Data Center Operation model neither rows nor cages are part of the equipment parent-child hierarchy.
When exporting configuration items from StruxureWare Data Center Operation, this is hidden from the user, and the natural parent-child hierarchy is build.
The relation is realized by having each configuration item reference its parent through the parent_id field.
The area of cages are fetched from the StruxureWare Data Center Operation webservices and associated with the configuration items representing the individual cages, in the table configuration_item_property.
The area-property is named CageArea, and the area is expressed in whatever unit the webservice returns.
(CID:132646950)
Posted: 2020-07-04 05:54 PM
This comment was originally posted on DCIM Support by Lai Yuan Jiun on 2018-05-24
Would Schneider revised the documentation to confirm what does data does the Free_Space table provide?
Matthew Farnell, fyi.
(CID:132646952)
Posted: 2020-07-04 05:54 PM
This comment was originally posted on DCIM Support by Lai Yuan Jiun on 2018-05-24
We have deleted the External system (from the DCO client) and the database (from DCO webmin) and then re-create everything again. The 3 tables that are empty are still empty:
Please help.
(CID:131965003)
Posted: 2020-07-04 05:55 PM
This answer was originally posted on DCIM Support by Jef Faridi on 2018-05-31
Hi Lai, (Lai Yuan Jiun)
free_space : currently not used, so it should not contain any data (it is basically there for possible future usage).
configuration_item_tag: any tags associated with the items configuration_item, are exported to configuration_item_tag. If your export data is empty, then most likely you do not have tags defined in the setup, otherwise we need to have a closer look at you setup?
configuration_item_relation_custom_property: any CustomProperties associated with the relation in configuration_item_relation table..., eg. custom properties on relations (such as network connections in DCO). So if you do not have defined custom properties settings on connections, then the table/data expected to be empty, otherwise we need to have closer look at your solution?
Hope this helps,
Kind regards
(CID:132646943)
Posted: 2020-07-04 05:55 PM
This comment was originally posted on DCIM Support by Lai Yuan Jiun on 2018-06-01
Thanks Jef, it's all good now.
free_space : noted it is not used currently, so will ignore it. For any tables that are not used, suggest to provide a comment at the ETL schema documentation page so that users are clear about it, thanks.
configuration_item_tag: Turns out that I have tags created but did not tag any equipment, once I tag a rack I can see data in the table.
configuration_item_relation_custom_property:Noted, was confused with the custom property table and did not realize that this is custom property for relations
(CID:132647375)
Posted: 2020-07-04 05:55 PM
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.