DPM / MABS console crashes error 917

Lately I faced a challenge at one of my clients where the DPM console crashed constantly. Going through the error logs I noticed that the storage procedure was causing the error and needed to contact Microsoft support since we are not able to alter that content of the DPMDB without jeopardizing the supported scenario.

The following script was run as a SQL query from SQL Management Studio and afterwards we was able to delete protected objects without the console crashing.

Before executing anything please take note of two things:

1. Backup your DPMDB or MABS DB before executing any SQL script
2. You run the script on your own risk

IF EXISTS (SELECT * FROM dbo.sysobjects

    WHERE id = OBJECT_ID(N'[dbo].[tbl_PRM_DatasourceLastActiveServerMap]')
    AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    DROP TABLE [dbo].[tbl_PRM_DatasourceLastActiveServerMap]
    GO
CREATE TABLE [dbo].[tbl_PRM_DatasourceLastActiveServerMap] (
        [DatasourceId]          [GUID]          NOT NULL,
        [ActiveNode]            [nvarchar](256) NULL,
        [IsGCed]                [bit]           NOT NULL
        ) ON [PRIMARY]
    GO
ALTER TABLE [dbo].[tbl_PRM_DatasourceLastActiveServerMap] ADD
CONSTRAINT [pk__tbl_PRM_DatasourceLastActiveServerMap__DatasourceId] PRIMARY KEY NONCLUSTERED
    (
        [DatasourceId]
    )  ON [PRIMARY],
CONSTRAINT [DF_tbl_PRM_DatasourceLastActiveServerMap_IsGCed] DEFAULT
    (
        0
    ) FOR [IsGCed]

GO