Data Is Not Loading In Queue Dashboard On The Insights Application

[system]

Data is not ingested in queueitem table.

Insights Event viewer logs:

Times : 11-05-2023 18:20:00

ETL Ingestion 8cb1158d-f6fc-4869-b1fb-2f54ff1868ff was interrupted by exceptionMicrosoft.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'voya_UiPathInsights.dbo.QueueItems', column 'ProcessingExceptionDetails'. Truncated value: '{

"ClaimNumber": "C-2022-1799788",

"PushMatch": "Not Applicable",

"NewDuplicateClaime": "No'.

Root Cause: Issue is with the column length so we need to update the same.

Resolution: Run/ Execute the below query against Insights DB

IF COL_LENGTH('[dbo].[QueueItems]', 'ProcessingExceptionDetails') IS NOT NULL

AND 'Nvarchar' IN (

SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'QUEUEITEMS'

AND TABLE_SCHEMA = 'DBO'

AND COLUMN_NAME = 'PROCESSINGEXCEPTIONDETAILS'

)

BEGIN

ALTER TABLE [dbo].[QueueItems]

ALTER COLUMN ProcessingExceptionDetails NVARCHAR(MAX)

END

Note: This is known issue in 22.10 version and has been resolved in latest version.