SAP Knowledge Base Article - Preview

3109370 - Not able to monitor Time Travel Status from Primary site

Symptom

Customer is using Hana Time Travel feature and would like to retrieve Time Travel Status from system views on Primary Site. However views that designed for this purpose does not work.

We have Hana cluster configured with 4 nodes as follow: Site Mappings:
~~~~~~~~~~~~~~
XXX_SECONDARY (primary/primary) - hanac4002b
|---CCC_SiteC (async/logreplay_readaccess) - hanac4002a
| |---DDD_SiteD (syncmem/logreplay) - hanac5002b
|---AAA_PRIMARY (syncmem/logreplay_readaccess) - hanac5002a

Time Travel is configured on SiteC  as follow: *:/usr/sap/XXX/SYS/global/hdb/custom/config> hdbnsutil -sr_timetravel --printRange


| DATABASEID | VOLUMEID | STARTSNAPSHOT | STARTTIME | STARTPOS | ENDTIME | ENDPOS | COORDINATOR_TYPE |
|------------|------------|-----------------|----------------------|-----------------|----------------------|-----------------|----------------------|
| 1 | 1 | 134143 | 25.01.2021-00.52.53 | 0x14bb9bdc2 | 26.01.2021-18.21.02 | 0x14c013940 | MASTER |
| 3 | 2 | 164289 | 25.01.2021-02.22.11 | 0x1fc409c3 | 26.01.2021-18.20.12 | 0x1fd6d500 | NONE |
| 3 | 3 | 164691 | 25.01.2021-15.30.21 | 0x2c6af29e83 | 26.01.2021-18.21.09 | 0x2c80f06780 | MASTER |
| 4 | 2 | 116850 | 25.01.2021-16.01.43 | 0x1c5aca77838 | 26.01.2021-18.21.09 | 0x1c687c63fc0 | MASTER |
| 5 | 2 | 123078 | 25.01.2021-16.45.33 | 0x132c327561 | 26.01.2021-18.21.09 | 0x1343f69200 | MASTER |
| 6 | 2 | 122527 | 24.01.2021-18.20.09 | 0x12d067c32c | 26.01.2021-18.21.09 | 0x12e1d75380 | MASTER |
| 8 | 2 | 122041 | 25.01.2021-17.32.08 | 0x181878e402 | 26.01.2021-18.21.09 | 0x182b5d00c0 | MASTER |
| 11 | 2 | 125146 | 25.01.2021-00.51.56 | 0x1cd3a4d53 | 26.01.2021-18.20.56 | 0x1ce594540 | MASTER |
| 10 | 2 | 121831 | 25.01.2021-17.51.08 | 0x2c3c61f102 | 26.01.2021-18.21.09 | 0x2c495d5c80 | MASTER |
| 9 | 2 | 122789 | 25.01.2021-16.56.08 | 0x1d533b5002 | 26.01.2021-18.21.09 | 0x1d5e6fa340 | MASTER |

However, attempt to retrieve this information from Primary (SiteB:hanac4002b.xxx) is failing. Views are as following: hdbsql SYSTEMDB=> select SCHEMA_NAME,VIEW_NAME from VIEWS WHERE VIEW_NAME like '%TIMETRAVEL%';
SCHEMA_NAME,VIEW_NAME
"_SYS_SR_SITE_xxx_PRIMARY","M_SYSTEM_REPLICATION_TIMETRAVEL"
"_SYS_SR_SITE_XXX_SiteC","M_SYSTEM_REPLICATION_TIMETRAVEL"
"SYS","M_SYSTEM_REPLICATION_TIMETRAVEL"
"SYS_DATABASES","M_SYSTEM_REPLICATION_TIMETRAVEL"
"_SYS_DATABASES_SR_SITE_EB1CF05_PRIMARY","M_SYSTEM_REPLICATION_TIMETRAVEL"
"_SYS_DATABASES_SR_SITE_XXX_SiteC","M_SYSTEM_REPLICATION_TIMETRAVEL"
"_SYS_SR_SITE_XXX_SiteD","M_SYSTEM_REPLICATION_TIMETRAVEL"
"_SYS_DATABASES_SR_SITE_XXX_SiteD","M_SYSTEM_REPLICATION_TIMETRAVEL"

Querying abouve views are failing as follow: hdbsql SYSTEMDB=> select * from _SYS_DATABASES_SR_SITE_XXX_SiteC.M_SYSTEM_REPLICATION_TIMETRAVEL;
* 362: invalid schema name: _SYS_DATABASES_SR_SITE_XXX_SITEC: line 1 * 15 (at pos 14) SQLSTATE: HY000
hdbsql SYSTEMDB=> select * from _SYS_SR_SITE_XXX_SiteC.M_SYSTEM_REPLICATION_TIMETRAVEL;
* 362: invalid schema name: _SYS_SR_SITE_XXX_SITEC: line 1 * 15 (at pos 14) SQLSTATE: HY000


Read more...

Environment

HANA Version: 2.0

Product

SAP HANA, platform edition 2.0

Keywords

"Time Travel","Quotes" , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , Problem

About this page

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

Search for additional results

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