[dspConduct/MDM] - [Request SLA Notification service page] Index was outside the bounds of the array.

December 19, 2024 21:49
Updated

Issue

The Master Data Management service page, Request SLA Notification , fails with the error Index was outside the bounds of the array.

Root Cause

Invalid html in one of the dge.dbo.ttCategoryWorkflowMessageLanguage.Message records in MDM.

Resolution

1. Run the following 2 queries.

SELECT
Event, 
LanguageID, 
CategoryID 
FROM 
dge.dbo.ttCategoryWorkflowMessageLanguage
WHERE 
( [Message] LIKE N'%&lt;%' ) 
OR ( [Message] LIKE N'%&gt;%' )


SELECT
Event,
LanguageID,
CategoryID
FROM
dge.dbo.ttCategoryWorkflowMessageLanguage
WHERE
( ( [Message] NOT LIKE N'%<HEADER>%' )
OR ( [Message] NOT LIKE N'%</HEADER>%' )
OR ( [Message] NOT LIKE N'%<CONTENT>%' )
OR ( [Message] NOT LIKE N'%</CONTENT>%' )
OR ( [Message] NOT LIKE N'%#STARTDATA#%' )
OR ( [Message] NOT LIKE N'%#ENDDATA#%' ) )
AND [Event] = 'LateSummary'

2. If either of these queries return records, then that means the dge.dbo.ttCategoryWorkflowMessageLanguage.Message field has invalid HTML statements or has '<' or '>' in the HTML processed message.

2a. If the dge.dbo.ttCategoryWorkflowMessageLanguage.EVENT DOES NOT EQUAL 'LateSummary', then in dsp go to MDM/Vertical of the Category/Workflow Messages icon/ Category Workflow Language Message page to fix the message.

2b. If the dge.dbo.ttCategoryWorkflowMessageLanguage.EVENT = 'LateSummary' , you must edit the dge.dbo.ttCategoryWorkflowMessageLanguage.Message table in SSMS.

Note: For LateSummary events, editing on the Category Workflow Language Message page, after saving, the 2 values #STARTDATA# #ENDDATE" will be moved in the Message so they are directly next to each other, which will also cause the "Request SLA Notification" page to continue failing.