cancel
Showing results for 
Search instead for 
Did you mean: 

how do I start rep agent in erssd sap anywhere after error?

0 Kudos

Hi community,

I have a Replication Server installation using erssd (anywhere). The Replication Server was working very well but after a time, REP AGENT thread in the erssd was down.

REP AGENT Awaiting Command f03_erssd.f03_erssd

In the repserver errorlog I see continuous messages like this but the REP AGENT keep down:

I. 2017/07/17 16:31:04. Starting embedded RSSD Replication Agent by dREC.

In the RepAgent errorlog I see the next messages:

I. 2017-07-18 12:40:03. Replication starts after queue identifier (0010487322)

E. 2017-07-18 12:40:03. Invalid parameter specification for rs_marker stored procedure

E. 2017-07-18 12:40:03. Log operation at offset 0010488051 has bad data at offset 0010488059

E. 2017-07-18 12:40:03. Shutdown caused by fatal error

I. 2017-07-18 12:40:03. Beginning LTM shutdown sequence and freeing resources

I. 2017-07-18 12:40:04. LTM Shutdown Complete

Anyone know How Can I find out Why the RepAgent is down and resolve the issue?

Regards,

Juan Carlos

Accepted Solutions (0)

Answers (1)

Answers (1)

The message "Log operation at offset 0010488051 has bad data at offset 0010488059" is critical.

Most likely the SQL Anywhere transaction log file is corrupt. You may confirm that by running the dbtran utility on the transaction log file.

CORRECTION: SQL Anywhere 12 and later no longer supports the Replication Agent / Log Transfer Manager (dbltm) for Replication Server. However, that does not necessarily apply to SQL Anywhere 12 and later being used as a Replication Server System Database (RSSD). Incorrect material previously appeared in this answer... for more (correct!) information see the comments from Mark Parsons below 🙂

0 Kudos

See this Help topic... "The SQL Anywhere Replication Agent for Sybase Replication Server is not supported in version 12. You must use an alternative replication or synchronization technology such as MobiLink or SQL Remote"

Other than reading the google to you, I know nothing about Rep Server other than how to customize MobiLink to mimic some of the more arcane aspects of Rep Server behavior... most folks don't need to do that.

If you have questions about SQL Anywhere, MobiLink or SQL Anywhere, the forum to use is sqlanywhere-forum.sap.com

0 Kudos

Thanks for setting me straight! ...I have updated my answer accordingly.