Article ID: 67789
Article Type: Troubleshooting
Last Modified:
Performing a restore operation for the Active/Active replication setup in a tenant database that has a custom-created hdbuserstore key produces an error.
A restore operation for the Active/Active replication setup fails with the following error:
CvProcess::system() - /usr/sap/DAB/HDB02/exe/hdbsql -t -U CVBACKUP -d SYSTEMDB -C "ALTER SYSTEM STOP DATABASE DAB IMMEDIATE" | tee -a /opt/commvault2/iDataAgent/jobResults/CV_JobResults/2/0/1241934/restore.out 2>&1 CvProcess::system() - Command completed with rc=0 ClHanaAgent::StopTheTenant() - ALTER SYSTEM STOP DATABASE - Failed to stop the Tenant database [DAB]. Please try to stop manually and resume the job. Sending FAILED complete message to JM, 1241934 ClHanaAgent::StopTheTenant() - ALTER SYSTEM STOP DATABASE - Failed to stop the Tenant database [DAB]. Please try to stop manually and resume the job..
In HANA, run the following command on SYSTEMDB:
dabadm@sde-sslhana2:/usr/sap/DAB/HDB02/exe/python_support> hdbsql -t -U CVBACKUP -d SYSTEMDB -C "ALTER SYSTEM STOP DATABASE DAB IMMEDIATE" * 7: feature not supported: writable statement not allowed in read-enabled replication: line 1 col 1 (at pos 0) SQLSTATE: HY000
A restore operation for the Active/Active replication setup that is in a tenant database produces an error because the node order is incorrect in the hdbuserstore key.
Set the nodes in correct order in the custom-created hdbuserstore key.
Example
The following example is the output for ‘hdbnsutil -sr_state’ that has sde-sslhana1 as primary site and sde-sslhana2 as secondary site.
Host Mappings:
~~~~~~~~~~~~~~
sde-sslhana1 -> [DABSTAN] sde-sslhana2
sde-sslhana1 -> [DBPRIM] sde-sslhana1
Site Mappings:
~~~~~~~~~~~~~~
DBPRIM (primary/primary)
|---DABSTAN (syncmem/logreplay_readaccess)
Tier of DBPRIM: 1
Tier of DABSTAN: 2
Replication mode of DBPRIM: primary
Replication mode of DABSTAN: syncmem
Operation mode of DBPRIM: primary
Operation mode of DABSTAN: logreplay_readaccess
Mapping: DBPRIM -> DABSTAN
done.
dabadm@sde-sslhana1:/usr/sap/DAB/HDB02/exe/python_support>
hdbuserstore List CVBACKUP
KEY CVBACKUP
ENV : sde-sslhana2:30213,sde-sslhana2:30215,sde-slhana1:30213,sde-sslhana1:30215
USER: <DBUserName>
When you run the following command, the order of the nodes for the hdbuserstore key are corrected:
hdbuserstore -i set CVBACKUP sde-sslhana1:30213,sde-sslhana1:30215,sde-sslhana2:30213,sde-sslhana2:30215 <DBUserName> <Password> dabadm@sde-sslhana2:/usr/sap/DAB/HDB02/exe/python_support> hdbsql -t -U CVBACKUP -d SYSTEMDB -C "ALTER SYSTEM STOP DATABASE DAB IMMEDIATE" 0 rows affected (overall time 13.000803 sec; server time 12.997612 sec) dabadm@sde-sslhana2:/usr/sap/DAB/HDB02/exe/python_support>