When replicating into a non-ASE replicate database, the replicate Replication Server updates the rs_lastcommit table as soon as the connection is resumed. If the replicate Replication Server error log displays a syntax error while updating the rs_lastcommit table, the following procedure may help identify the problem.
Troubleshooting rs_lastcommit update
failure
Verify that the table exists in the replicate database.
Verify access authority.
Log in to the replicate database using the Replication Server maintenance user ID and password specified in the create connection command for that database connection.
Verify that this user ID can update the rs_lastcommit table – you should be able to insert and delete a dummy entry without error.
Trace the actual command.
Turn on tracing in the replicate Replication Server (DSI_BUF_DUMP trace) or in the ECDA gateway and resume the Replication Server connection.
Identify the failing statement and correct as necessary.
