Troubleshooting rs_lastcommit Update Failure

Identify the problem if the replicate Replication Server error log displays a syntax error while updating the rs_lastcommit table.

1. Verify that the table exists in the replicate database.
2. 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.

3. 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.

   If a replicate database connection uses ExpressConnect for Oracle or ExpressConnect for HANA DB, turn on tracing in ExpressConnect.

   alter connection to <rds.rdb> set trace to 'econn,dsi_buf_dump,on' go 

   Identify the failing statement and correct as necessary.