Views:

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.

  1. In the Apex Central DB, please run the following query below:

    DELETE FROM tb_BlacklistInfo WHERE ID='62824' AND SLF_Key='0x16ed8ad7c75f60a185f81a17f9dcc92e'

  2. Check if the issue still occurs.

If the issue still occurs, please collect the CDT logs again and send it to us.