none
DPM 2012 to DPM 2012 SP1, ERROR 3753 RRS feed

  • Question

  • Hello everyone,

    After a failed attempt to upgrade DPM 2012 SP1, the error it gave me was 

    SO within the log file, I can see that is the error thrown during the upgrade.

    [9/11/2013 5:29:19 PM] *** Error : ExecuteUpgradeSQLScript: Failed while executing upgrade SQL script masterStoredProcs.sql. SqlCmd Returned 1
    [9/11/2013 5:29:19 PM] * 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
    [9/11/2013 5:29:19 PM] Information : Exception occured in ConfigurePreMsiUpgrade. Rollback to V2. Re-enable DPM and SQL service.
    [9/11/2013 5:29:19 PM] Information : Enabling Service : MSSQL$MSDPM2012 to mode :Automatic
    [9/11/2013 5:29:19 PM] Information : Enabling Service : SQLAgent$MSDPM2012 to mode :Manual
    [9/11/2013 5:29:19 PM] Information : Starting Service:MSSQL$MSDPM2012 on machine:BACKUP04 flag restart:False
    [9/11/2013 5:29:19 PM] Information : Starting Service:SQLAgent$MSDPM2012 on machine:BACKUP04 flag restart:False
    [9/11/2013 5:29:19 PM] Information : Enabling Service : MSDPM to mode :Manual
    [9/11/2013 5:29:19 PM] Information : Enabling Service : dpmra to mode :Manual
    [9/11/2013 5:29:19 PM] Information : Enabling Service : DPMAMService to mode :Automatic
    [9/11/2013 5:29:19 PM] Information : Enabling Service : DpmWriter to mode :Automatic
    [9/11/2013 5:29:19 PM] Information : Starting Service:DpmWriter on machine:BACKUP04 flag restart:False
    [9/11/2013 5:29:21 PM] Information : Starting Service:DPMAMService on machine:BACKUP04 flag restart:False
    [9/11/2013 5:29:23 PM] * 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
    [9/11/2013 5:29:23 PM] *** Error : An error occurred while upgrading the DPM database. Review the error log for more information.



    ID: 4379
    [9/11/2013 5:29:23 PM] 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.
    [9/11/2013 5:32:39 PM] Data : Error Code Web Link = http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft System Center Data Protection Manager&ProdVer=4.1.3313.0&EvtID=4379&EvtSrc=MSDPM&LCID=1033&P2wAppId=p2wMsdpmEE


    So I didnt think that was going to be too bad, but now when I try to open my normal DPM 2012, event viewer gives me this error:

    The description for Event ID 3753 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event: 

    The version of the DPM database installed on this computer is later than the version of the DPM application.

    Problem Details:
    <DatabaseVersionMismatch><__System><ID>29</ID><Seq>0</Seq><TimeCreated>9/11/2013 8:46:18 PM</TimeCreated><Source>f:\dpmv4_rtm\private\product\engine\service\dll\servicemodule.cpp</Source><Line>183</Line><HasError>True</HasError></__System><DatabaseVersion>4.1.3313.0</DatabaseVersion><BinariesVersion>4.0.1908.0</BinariesVersion></DatabaseVersionMismatch>


    the message resource is present but the message is not found in the string/message table

    I did all the necessary updates, but now my DPM 2012 will not work because of this error, as the upgrade throws the 4379 error. Just wondering what you all think is the problem?


    • Edited by DodsonGroup Wednesday, September 11, 2013 9:36 PM
    Wednesday, September 11, 2013 9:32 PM

All replies

  • Hi,

    Open SQL management studio and connect to the DPM 2012 instance.  Edit the tbl_DLS_GlobalSetting table and change the DatabaseVersion from 4.1.3313.0 to 4.0.1908.0 - see if that fixes the issue.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, September 11, 2013 11:04 PM
    Moderator
  • That worked to get rid of the original error. Now When I try to open DPM 2012, it fails and throws this error.

    The description for Event ID 945 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event: 

    Unable to connect to the DPM database because of a general database failure.  Make sure that SQL Server is running and that it is configured correctly.

    Problem Details:
    <FatalServiceError><__System><ID>19</ID><Seq>0</Seq><TimeCreated>9/12/2013 2:11:29 PM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>SqlException</ExceptionType><ExceptionMessage>Invalid object name 'dbo.tbl_PRM_AgentOwnershipAlert'.</ExceptionMessage><ExceptionDetails>System.Data.SqlClient.SqlException: Invalid object name 'dbo.tbl_PRM_AgentOwnershipAlert'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.InternalExecuteReader()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteReader()
       at Microsoft.Internal.EnterpriseStorage.Dls.Prm.Alerts.AlertUtils.GetAllActiveAlerts(String procName, AlertEnum type)
       at Microsoft.EnterpriseStorage.Dls.HealthProvider.NewAlertHealthProvider.ServerAlert.GetAllActiveAlertsWithAlertDetails()
       at Microsoft.EnterpriseStorage.Dls.HealthProvider.NewAlertHealthProvider.AlertHP.GetAllActiveAlerts()
       at Microsoft.EnterpriseStorage.Dls.HealthProvider.NewAlertHealthProvider.AlertHP.MakeAllInvisibleAlertsVisible()
       at Microsoft.EnterpriseStorage.Dls.HealthProvider.NewAlertHealthProvider.AlertVisibility.MakeAllInvisibleAlertsVisible()
       at Microsoft.EnterpriseStorage.Dls.HealthProvider.NewAlertHealthProvider.AlertHP.Initialize()
       at Microsoft.Internal.EnterpriseStorage.Dls.JobManager.JobManager.Initialize()
       at Microsoft.Internal.EnterpriseStorage.Dls.JobManager.JobManager.InitializeIfNecessary(Object state)
       at Microsoft.Internal.EnterpriseStorage.Dls.EngineUICommon.DpmThreadPool.Function(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)</ExceptionDetails></FatalServiceError>


    the message resource is present but the message is not found in the string/message table

    Thursday, September 12, 2013 2:12 PM
  • Hi,

    OK - I Guess it's best just to restore the DPMDB backup you took prior to proceeding with the upgrade. That will get you back in production.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, September 12, 2013 4:10 PM
    Moderator
  • That is what I had to do. Thanks for the all prompt help!
    Thursday, September 12, 2013 8:31 PM
  • Hi,

    I have problem with upgrade DPM 2012SP1 to DPM 2012 R2. Running the upgrade process will end on error 4379.

    LOG:

    [9. 4. 2014 15:36:55] Informace : ExecuteUpgradeSQLScript: Successfully executed upgrade SQL script. ReportingUpgrade.sql
    [9. 4. 2014 15:36:55] Informace : ExecuteUpgradeSQLScript: Executing upgrade SQL script. masterStoredProcs.sql
    [9. 4. 2014 15:36:55] Informace : Inspect.CheckSqlServerTools : MsiQueryProductState returned : INSTALLSTATE_DEFAULT
    [9. 4. 2014 15:36:55] Data : dbScriptsPath = C:\Users\Administrator.KASPAR\AppData\Local\Temp\1\DPME519.tmp\DPM2012\setup\UpgradeScripts
    [9. 4. 2014 15:36:55] Data : sqlcmdPath = "C:\Program Files\Microsoft System Center 2012\DPM\SQL\100\Tools\Binn\SQLCMD.EXE"
    [9. 4. 2014 15:36:55] Data : instanceName = KASPARDPM\MSDPM2012
    [9. 4. 2014 15:36:55] Informace : Execute the SQL script
    [9. 4. 2014 15:36:55] Data : FileName = "C:\Program Files\Microsoft System Center 2012\DPM\SQL\100\Tools\Binn\SQLCMD.EXE"
    [9. 4. 2014 15:36:55] Data : Arguments = -b -E -d DPMDB -i masterStoredProcs.sql -r -S KASPARDPM\MSDPM2012
    [9. 4. 2014 15:37:46] Data : Error code = 1
    [9. 4. 2014 15:37:46] *** Chyba : ExecuteUpgradeSQLScript: Failed while executing upgrade SQL script masterStoredProcs.sql. SqlCmd Returned 1
    [9. 4. 2014 15:37:46] * Výjimka :  => Při upgradování databáze aplikace DPM došlo k chybě. Další informace naleznete v protokolu chyb.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: Byla vyvolána výjimka typu Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException.
       v Microsoft.Internal.EnterpriseStorage.Dls.Setup.UpgradeLibrary.UpgradeImplementer.ExecuteUpgradeSQLScript(String sqlScriptFilename, SetupContext context)
       v Microsoft.Internal.EnterpriseStorage.Dls.Setup.UpgradeLibrary.UpgradeTableContainer.RunUpgrade(Int32 index, SetupContext setupContext)
       v Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.UpgradeConfiguration(Version installedVersion, String currentSqlInstanceName, String oldSqlInstanceName, String currentDpmDatabaseName, String oldDpmDatabaseName)
       v Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.ConfigurePreMsiUpgrade()
       v Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.UpgradeDpm()
    *** Mojito error was: UpgradeSqlScriptFailed; 0; None

    Can you help me?

    Thanks

    Radek Ryšan

    Wednesday, April 9, 2014 2:04 PM