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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×