Check replication logs
- Last Updated: April 22, 2020
- 1 minute read
The ReplLog Check feature allows you to scan all the log files for any
errors and reports them through an email. To execute this feature, run the RunReplLogChk.bat file from the \Pro2\bprepl\Scripts
folder.
If you are running this functionality for the first time, a ErrorTrigger.lst file is created (available in the
repl_log folder). Add the error list that needs to be
scanned/excluded in this file separated by commas. This feature scans all the log files,
excluding the unwanted errors, and then send an error report in an email.
You can log the errors in the ErrorTrigger.lst
file as shown below:
[ADMIN_LOG]
error,[SQL Server],
[ADMIN_LOG-EXCLUDES]
Warning
[REPL_LOG]
Error,[SQL Server],Maximum number of client connections,Application server connect failure,Appserver did not connect,Transport resources unavailable,
[REPL_LOG_EXCLUDES]
Warning,Closing Replication Log,Re-Opened Replication Proc Log,Openining Replication
[APPSRV_LOG]
Error,[SQL Server],
[APPSRV_LOG_EXCLUDES]
Warning,Closing Replication Log
[BULK_LOAD_LOG]
Error,[SQL Server],
[BULK_LOAD_LOG_EXCLUDES]
Warning
Note: If the
ErrorTrigger.lst file is not found in the expected directory, it is
created in repl_log directory with an empty skeleton.