3671785 - "recovery could not be completed" due to "Cross database access is not enabled"

Symptom

Recovery cannot be finished successfully and started even when it reached 100% as shown in backup log.
backup.log

INFO    RECOVERY command: RECOVER DATA FOR <tenant DB> USING FILE ('/<path>/COMPLETE_DATA_BACKUP')  CLEAR LOG
...
INFO    RECOVERY using file: /<path>/COMPLETE_DATA_BACKUP_databackup_2_1
INFO    RECOVERY progress of service: indexserver, <hostname>:<port number>, volume: 2, 0% 0/47294971904
INFO    RECOVERY progress of service: indexserver, <hostname>:<port number>, volume: 2, 5% 2684354560/47294971904
...
INFO    RECOVERY progress of service: indexserver, <hostname>:<port number>, volume: 2, 100% 47294971904/47294971904
INFO    RECOVERY state of service: indexserver, <hostname>:<port number>, volume: 2, RecoveryExecuteDataRecoveryFinished
INFO    RECOVERY state of service: indexserver, <hostname>:<port number>, volume: 2, RecoveryLogInitializationStarted
INFO    RECOVERY state of service: indexserver, <hostname>:<port number>, volume: 2, RecoveryLogInitializationFinished
ERROR   RECOVERY RECOVER DATA finished with error: [448] recovery could not be completed, volume 2, reached log position 0, [110043] Can not start the service 'indexserver' at '<hostname>:<port number>' responsible for the volume '2' because an error during recovery before

In indexserver trace, you could find following error was raised

e Row_Engine       systables.cc(00076) : error during execution of Auto migration. detail : Cross database access is not enabled

..

e assign           TREXIndexServer.cpp(01921) : assign failed with ltt exception. stopping service... :
exception  1: no.7100034  (MultiDB/impl/RemoteTransactionManagerImpl.cpp:1715) TID: 4086
    Cross database access is not enabled

...
e Backup           BackupMgr_Manager.cpp(05439) : :::: RECOVERY finished with error: [448] recovery could not be completed, volume 2, reached log position 0, [110043] Can not start the service 'indexserver' at 'gclvhand001:30040' responsible for the volume '2' because an error during recovery before ::::
e Backup           Backup_Recover.cpp(00242) : exception: exception  1: no.110043  (Backup/impl/Backup_Recover.cpp:236) TID: 4370
    Can not start the service 'indexserver' at '<hostname>:<port number>' responsible for the volume '2' because an error during recovery before

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , How To

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.