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
84244members
353343posts

How to confirm ETL Export DB finished synchronisation

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
4
266

How to confirm ETL Export DB finished synchronisation

This question was originally posted on DCIM Support by Lukasz Staciwo on 2017-07-24


Hi guys,

Other than looking into server log where can I see and confirm that daily scheduled synchronisation have finished succesfully?

Ideally how can I monitor this and be notified once it is done every day (even if this would be an informational level notification from DCE for example).

DCO 7.5 SP5ni6.

Asking on behalf of daryl yeoh and Ryan Zhang.

(CID:122692927)


Accepted Solutions
DCIM_Support
Picard
Picard
0 Likes
2
266

Re: How to confirm ETL Export DB finished synchronisation

This answer was originally posted on DCIM Support by Ed Tarento on 2017-07-24


Hi Lukasz 

i owe you a call

logs file is only way afaik

no in built system for this I think but it's a common and easily solved sysadmin function.  May even be able to use a webmin module but I think you're asking for a log watcher.  Many moons ago I used swatch which would do the job but prob even better options now (if u need a better one). 

A permanent process watches log files (server.log)  and when a matching entry appears (you have powerful rules syntax e.g. Your specific export run at a specific time with specific result code) ) your required command is executed e.g send an email.   Sadly DCE will not recv a trap but if it's mandatory I think I can make something close to a trap  happen for u as well

U need a level of admin acces to DCO OS to  install and run and u should configure the watch dog feature so the process will restart if it fails for some reason

i can help if u like.  Should be a few hours work in dev.  Getting it to prod is a different matter!

cheers

(CID:122692953)

See Answer In Context

4 Replies 4
DCIM_Support
Picard
Picard
0 Likes
2
267

Re: How to confirm ETL Export DB finished synchronisation

This answer was originally posted on DCIM Support by Ed Tarento on 2017-07-24


Hi Lukasz 

i owe you a call

logs file is only way afaik

no in built system for this I think but it's a common and easily solved sysadmin function.  May even be able to use a webmin module but I think you're asking for a log watcher.  Many moons ago I used swatch which would do the job but prob even better options now (if u need a better one). 

A permanent process watches log files (server.log)  and when a matching entry appears (you have powerful rules syntax e.g. Your specific export run at a specific time with specific result code) ) your required command is executed e.g send an email.   Sadly DCE will not recv a trap but if it's mandatory I think I can make something close to a trap  happen for u as well

U need a level of admin acces to DCO OS to  install and run and u should configure the watch dog feature so the process will restart if it fails for some reason

i can help if u like.  Should be a few hours work in dev.  Getting it to prod is a different matter!

cheers

(CID:122692953)

DCIM_Support
Picard
Picard
0 Likes
0
266

Re: How to confirm ETL Export DB finished synchronisation

This comment was originally posted on DCIM Support by Greg Sterling on 2017-07-24


I agree with Ed in that the log files are probably your best bet. The server.log and etl.log files should contain the log entries. Can get a little more complicated if your customer has several ETL jobs with overlapping schedules.

There was a point at one of our larger customers we could guess whether the job was successful or not simply based on how long it took the job to execute. It was an etl export job in that case.

Regards

Greg Sterling

(CID:122692984)

DCIM_Support
Picard
Picard
0 Likes
0
266

Re: How to confirm ETL Export DB finished synchronisation

This comment was originally posted on DCIM Support by Lukasz Staciwo on 2017-07-25


Thanks Greg and Ed,

Much appreciated input.

(CID:122694001)

DCIM_Support
Picard
Picard
0 Likes
0
266

🔒 Closed

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