This question was originally posted on DCIM Support by Carlos Suay on 2017-06-13
I'm developing a integration via ETL to associate information from a CMDB to the DCO.
The import and the modify of the CI works well, but when I try to delete an element via the ETL, changing the state_flag to "deleted" in the configuration_item table, nothing happens in the DCO and the association remainds.
¿Any idea about that what's happening?
Solved! Go to Solution.
This answer was originally posted on DCIM Support by Ed Tarento on 2017-06-13
It's interesting that "new" and "changed" work for you but "deleted" doesn't.
I assume you are using lower case as shown here ETL Import Database rather than what the doco says Keeping Track of Information State. Upper case has never worked for me. I also assume you've been using the "state_last_updated" column.
Are you checking that the state_flag = "synced" before you set it to delete?
This comment was originally posted on DCIM Support by Carlos Suay on 2017-06-14
Finally I found the problem, and it was in my pentaho procedure. I wasn't updating correctly the state_flag column when i was trying to delete the CI.
Discuss challenges and get support in energy and automation with 30,000+ experts and peers.
Over 10,000+ support articles are available to help you find answers to your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!