imageHere’s a KB for DPM 2012 that actually came out a few months ago but somehow slipped through the cracks and never got a mention here on our blog. It resolves a lot of questions we get around here so I wanted to make sure everyone was aware of it. If you get a minute give it a quick read just so you’re aware of the issue and the fix.

=====

Symptoms

After you install or upgrade to Microsoft System Center 2012 Data Protection Manager, you may receive an error message that resembles the following:

An unexpected error occurred while the job was running. (ID 104 Details: Unknown error (0x80040e37) (0x80040E37))

This problem occurs when you perform consistency checks or when you try to create recovery points for Microsoft SQL Server databases or for Microsoft SharePoint databases.

Cause

This problem may occur if the SQL server or SharePoint servers that are being protected by Data Protection Manager are configured to use case-sensitive collation.

Resolution

To resolve this issue install the following update:

Update Rollup 2 for System Center 2012 - Data Protection Manager: http://www.microsoft.com/en-us/download/details.aspx?id=30413

More Information

To help identify this problem, review the DPMRACURR.err log file in the following location:

C:\Program files\Microsoft data protection manager\dpm\temp\

When this problem occurs, text that resembles the following is logged in the DPMRACURR.err log file:

12DC 10C8 04/09 18:34:52.004 31 sqlwriterhelperplugin.cpp(1126) [0000000000C24190] NORMAL get Database Recovery model Query = SELECT RECOVERY_MODEL_DESC FROM SYS.DATABASES WHERE NAME = N'SQL_DB_NAME' for instance = INSTANCE_NAME
12DC 10C8 04/09 18:34:52.004 03 sqlqueryhelper.cpp(288) [000000000339F010] WARNING SQL - ICommandText::Execute of "SELECT RECOVERY_MODEL_DESC FROM SYS.DATABASES WHERE NAME = N'SQL_DB_NAME'" - Failed
12DC 10C8 04/09 18:34:52.004 03 sqlqueryhelper.cpp(332) [000000000339F010] WARNING SQL - Error Description "Invalid object name 'SYS.DATABASES'."
12DC 10C8 04/09 18:34:52.004 03 sqlqueryhelper.cpp(345) [000000000339F010] WARNING Failed: Hr: = [0x80040e37] SQL - sql code = 208 (Errorlevel - 0)
12DC 10C8 04/09 18:34:52.004 03 sqlqueryhelper.cpp(353) [000000000339F010] WARNING SQL - Detailed Description "Invalid object name 'SYS.DATABASES'."
12DC 10C8 04/09 18:34:52.004 31 sqlwriterhelperplugin.cpp(1133) [0000000000C24190] WARNING Failed: Hr: = [0x80040e37] Error while querying the Database SQL_DB_NAME recovery model from SQLInstance INSTANCE_NAME
12DC 10C8 04/09 18:34:52.004 31 sqlwriterhelperplugin.cpp(1135) [0000000000C24190] WARNING SQL Error Information: Invalid object name 'SYS.DATABASES'.
12DC 10C8 04/09 18:34:52.004 31 aasubtask.cpp(906) [0000000000C704F0] WARNING <?xml version="1.0"?>
12DC 10C8 04/09 18:34:52.004 31 aasubtask.cpp(906) [0000000000C704F0] WARNING <Status xmlns="http://schemas.microsoft.com/2003/dls/StatusMessages.xsd" StatusCode="-2147217865" Reason="Error" CommandID="RAPreBackup" CommandInstanceID="ddee385e-ace6-45fd-bb48-82bf5646eedb" GuidWorkItem="231de959-e1ca-4255-a47f-387186b58d43" TETaskInstanceID="8888c2d6-ec84-41f1-adb2-21b0e4368d38"><ErrorInfo xmlns="http://schemas.microsoft.com/2003/dls/GenericAgentStatus.xsd" ErrorCode="998" DetailedCode="-2147217865" DetailedSource="2"/></Status>
12DC 10C8 04/09 18:34:52.004 03 runtime.cpp(1389) [0000000000C07CE0] FATAL Subtask failure, sending status response XML=[<?xml version="1.0"?>
12DC 10C8 04/09 18:34:52.004 03 runtime.cpp(1389) [0000000000C07CE0] FATAL <Status xmlns="http://schemas.microsoft.com/2003/dls/StatusMessages.xsd" StatusCode="-2147217865" Reason="Error" CommandID="RAPreBackup" CommandInstanceID="ddee385e-ace6-45fd-bb48-82bf5646eedb" GuidWorkItem="231de959-e1ca-4255-a47f-387186b58d43" TETaskInstanceID="8888c2d6-ec84-41f1-adb2-21b0e4368d38"><ErrorInfo xmlns="http://schemas.microsoft.com/2003/dls/GenericAgentStatus.xsd" ErrorCode="998" DetailedCode="-2147217865" DetailedSource="2"/></Status>
12DC 10C8 04/09 18:34:52.004 03 runtime.cpp(1389) [0000000000C07CE0] FATAL ]
12DC 10C8 04/09 18:34:52.020 03 sqlqueryhelper.cpp(290) [000000000339F010] 8888C2D6-EC84-41F1-ADB2-21B0E4368D38 WARNING Failed: Hr: = [0x80040e37] : Encountered Failure: : lVal : hr

=====

For the most current version of this article please see the following:

2711168 - You receive "Unknown error (0x80040e37)" in System Center Data Protection Manager 2012 when you try to create recovery points for SQL Server or SharePoint databases

J.C. Hornbeck | Knowledge Engineer | Management and Security Division

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

App-V Team blog: http://blogs.technet.com/appv/
ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
DPM Team blog: http://blogs.technet.com/dpm/
MED-V Team blog: http://blogs.technet.com/medv/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
SCVMM Team blog: http://blogs.technet.com/scvmm
Server App-V Team blog: http://blogs.technet.com/b/serverappv
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
WSUS Support Team blog: http://blogs.technet.com/sus/

The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/