Dynamics Community Forum Thread Details

Entity incidentresolution : Quick create is not supported for non-refreshed Entity

I received the following solution from Microsoft Support, which I am posting here for future reference.

You will need to attach a non failed database again to the SQL server(fresh one) apply the following script before attempting to import, once you ran the script, please retry the import.

Script:

BEGIN TRANSACTION

IF NOT EXISTS (SELECT * FROM sys.objects

WHERE object_id = OBJECT_ID(N'[dbo].[IncidentResolutionBase]') AND type in (N'U'))

BEGIN

/****** Create the metadataschema to add support for the Extension Table required for the incident resolution custom attributes******/

CREATE TABLE [dbo].[IncidentResolutionBase](

[ActivityId] [uniqueidentifier] NOT NULL,

CONSTRAINT [PK_IncidentResolutionBase] PRIMARY KEY CLUSTERED

(

[ActivityId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

ALTER TABLE [dbo].[IncidentResolutionBase] SET (LOCK_ESCALATION = DISABLE)

ALTER TABLE [dbo].[IncidentResolutionBase] WITH CHECK ADD CONSTRAINT [FK_IncidentResolutionBase_ActivityPointerBase] FOREIGN KEY([ActivityId])

REFERENCES [dbo].[ActivityPointerBase] ([ActivityId])

ALTER TABLE [dbo].[IncidentResolutionBase] CHECK CONSTRAINT [FK_IncidentResolutionBase_ActivityPointerBase]

END

/****** updating the metadataschema to add support for the Extension Table and Required metada data attributes on incident resolution entity******/

UPDATE mse

SET IsReadOnlyInMobileClient = 0, IsQuickCreateEnabled = 1, CanCreateAttributes = 1, IsAIRUpdated = 1, ExtensionTableName = 'IncidentResolutionBase'

FROM [MetadataSchema].[Entity] AS mse INNER JOIN [SolutionBase] as sb on mse.SolutionId = sb.SolutionId

WHERE mse.LogicalName = 'incidentresolution' AND sb.UniqueName NOT IN ('msdynce_ServicePatch201911', 'msdynce_ServicePatch', 'msdynce_Service');

DECLARE @updatedRows AS INT = @@ROWCOUNT;

DECLARE @solutionCount AS INT = (SELECT COUNT(UniqueName) FROM [MetadataSchema].[Entity] AS mse INNER JOIN [SolutionBase] as sb on mse.SolutionId = sb.SolutionId

WHERE mse.LogicalName = 'incidentresolution' AND sb.UniqueName NOT IN ('msdynce_ServicePatch201911', 'msdynce_ServicePatch', 'msdynce_Service'));

IF @updatedRows <> @solutionCount

BEGIN

THROW 51000, 'Incorrect rows updated!', 1;

END

COMMIT TRANSACTION

Quick Links

Leaderboard