SAP RS - Data is not replicated, although all definitions looks OK

What happened?

Data is not replicated, although all definitions looks OK.

Solution:

Can be more than one reason, try to check:

• Check definition of databases and servers – all those definitions can be very confusing… (names, IPs, etc. [sql.ini])
• Check PKs in both sides – as already mentioned above: primary and replicated
• Permissions issues
  • RS permissions – example: grant role replication_role to sa (RSSD database)
  • Primary DB
  • Replicated DB – example: GRANT INSERT, UPDATE, DELETE ON replicated table to the maintanance user of RS (_maint)
• Network and connections issues – permissions to inbound/outbound access to/from the servers.
  • don’t forget after fixing a problem to resume connection the server.database
• LTM is not set to the correct “locator” value.
  • rs_zeroltm, dbcc settrunc(ltm, valid)