The “Internal System Exception“ is a result of there being a duplicate SO in the Apex Central DB.
2024-06-18 15:51:12,686 42213 [41] ERROR - __UserDefinedSOResourceController__: PostList: Exception=Violation of UNIQUE KEY constraint 'UQ__#AF71222__49EAECA7051844DC'. Cannot insert duplicate key in object 'dbo.@RealAtRiskPointsCount'. The duplicate key value is (0x16ed8ad7c75f60a185f81a17f9dcc92e). The statement has been terminated. [0] 2024-06-18 15:51:12,686 42213 [41] DEBUG - __RestfulResponseHelperService`1__: InitializeMeta: meta = {"Result":0,"ErrorCode":6,"ErrorMsg":"Internal system exception"} [0] 2024-06-18 15:51:12,686 42213 [41] DEBUG - __RestfulResponseHelperService`1__: CreateResponseData: ErrorCode=6, ErrorMsg=Internal system exception [0] 2024-06-18 15:51:12,686 42213 [41] DEBUG - __RestfulResponseHelperService`1__: CreateResponseData: HttpStatusCode=500, HttpStatus=InternalServerError [0] 2024-06-18 15:51:12,686 42213 [41] DEBUG - __UserDefinedSOResourceController__: PostList: Leave Function. [0]
It is specifically this SO here:
0x16ed8ad7c75f60a185f81a17f9dcc92e
In the tb_BlacklistInfo.csv, there are 2 instances of this SO:
62822,0x16ed8ad7c75f60a185f81a17f9dcc92e,BB53B968815E-43C798CD-93C4-FF32-ADC9,1,2,CF23F9535BC3F6BA26818CFBA7D69D59F94C3D9B,3,1720415499,2024-07-08 05:11:39.000,NULL,Rated as high risk,CF23F9535BC3F6BA26818CFBA7D69D59F94C3D9B,0,0,1,1,0xF5C98326,0,NULL,2024-06-08 10:44:33.863,C704605F80A6FCDC258BE48F432B2B43B081624B,NULL,NULL,C704605F80A6FCDC258BE48F432B2B43B081624B,43FE95E54470A4D246F5FA6FDF9B1A87,NULL,NULL,NULL 62824,0x16ed8ad7c75f60a185f81a17f9dcc92e,BB53B968815E-43C798CD-93C4-FF32-ADC9,1,2,CF23F9535BC3F6BA26818CFBA7D69D59F94C3D9B,3,1720415499,2024-07-08 05:11:39.000,NULL,Rated as high risk,CF23F9535BC3F6BA26818CFBA7D69D59F94C3D9B,0,0,1,1,0xF5C98326,0,NULL,2024-06-08 10:44:33.867,C704605F80A6FCDC258BE48F432B2B43B081624B,NULL,NULL,C704605F80A6FCDC258BE48F432B2B43B081624B,43FE95E54470A4D246F5FA6FDF9B1A87,NULL,NULL,NULL
One with ID 62822 and another with 62824.
[Action]
Please do the following:
Note: Take the full backup of DB before doing any activity.
-
In the Apex Central DB, please run the following query below:
DELETE FROM tb_BlacklistInfo WHERE ID='62824' AND SLF_Key='0x16ed8ad7c75f60a185f81a17f9dcc92e'
-
Check if the issue still occurs.
If the issue still occurs, please collect the CDT logs again and send it to us.