Accessing a Database While in Recovery

Occurs when a Replication Server attempts to use an Adaptive Server database that is in the process of recovery.

Symptom

These messages are recorded in the 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 Replication Server cannot connect to a recovering Adaptive Server database. 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.