Problem

When you use the Deployment Backup and Recovery Tool batch command sas-recover-offline, recovery of a SAS^® solution data server might be incorrectly reported as successful. In this scenario, the tool reports success even if it was unable to connect to the data server to perform a recovery.

When this problem occurs, sas-recover-offline reports the recovery for the sourceType DATABASE as successful. Here is an example:

But, when you examine the SAS-configuration-directory\Levn\Backup\backupserver.log file, you find a message that says the connection to the database for the restore was refused. Here is an example:

Cause

This problem might occur if you did not start the solution data server before executing sas-recover-offline. If the solution data server is not running, then the Deployment Backup and Recovery Tool is not able to connect to the solution data server. However, the tool does not report this as a failure for the database recovery. 

Solution

A fix for this issue is planned for a future release of SAS software. 

If you encounter this problem, stop all servers and services except the SAS^® Metadata Server, SAS^® Web Infrastructure Platform Data Server (including any solution data servers), and the SAS^® Deployment Agent. Then, run sas-recover-offline a second time. 

To read about the steps for performing a recovery using the Deployment Backup and Recovery Tool, see the SAS Intelligence Platform Batch Tools: Reference of the SAS^® 9.4 Intelligence Platform: System Administration Guide, Fourth Edition.

Operating System and Release Information