topic Re: Which SDE tables contain the Distributed Geodatabase Replica Logs in Geodatabase Questions

Which SDE tables contain the Distributed Geodatabase Replica Logs

RandyKreuziger — Thu, 17 Jan 2019 18:03:39 GMT

Which SDE/GDB tables contain the replication logs?

I'd like to write a job to verify that the replication is taking place daily and that it's successful, if not, send out an email alert. Has anyone done this already? Thanks.

Env: SQL Server 2012, SDE 10.4

Re: Which SDE tables contain the Distributed Geodatabase Replica Logs

George_Thompson — Thu, 17 Jan 2019 19:25:43 GMT

I do not think that log file is within the geodatabase system tables. They are usually located here:

Replica Logs
Location: C:\Users\<user_name>\AppData\Local\ESRI
File(s): ReplicaLog.dat
*Note: You can change the default location in the Distributed Geodatabase toolbar in ArcMap:
i.e. Distributed Geodatabase > Properties > General > Logging Properties > Log file path

A quick tour of replica management—ArcGIS Help | ArcGIS Desktop

The replica activity log—ArcGIS Help | ArcGIS Desktop

Re: Which SDE tables contain the Distributed Geodatabase Replica Logs

RandyKreuziger — Thu, 17 Jan 2019 21:13:38 GMT

I'm having a problem finding it. The original data is onprem with the replica up on AWS. The sync is run as a scheduled task up on AWS owned by me but run using an shared AD service type account for use running scheduled jobs. The ReplicaLog.dat under my C:\Users\<user_name>\AppData\Local\ESRI folder is completely empty size 0KB and there is no ReplicaLog.dat file in the service account folder. I made sure that file explorer is set to show hidden items.

Re: Which SDE tables contain the Distributed Geodatabase Replica Logs

George_Thompson — Fri, 18 Jan 2019 15:52:52 GMT

I would think that the file is located on the client machine that runs the sync. I would also make sure that the log level on the client machine is set to anything but "NONE".