Search Engine: Elastic

Article ID: 132328, created on Mar 6, 2018, last review on Mar 6, 2018

  • Applies to:
  • Operations Automation

Symptoms

Office 365 Endpoint upgrade fails:

...
Configuring application 'O365App'...
Trying to detect SQL Server connection string from existing configuration...
Deploying the database...
ERROR Deployment failed: Microsoft.SqlServer.Dac.DacServicesException:     Could not deploy package.
Error SQL72014: .Net SqlClient Data Provider: Msg 1468, Level 16, State 2, Line 5 The operation cannot be performed on database "Office365GatewayApplication01" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
Error SQL72045: Script execution error.  The executed script:
IF EXISTS (SELECT 1
       FROM   [master].[dbo].[sysdatabases]
       WHERE  [name] = N'$(DatabaseName)')
BEGIN
    ALTER DATABASE [$(DatabaseName)]
        SET RECOVERY SIMPLE
        WITH ROLLBACK IMMEDIATE;
END

Office 365 Endpoint database itself is a part of MS SQL Always On Availability Group ( documentation link ).

Cause

Script fails on attempt to set the Simple Recovery Model ( documentation link ) which differs from the current one.

The issue has been addressed to Odin Development team as request #APSA-19580: "Fix deployment scripts for high availability db".

Resolution

Contact pta@odin.com or TAM to trace the status of request.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF