RESTful knowledge exchange
Post Reply
adapterer
Expert
Posts: 227
Liked: 46 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Monitor Database Replication

Post by adapterer »

Hi,

How can I monitor database replication success or failure under Enterprise Manager > Sessions?

We use the API for billing, and if the replication fails obviously this is bad.

Cheers :D
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin »

What do you mean exactly by database replication? Replication job that has a VM running specific db application as its source, configuration backup or something else?
adapterer
Expert
Posts: 227
Liked: 46 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer »

In enterprise manager, under configuration > sessions. The task that collects data for all the VBR's.

Image
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin »

System tasks are not reflected in RESTful API. Thanks.
adapterer
Expert
Posts: 227
Liked: 46 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer »

OK, consider this a feature request then :)

Twice now we've had issues with foreign key errors (resulting in database replication failure) which have required manually editing the database.

If an email could be sent if this task fails, that would be sufficient.

Thank you!
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin »

Twice now we've had issues with foreign key errors (resulting in database replication failure)
Can you share more details regarding that?
adapterer
Expert
Posts: 227
Liked: 46 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer »

Case # 02210308 - although I'm not sure how much detail is in there as I managed to resolve this myself.

The error was something like "FK constraint, cannot insert duplicate row into dbo.repositories" . I can't remember the exact error or table name, but the content was the table of backup repositories. By deleting these rows in SQL management studio the task was able to run again (I took a DB backup first :) ).
adapterer
Expert
Posts: 227
Liked: 46 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer »

Is there any update on whether this can be added? :)
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin »

Nothing has changed for this matter since my last reply. Thanks.
adapterer
Expert
Posts: 227
Liked: 46 times
Joined: Oct 12, 2015 11:24 pm
Contact:

Re: Monitor Database Replication

Post by adapterer »

The database replication is critical for us to get billing data for Cloud Connect clients - we really need 'something' - even a Veeam ONE alert to check that this is working.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Monitor Database Replication

Post by veremin »

As far as I'm concerned, Veeam ONE does not have an alert you're asking. I believe it should be possible to query SQL database to get this information. Thanks.
sahasrara62
Lurker
Posts: 1
Liked: never
Joined: Jul 13, 2022 6:32 am
Full Name: prashant rana
Contact:

Re: Monitor Database Replication

Post by sahasrara62 »

Hi,
I am also working on this usecase, and unable to find API to gget the status of database replication in session through the RESTFul API. Is there any solution for this? if I need to see database table then where to go?
ps i am new to veeam environment
oleg.feoktistov
Veeam Software
Posts: 1912
Liked: 635 times
Joined: Sep 25, 2019 10:32 am
Full Name: Oleg Feoktistov
Contact:

Re: Monitor Database Replication

Post by oleg.feoktistov »

Hi,

As mentioned above, Enterprise Manager system sessions are not exposed via EM REST API.
The table containing them would be Enterprise.Sessions, but please note that such approach of monitoring these sessions is not supported.

Thanks,
Oleg
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests