none
Upgrade DPM 2012 RTM to DPM2012 SP1 fails RRS feed

  • Question

  • Hi,

    I'm trying to upgrade my DPM 2012 RTM to SP1 but it keeps failing. I have DPM2012 running on Windows Server 2008 R2 with a local SQL 2008 R2 instance. I attached part of the DpmSetup.log where I can see that it fails on an SQL upgrade script for DPMDB. Any idea why it keeps failing? I've tried the installation a second time after reinstalling DPM 2012 RTM and restoring my DPMDB but still the same error

    [23-1-2013 15:34:11] Information : ExecuteUpgradeSQLScript: Executing upgrade SQL script. V4RTMtoV4SP1Beta_Intent.sql
    [23-1-2013 15:34:11] Data : dbScriptsPath = C:\Users\xxx_xxxxxxx\AppData\Local\Temp\2\DPM5BE6.tmp\DPM2012\setup\UpgradeScripts
    [23-1-2013 15:34:11] Data : sqlcmdPath = "C:\Program Files\Microsoft DPM\SQL\100\Tools\Binn\SQLCMD.EXE"
    [23-1-2013 15:34:11] Data : instanceName = WH-DPM02\MSDPM2012
    [23-1-2013 15:34:11] Information : Execute the SQL script
    [23-1-2013 15:34:11] Data : FileName = "C:\Program Files\Microsoft DPM\SQL\100\Tools\Binn\SQLCMD.EXE"
    [23-1-2013 15:34:11] Data : Arguments = -b -E -d DPMDB -i V4RTMtoV4SP1Beta_Intent.sql -r -S WH-DPM02\MSDPM2012
    [23-1-2013 15:34:11] Data : Error code = 1
    [23-1-2013 15:34:11] *** Error : ExecuteUpgradeSQLScript: Failed while executing upgrade SQL script V4RTMtoV4SP1Beta_Intent.sql. SqlCmd Returned 1
    [23-1-2013 15:34:11] * Exception :  => An error occurred while upgrading the DPM database. Review the error log for more information.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: Exception of type 'Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException' was thrown.
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.UpgradeLibrary.UpgradeImplementer.ExecuteUpgradeSQLScript(String sqlScriptFilename, SetupContext context)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.UpgradeLibrary.UpgradeTableContainer.RunUpgrade(Int32 index, SetupContext setupContext)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.UpgradeConfiguration(Version installedVersion, String currentSqlInstanceName, String oldSqlInstanceName, String currentDpmDatabaseName, String oldDpmDatabaseName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.ConfigurePreMsiUpgrade()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.UpgradeDpm()
    *** Mojito error was: UpgradeSqlScriptFailed; 0; None
    [23-1-2013 15:34:11] Information : Exception occured in ConfigurePreMsiUpgrade. Rollback to V2. Re-enable DPM and SQL service.
    [23-1-2013 15:34:11] Information : Enabling Service : MSSQL$MSDPM2012 to mode :Automatic
    [23-1-2013 15:34:11] Information : Enabling Service : SQLAgent$MSDPM2012 to mode :Manual
    [23-1-2013 15:34:11] Information : Starting Service:MSSQL$MSDPM2012 on machine:WH-DPM02 flag restart:False
    [23-1-2013 15:34:11] Information : Starting Service:SQLAgent$MSDPM2012 on machine:WH-DPM02 flag restart:False
    [23-1-2013 15:34:11] Information : Enabling Service : MSDPM to mode :Manual
    [23-1-2013 15:34:11] Information : Enabling Service : dpmra to mode :Manual
    [23-1-2013 15:34:11] Information : Enabling Service : DPMAMService to mode :Automatic
    [23-1-2013 15:34:11] Information : Enabling Service : DpmWriter to mode :Automatic
    [23-1-2013 15:34:11] Information : Starting Service:DpmWriter on machine:WH-DPM02 flag restart:False
    [23-1-2013 15:34:13] Information : Starting Service:DPMAMService on machine:WH-DPM02 flag restart:False
    [23-1-2013 15:34:13] * Exception :  => An error occurred while upgrading the DPM database. Review the error log for more information.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: Exception of type 'Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException' was thrown.
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.UpgradeLibrary.UpgradeImplementer.ExecuteUpgradeSQLScript(String sqlScriptFilename, SetupContext context)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.UpgradeLibrary.UpgradeTableContainer.RunUpgrade(Int32 index, SetupContext setupContext)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.UpgradeConfiguration(Version installedVersion, String currentSqlInstanceName, String oldSqlInstanceName, String currentDpmDatabaseName, String oldDpmDatabaseName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.ConfigurePreMsiUpgrade()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.UpgradeDpm()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallerThreadEntry()
    *** Mojito error was: UpgradeSqlScriptFailed; 0; None
    [23-1-2013 15:34:13] *** Error : An error occurred while upgrading the DPM database. Review the error log for more information.

     

    ID: 4379
    [23-1-2013 15:34:13] Information : The DPM upgrade failed. DPM was unable to upgrade the DPM database and all changes made by the upgrade were rolled back. Review the details on the Error tab, take the appropriate action, and then try upgrading DPM again.

    Wednesday, January 23, 2013 2:54 PM

All replies

  • Hi

    Can be a permission problem in SQL. Is the account you running an admin in SQL and on the local server?

    Wednesday, January 23, 2013 3:32 PM
  • Yes my account is sysadmin and also local admin on the server. The other sql upgrade scripts seem to run just fine

    Wednesday, January 23, 2013 7:06 PM