000032592 - RSA DLP | Error "contact your administrator and reference error number with incremental number when trying to change the policy"

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032592
Applies ToRSA Product Set: DLP
RSA Product/Service Type: Endpoint
RSA Version/Condition: 9.X
Platform: Windows
 
IssueGetting error contact your administrator and reference error number with incremental number when trying to change the policy.
CauseIssue in communication between the Enterprise manager server and the SQL database which lead to corruption of one of the tables and preventing the EM from saving more data to the policy.
Note: The issue has to be happening only with one of the policies not all of them, if all of them then check the connectivity with database.
The below logs appear in em.log 
 
18 Feb 2016 08:54:04,377 | ERROR - DataSourceErrorReporterImpl.reportError(66) | EM-003: Unable to communicate with the database
18 Feb 2016 08:54:04,377 | ERROR - DataSourceErrorReporterImpl.reportError(68) | SQLServerException: String or binary data would be truncated.
18 Feb 2016 08:54:04,377 | ERROR - DataSourceErrorReporterImpl.reportError(69) | Vendor Code: 8152
18 Feb 2016 08:54:04,377 | ERROR - DataSourceErrorReporterImpl.reportError(70) | SQL State: 22001
18 Feb 2016 08:54:04,377 | WARN - JDBCExceptionReporter.logExceptions(100) | SQL Error: 8152, SQLState: 22001
18 Feb 2016 08:54:04,377 | ERROR - JDBCExceptionReporter.logExceptions(101) | String or binary data would be truncated.
18 Feb 2016 08:54:04,392 | ERROR - GlobalErrorHandler.resolveException(116) | ERROR 16 processed by GlobalErrorHandler org.springframework.dao.DataIntegrityViolationException: could not insert: [com.tablus.tem.domain.policy.TransmissionAttributesDetectionRule]; SQL [insert into P_TRANSMISSION_ATTRIBUTES_DETECTION_RULE (sender_not, sender_value, recipient_not, recipient_value, recipient_groups_not, fromip_not, fromip_value, toip_not, toip_value, fromhost_not, fromhost_value, tohost_not, tohost_value, tourl_not, tourl_value, from_device_type_not, from_device_type_value, to_device_type_not, to_device_type_value, TRANSMISSION_ATTRIBUTES_DETECTION_RULE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [com.tablus.tem.domain.policy.TransmissionAttributesDetectionRule]

 
WorkaroundDelete the policy from the policy list and then recreate it again, this will delete the corrupted entry in the database and recreate a clean one.

Attachments

    Outcomes