Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84766members
354198posts

Deleting CI associations from the ETL

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.

Solved
DCIM_Support
Picard
Picard
0 Likes
3
183

Deleting CI associations from the ETL

This question was originally posted on DCIM Support by Carlos Suay on 2017-06-13


Hello,
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?

regards.

(CID:120133529)


Accepted Solutions
DCIM_Support
Picard
Picard
0 Likes
1
183

Re: Deleting CI associations from the ETL

This answer was originally posted on DCIM Support by Ed Tarento on 2017-06-13


Hi Carlos

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?

Cheers

Ed

 

 

(CID:120133612)

See Answer In Context

3 Replies 3
DCIM_Support
Picard
Picard
0 Likes
1
184

Re: Deleting CI associations from the ETL

This answer was originally posted on DCIM Support by Ed Tarento on 2017-06-13


Hi Carlos

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?

Cheers

Ed

 

 

(CID:120133612)

DCIM_Support
Picard
Picard
0 Likes
0
183

Re: Deleting CI associations from the ETL

This comment was originally posted on DCIM Support by Carlos Suay on 2017-06-14


Hello ed,


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.

regards.

(CID:120133811)

DCIM_Support
Picard
Picard
0 Likes
0
183

🔒 Closed

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.