Accessing a Database While in Recovery

Occurs when a Replication Server attempts to use an SAP Adaptive Server Enterprise (SAP ASE) database that is in the process of recovery.

Symptom

These messages are recorded in the SAP Replication Server error log:

E. 2006/06/13 10:53:36. ERROR #1028 DSI(western.west1) - /dsiexec.c(306)
Message from server: Message: 921, State: 1, Severity: 14 -- ‘Database
‘west1’ has not been recovered yet - please wait and try again.’.
I. 2006/06/13 10:53:36. Message from server: Message: 5701, State: 1,
Severity: 10 - - ‘Changed database context to ‘master’.’.
E. 2006/06/13 10:53:36. ERROR #5051 DSI(western.west1) - /dsiexec.c(314)
Received errors from database ‘western.west1’. See logged ct-lib and data
server messages for more information.

Explanation

A SAP Replication Server cannot connect to a recovering SAP ASE database. SAP Replication Server automatically attempts to connect to databases (to which connections have been created) when it:

Starts
Resumes a connection
Replicates new transactions after a closed connection

Solution

The connection resumes automatically after the database has recovered.