SAP Knowledge Base Article - Preview

2711518 - Table Replication Became Deactivated

Symptom

Table replication became deactivated based on the result of SQL:

SELECT * FROM M_TABLE_REPLICAS WHERE REPLICATION_STATUS != 'ENABLED'

And the following errors are noticed from HANA indexserver trace:

Table replication will be turned off as the following top 10 transactions which access the replicated tables are waiting synchronous commit(OSTR) or rollback(OSTR/ATR) over 600 secs:
CONNECTION_ID = <>, HOST = <>, TRANSACTION_ID = "<>", UPDATE_TRANSACTION_ID = "<>", TRANSACTION_STATUS = "<>", IS_SYNC_REP_TRANS = "TRUE"
CONNECTION_ID = <>, HOST = <>, TRANSACTION_ID = "<>", UPDATE_TRANSACTION_ID = "<>", TRANSACTION_STATUS = "<>", IS_SYNC_REP_TRANS = "TRUE"


Read more...

Environment

SAP HANA 1.0

SAP HANA 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

Table replication, OSRT, ATR, synchronous commit, uncommitted_ostr_transaction_timeout, uncommitted_replication_transaction_timeout , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.