search cancel

Red banner when editing some policies after upgrading to 15.5

book

Article ID: 173754

calendar_today

Updated On:

Products

Data Loss Prevention Enforce Data Loss Prevention Cloud Detection Service

Issue/Introduction

After upgrading Symantec DLP to 15.5 from any supported version. Some policies cannot be edited and a red banner is obverved

Tomcat logs will show:

Thread: 110 SEVERE [com.vontu.manager] [/EditPolicy] Unexpected error occurred while processing action
Thread: 110 SEVERE [com.vontu.manager] [/EditPolicy]
Cause:
java.lang.IllegalStateException: Unknown document type: docxuworksjava.lang.IllegalStateException: Unknown document type: docxuworks

 

Cause

During migration to 15.5 docuworks is erroneously replaced with docxuworks in policies that existed before the migration. This file type is commonly selected when all file types are selected.

Resolution

1. Stop the DLP services

2. Log into the database as the schema owner(usually protect).

3. Run the following Query:

UPDATE DocumentMetaInfoCondition SET MimeType = REPLACE(MimeType, 'doc,docxuworks', 'docuworks')
            WHERE MIMETYPE LIKE '%docxuworks%';

UPDATE DocumentMetaInfoCondition SET MimeType = REPLACE(MimeType, 'encrypted_doc,docx', 'encrypted_doc')
            WHERE MIMETYPE LIKE '%encrypted_doc,docx%';

UPDATE DocumentMetaInfoCondition SET MimeType = REPLACE(MimeType, 'encrypted_ppt,pptx', 'encrypted_ppt')
            WHERE MIMETYPE LIKE '%encrypted_ppt,pptx%';    

UPDATE DocumentMetaInfoCondition SET MimeType = REPLACE(MimeType, 'encrypted_xls,xlsx', 'encrypted_xls')
            WHERE MIMETYPE LIKE '%encrypted_xls,xlsx%';

COMMIT;

The number of rows updated should match the number of affected policies.

4. Restart the DLP Services

5. Verify you can edit the policy.