User Risk Score import returns ORA-12899: value too large for column

Products

• Data Loss Prevention Core Package
• Information Centric Analytics

Issue/Introduction

When trying to import user risk scores from Information Centric Analytics (ICA), the import fails and displays the following error message in the Enforce console:

Unexpected error importing users data. See the localhost log for more information.

The original data was not affected.

The localhost log contains a corresponding error message similar to the following:

Error Msg = ORA-12899: value too large for column "PROTECT"."DATAUSER"."TITLE" (actual: 66, maximum: 64)

Environment

Release : 16.x

Component : User Risk Score

Cause

Symantec DLP's call to ICA's REST API returns a set of users and their attributes. These attributes are pulled from the table dbo.LDW_Users in the RiskFabric relational database. When a character string in this record set exceeds the maximum character length of a destination column in DLP's protect database, the user risk score import fails and returns Oracle error ORA-12899.

Resolution

The condition that generates this error is addressed in the 25.1 release.