locked
Error 197 after applying DPM 2012 R2 UR5 RRS feed

  • Question

  • Error 197 occurring after applying UR5 for DPM 2012 R2 when modifying a protection group or stopping protection of a member     Has anyone seen the issue or know of a fix?
    Monday, February 23, 2015 7:25 AM

Answers

  • Thanks Mark and Patrick for actively reporting the issue.
    You can unshare\delete the links to your db dumps now.

    This is an issue with UR5, where Create\Modify\Delete on a PG with Clustered File Server datasources may fail with Error 197, or cause a console crash.

    Please use this workaround and see if it resolves the issue:

    1. Close the UI and all DPM services
    2. Important: Take a full database backup of the DPMDB to a safe location
    3. Run the SQL script on the DPM DB that is posted below
    4. Start all DPM services, and open the UI

     

    This issue may recur whenever the underlying volume of the File Server migrates across nodes of the cluster and an inquiry is triggered on the File Server cluster role. You can run the script again as required.


    DELETE FROM dbo.tbl_IM_ProtectedObject
    WHERE ProtectedObjectId IN
    (
    	SELECT PO.ProtectedObjectId
    	FROM dbo.tbl_IM_ProtectedObject AS PO
    	JOIN dbo.tbl_AM_Server as SRVR
    	ON PO.ServerId = SRVR.ServerId
    	JOIN dbo.tbl_IM_DataSource AS DS
    	ON PO.DataSourceId = DS.DataSourceId
    	WHERE DS.AppId = '00000000-0000-0000-0000-000000000000'
    	AND PO.ProtectedInPlan = 0
    	AND PO.ProtectedObjectId NOT IN (SELECT ProtectedObjectId FROM dbo.tbl_IM_ProtectedObjectAlerts)
        AND CONVERT(XML,PO.LogicalPath).exist(
            '/child::ArrayOfInquiryPathEntryType/child::InquiryPathEntryType[attribute::Type="NonRootTargetShare"]'
        ) = 1
        AND PO.ProtectedObjectId != PO.DataSourceId
    	AND SRVR.ServerId = DS.ServerId
    	AND SRVR.IsRG = 1
    )

    Arun

    Thursday, March 5, 2015 1:01 PM
  • Update Rollup 6 for System Center 2012 R2 Data Protection Manager

    https://support.microsoft.com/en-us/kb/3030574

    Issue 9

    The Refresh button in the Create/Modify PG wizard may be disabled even after you select a PS computer.

    Issue 15

    In some locales, the Refresh button and the surrounding text are not visible in the protection wizard.


    Have a nice day !!!
    DPM 2012 R2: Remove Recovery Points
    DPM blog

    Thursday, April 30, 2015 7:02 AM
    Moderator

All replies

  • Can you please let us know if you are observing any errors in MSDPMCurr.errlog file?

    Also, were you able to modify protection using PowerShell?


    Regards, Trinadh [MSFT] This posting is provided AS IS with no warranties, and confers no rights. If you found the reply helpful, please MARK IT AS ANSWER. Looking for source of information for DPM? http://blogs.technet.com/b/dpm/ http://technet.microsoft.com/en-in/library/hh758173.aspx

    Monday, March 2, 2015 12:14 PM
    Moderator
  • Hi Trinadh,

    The following errors appear in the log when attempting to modify a protection group

    0FD4 49C8 03/02 14:48:32.506 17 Translate.cs(644)   FATAL Error in ConfigureProtectedGroup:
    0FD4 49C8 03/02 14:48:32.506 17 Translate.cs(644)   FATAL Microsoft.Internal.EnterpriseStorage.Dls.Utils.InvalidProtectedGroupSpecException: Invalid Intent Metadata Catalog XML: ProtectedObject cfa436df-3022-4038-94e7-37d1a9412555 has duplicate entries.
    0FD4 49C8 03/02 14:48:32.506 17 Translate.cs(644)   FATAL    at Microsoft.Internal.EnterpriseStorage.Dls.Intent.IntentManager.ValidateProtectedObjectDB(IMCatalogType IMCatalogPersist, IMCatalogDB catalogDB)
    0FD4 49C8 03/02 14:48:32.506 17 Translate.cs(644)   FATAL    at Microsoft.Internal.EnterpriseStorage.Dls.Intent.ProtectedGroupTranslator.PrepareForTranslation()
    0FD4 49C8 03/02 14:48:32.506 17 Translate.cs(644)   FATAL    at Microsoft.Internal.EnterpriseStorage.Dls.Intent.ProtectedGroupTranslator.TranslateGroup(IMCatalogType IMCatalogXmlPassed, String intentCatalogXml)
    0FD4 49C8 03/02 14:48:32.506 17 Translate.cs(644)   FATAL *** Mojito error was: InvalidProtectedGroupSpec; 0; None
    0FD4 49C8 03/02 14:48:32.506 15 SchedulerImpl.cs(640)   NORMAL Entering ConsistencyCheck
    0FD4 49C8 03/02 14:48:32.508 09 Catalog.cs(1020)   WARNING No retry on exception The specified @name ('') does not exist. while executing sp_delete_alert
    0FD4 49C8 03/02 14:48:32.508 09 Catalog.cs(1027)   WARNING SqlException encountered, SqlRetryCommand diag details - SqlCommandText  => Name=msdb.dbo.sp_delete_alert, CommandType=StoredProcedure
    0FD4 49C8 03/02 14:48:32.508 09 Catalog.cs(1027)   WARNING CommandDiagInfo => CanRetry=False, CommandTimeout=3600
    0FD4 49C8 03/02 14:48:32.508 09 Catalog.cs(1027)   WARNING CommandParams   => Count=2, InTx=True
    0FD4 49C8 03/02 14:48:32.508 09 Catalog.cs(1027)   WARNING      Param[0]   => ParameterName=@name | Value= | Size=0 | DbType=NVarChar | Direction=Input | IsNullable=False
    0FD4 49C8 03/02 14:48:32.508 09 Catalog.cs(1027)   WARNING      Param[1]   => ParameterName=@RETURN_VALUE | Value=1 | Size=0 | DbType=Int | Direction=ReturnValue | IsNullable=False
    0FD4 49C8 03/02 14:48:32.855 15 SqlAgentHelper.cs(1395)   WARNING Invalid sub day recurrence type.
    0FD4 49C8 03/02 14:48:32.922 15 SqlAgentHelper.cs(1395)   WARNING Invalid sub day recurrence type.
    0FD4 49C8 03/02 14:48:32.930 15 SqlAgentHelper.cs(1395)   WARNING Invalid sub day recurrence type.

    Monday, March 2, 2015 2:53 PM
  • Experiencing the same problems over here. Can't modify/delete a protection group. Error 197.

    0B44 30E8 03/03 12:34:05.470 17 Translate.cs(644) FATAL Error in ConfigureProtectedGroup:
    0B44 30E8 03/03 12:34:05.470 17 Translate.cs(644) FATAL Microsoft.Internal.EnterpriseStorage.Dls.Utils.InvalidProtectedGroupSpecException: Invalid Intent Metadata Catalog XML: ProtectedObject 7846c253-99ec-4f5d-9a28-1dabaefbe1a1 has duplicate entries.
    0B44 30E8 03/03 12:34:05.470 17 Translate.cs(644) FATAL    at Microsoft.Internal.EnterpriseStorage.Dls.Intent.IntentManager.ValidateProtectedObjectDB(IMCatalogType IMCatalogPersist, IMCatalogDB catalogDB)
    0B44 30E8 03/03 12:34:05.470 17 Translate.cs(644) FATAL    at Microsoft.Internal.EnterpriseStorage.Dls.Intent.ProtectedGroupTranslator.PrepareForTranslation()
    0B44 30E8 03/03 12:34:05.470 17 Translate.cs(644) FATAL    at Microsoft.Internal.EnterpriseStorage.Dls.Intent.ProtectedGroupTranslator.TranslateGroup(IMCatalogType IMCatalogXmlPassed, String intentCatalogXml)
    0B44 30E8 03/03 12:34:05.470 17 Translate.cs(644) FATAL *** Mojito error was: InvalidProtectedGroupSpec; 0; None
    0B44 30E8 03/03 12:34:05.470 15 SchedulerImpl.cs(640) NORMAL Entering ConsistencyCheck
    0B44 30E8 03/03 12:34:05.473 09 Catalog.cs(1020) WARNING No retry on exception The specified @name ('') does not exist. while executing sp_delete_alert
    0B44 30E8 03/03 12:34:05.473 09 Catalog.cs(1027) WARNING SqlException encountered, SqlRetryCommand diag details - SqlCommandText  => Name=msdb.dbo.sp_delete_alert, CommandType=StoredProcedure
    0B44 30E8 03/03 12:34:05.473 09 Catalog.cs(1027) WARNING CommandDiagInfo => CanRetry=False, CommandTimeout=3600
    0B44 30E8 03/03 12:34:05.473 09 Catalog.cs(1027) WARNING CommandParams   => Count=2, InTx=True
    0B44 30E8 03/03 12:34:05.473 09 Catalog.cs(1027) WARNING      Param[0]   => ParameterName=@name | Value= | Size=0 | DbType=NVarChar | Direction=Input | IsNullable=False
    0B44 30E8 03/03 12:34:05.473 09 Catalog.cs(1027) WARNING      Param[1]   => ParameterName=@RETURN_VALUE | Value=1 | Size=0 | DbType=Int | Direction=ReturnValue | IsNullable=False
    



    Tuesday, March 3, 2015 12:42 PM
  • Hi,

    Please try the workaround as described in this thread and 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.

    Tuesday, March 3, 2015 8:29 PM
    Moderator
  • Hi Mike,

    I have run the script and it returned zero rows affected    The causes also do not appear to relate to this issue

    Mark

    Tuesday, March 3, 2015 11:34 PM
  • (0 row(s) affected)

    But the affected protection group which raises error 197 doesn't contain System State or BMR. So doesn't surprise me the script doesn't return any rows.


    Wednesday, March 4, 2015 7:42 AM
  • Hi Mark,

    Will it possibly for you to give a dump of your DB by running this SQL script?
    To dump it into CSV format, use the command below.
    SELECT
    	PO.ProtectedObjectId,
    	PO.DataSourceId,
    	PO.LogicalPath,
    	PO.PhysicalPath,
    	PO.PathHash,
    	PO.ServerId,
    	PO.Pending,
    	PO.Matches,
    	PO.Rejected,
    	PO.ProtectedInPlan,
    	PO.IsExcluded,
    	PO.ComponentName,
    	PO.ComponentType,
    	PO.ReferentialDataSourceId,
    	PO.ActivelyProtectedByDataSourceId,
    	PO.ProtectionScope,
    	PO.IsGCed,
    	PO.IsInLastInquiry,
    
    	DS.ProtectedGroupId,
    	DS.DataSourceName,
    	DS.ServerID,
    	DS.AppId,
    	DS.ApplicationPath,
    	DS.InitializationType,
    	DS.MarkedForDeletion,
    	DS.PreferredServerForProtection,
    	DS.IsDpmDatasource,
    	DS.CloudInitializationType,
    	DS.AllowedBackupType,
    	DS.IsGCed,
    	DS.CloudProtectionStatus,
    	DS.IsInLastInquiry,
    	
    	SPO.ServerName,
    	SPO.NetbiosName,
    	SPO.DomainName,
    	SPO.IsRG,
    	SPO.ClusterId,
    	SPO.MarkedForDeletion,
    	SPO.IsDPM,
    	SPO.DPMServerId,
    
    	SDS.ServerName,
    	SDS.NetbiosName,
    	SDS.DomainName,
    	SDS.IsRG,
    	SDS.ClusterId,
    	SDS.MarkedForDeletion,
    	SDS.IsDPM,
    	SDS.DPMServerId
    FROM dbo.tbl_IM_ProtectedObject AS PO
    JOIN dbo.tbl_IM_DataSource AS DS
    ON PO.DataSourceId = DS.DataSourceId
    JOIN dbo.tbl_AM_Server AS SPO
    ON PO.ServerId = SPO.ServerId
    JOIN dbo.tbl_AM_Server AS SDS
    ON DS.ServerId = SDS.ServerId
    ORDER BY PO.DataSourceId
    sqlcmd.exe -S <SQLServerInstanceName> -E -d <DPMDBName> -y 4096 -i podump.sql -o podump.csv -s `

    Arun
    Wednesday, March 4, 2015 10:27 AM
  • Arun, do you mind if i tag along in this problem troubleshooting?

    I have a csv dump file of 46mb (652kb zipped). How do i get this to you?

    Wednesday, March 4, 2015 11:06 AM
  • Patrick that will be really helpful, can you please share the file through One Drive, in worst case will it be fine to share your email id we will contact you to get the details.

    We are investigating this issue with high priority but are blocked on the above details.

    Wednesday, March 4, 2015 11:42 AM
    Moderator
  • Thanks Arun

    Mark


    • Edited by Mark Di Ciano Thursday, March 5, 2015 12:57 PM Removed link
    Wednesday, March 4, 2015 11:49 AM
  • Hey, can you tell us what exactly (Datasources) you are protecting?
    Is it a createPG\modifyPG?
    Did you try creating the PG both with and without refresh?

    It is an NFS\other-kind of high availability Share?
    Wednesday, March 4, 2015 1:10 PM
  • It's a modifyPG on "09 - NATSCHOOL FILES - 01:00"

    I'm actually trying to remove the PG, because the 2008r2 fileserver cluster is going to be decomissioned. The datasources are Shares on that cluster.

    The datasources protected by this PG are :

    Computer     Name  ObjectType 
    --------     ----  ---------- 
    NFS-CLUSTFS  V:\   Volume     
    NFS-CLUSTFS  W:\   Volume     
    NFS-CLUSTFS  T:\   Volume     
    NFS-CLUSTFS  Q:\   Volume     
    NFS-CLUSTFS  R:\   Volume     
    NFS-CLUSTFS  U:\   Volume     
    NFS-CLUSTFS  P:\   Volume     
    NFS-CLUSTFS  O:\   Volume     
    NFS-CLUSTFS  S:\   Volume     
    NFS-CLUSTFS  L:\   Volume     
    NFS-CLUSTFS  Z:\   Volume     
    NFS-CLUSTFS  X:\   Volume     
    NFS-CLUSTFS  Y:\   Volume     
    NFS-CLUSTFS  M:\   Volume     
    NFS-CLUSTFS  K:\   Volume     
    NFS-CLUSTFS  N:\   Volume     
    NFS-CLUSTFS  X:\   Volume 

    And it's the only PG we are having these Error 197 problems on. All other PG's can be modified. And new PG's can be created as well.

    So i don't know why only this PG can't be modified.


    Wednesday, March 4, 2015 2:11 PM
  • The error appears to be occurring only on a protection group which contains file share and Active Directory system state data sources    Other existing protection groups of Hyper-V, SQL and Exchange data sources modify successfully.     New protection groups can also be created and modified/removed.
    Wednesday, March 4, 2015 2:50 PM
  • Thanks Mark and Patrick for actively reporting the issue.
    You can unshare\delete the links to your db dumps now.

    This is an issue with UR5, where Create\Modify\Delete on a PG with Clustered File Server datasources may fail with Error 197, or cause a console crash.

    Please use this workaround and see if it resolves the issue:

    1. Close the UI and all DPM services
    2. Important: Take a full database backup of the DPMDB to a safe location
    3. Run the SQL script on the DPM DB that is posted below
    4. Start all DPM services, and open the UI

     

    This issue may recur whenever the underlying volume of the File Server migrates across nodes of the cluster and an inquiry is triggered on the File Server cluster role. You can run the script again as required.


    DELETE FROM dbo.tbl_IM_ProtectedObject
    WHERE ProtectedObjectId IN
    (
    	SELECT PO.ProtectedObjectId
    	FROM dbo.tbl_IM_ProtectedObject AS PO
    	JOIN dbo.tbl_AM_Server as SRVR
    	ON PO.ServerId = SRVR.ServerId
    	JOIN dbo.tbl_IM_DataSource AS DS
    	ON PO.DataSourceId = DS.DataSourceId
    	WHERE DS.AppId = '00000000-0000-0000-0000-000000000000'
    	AND PO.ProtectedInPlan = 0
    	AND PO.ProtectedObjectId NOT IN (SELECT ProtectedObjectId FROM dbo.tbl_IM_ProtectedObjectAlerts)
        AND CONVERT(XML,PO.LogicalPath).exist(
            '/child::ArrayOfInquiryPathEntryType/child::InquiryPathEntryType[attribute::Type="NonRootTargetShare"]'
        ) = 1
        AND PO.ProtectedObjectId != PO.DataSourceId
    	AND SRVR.ServerId = DS.ServerId
    	AND SRVR.IsRG = 1
    )

    Arun

    Thursday, March 5, 2015 1:01 PM
  • Thanks Arun, the script worked.

    Thursday, March 5, 2015 1:14 PM
  • Thanks Arun, the script has resolved the issue

    Mark

    Thursday, March 5, 2015 3:20 PM
  • Thanks !! It worked for me !
    Thursday, March 5, 2015 9:18 PM
  • Update Rollup 6 for System Center 2012 R2 Data Protection Manager

    https://support.microsoft.com/en-us/kb/3030574

    Issue 9

    The Refresh button in the Create/Modify PG wizard may be disabled even after you select a PS computer.

    Issue 15

    In some locales, the Refresh button and the surrounding text are not visible in the protection wizard.


    Have a nice day !!!
    DPM 2012 R2: Remove Recovery Points
    DPM blog

    Thursday, April 30, 2015 7:02 AM
    Moderator
  • Update Rollup 6 for System Center 2012 R2 Data Protection Manager

    https://support.microsoft.com/en-us/kb/3030574

    Issue 9

    The Refresh button in the Create/Modify PG wizard may be disabled even after you select a PS computer.

    Issue 15

    In some locales, the Refresh button and the surrounding text are not visible in the protection wizard.


    Have a nice day !!!
    DPM 2012 R2: Remove Recovery Points
    DPM blog


    UR6 does resolve error 197 when trying to create new or modify protection groups.

    My Blog | www.buchatech.com | www.systemcenterportal.com
    If you found this post helpful, please give it a "Helpful" vote. If it answered your question, remember to mark it as an "Answer". This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing!

    Thursday, May 14, 2015 5:36 AM
    Moderator
  • Hi,

    I'm facing the error 197 when I want to change a PG , but my version is 4.02.1312 therefore RU6 .

    I try to SQL script in the upper of this thread but ineffective.

    Have you an idea ?

    Thursday, June 4, 2015 8:30 AM
  • Please open a new post - your crash is not related to the known UR5 issue described here.  Please include details of the crash from event message.

    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, June 4, 2015 4:52 PM
    Moderator