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.