Unanswered: Maintenance replication user "has been faded out (closed)"
I have a replication server 15.0.1. I have a replication database between two ASE 15.0.2. The replication works fine. The data insertion in the database is every 15m. Nevertheless, I have always this message in the replication log file:
I. 2009/06/08 11:25:45. Connection to server 'SERVER_ONE' as user 'rep_user_maint' has been faded out (closed).
I. 2009/06/08 11:30:16. ...... connected to server 'SERVER_ONE' as user 'rep_user_maint'.
I think that there is any timeout variable that maybe can be set to avoid this message. But I have tried to find something with "sp_config_rep_agent" and I have not found any information about that:
This is informational only and it means that it has nothing to process and it will disconnect until any further transactions come in. It will not fill your rep server error log that bad. However you can periodically archive your REPServer logs thro some scripts on your own.
But if you are so adamant about not seeing this error
you can do
alter connection to dbserver.database
set dsi_fadeout_time to -1
This will never make the dsi connection to fade out and so you wont get a message in the errorlog. But I think its an overkill. Theres a lot of better things for you to learn and improve on in RepServer than worry about this.