Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 21, 2017 at 03:21 AM

    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 :)

    Add comment
    10|10000 characters needed characters exceeded