Error Message

There are no errors, warnings or exceptions logged in the GUI, Event Logs, DTrace. The Client Log CustomTraceFile.log under C:\Users\\AppData\Local\Symantec Corporation\Enterprise Vault Accelerators\Compliance_Client\Logs may list the following entry for one or more message types:

[ACD] <1234> : ClientChannelSink.SyncProcessMessage - ClientChannelSink SyncProcessMessage !!ERROR!!: URI: tcp://CA:8086/RBO_cases -- Method: UpdateCase -- Error: Bloomberg review percentage must be between 0 and 100

 

The cause of the issue is missing Policy Percentage values for the Department's CaseID in the Customer database.

The most likely reason for this is the CA Customer database was connected to a Discovery Accelerator (DA) Configuration database at some point in its lifetime and run in this configuration for some time. As DA does not use any Random Sampling features, it is very likely that a change was made to the Department's properties whilst the CA Customer database was connected to a DA Configuration database, thus setting the Policy Percentages, which are only used by CA Random Sampling, to a value that would indicate they are not used. This value causes certain entries to be removed as they are not used by DA. Correcting the configuration by re-connecting the CA Customer database to a CA Configuration database does not correct the issue as the Policy Percentage values are not re-added. Those Departments that did not have their properties edited when the CA Customer database was connected to a DA Configuration database should not have this issue.

As the Policy Percentage values are missing, editing a Department's status via the Properties tab does not take effect as the Policy Percentage values do not exist when they are expected to exist. As this is not an expected condition, where a CA Customer database is connected to a DA Configuration database, the GUI does not display any warning, errors or exceptions.

 

To identify any affected Departments:

1. Connect to SQL Server Management Studio (SSMS) using an account with rights to run queries against the databases.

2. Execute the following query against the CA Customer database. The output can be to a spreadsheet for easier reading: Right-click in the results | Select All | Right-click in the results again | Copy With Headers | Paste into a new spreadsheet in Excel.

;WITH MissingPercentageReview AS (
SELECT CaseID FROM tblCase WHERE Type = 102 AND FolderType = 330 AND StatusID IN (20, 21)
EXCEPT SELECT DISTINCT CaseID FROM tblIntPolicyPercentageReview)
SELECT [Database] = db_name(), vcb.*
FROM View_Case_Base AS vcb
JOIN MissingPercentageReview AS mpr ON vcb.CaseID = mpr.CaseID
ORDER BY vcb.CaseID;

A workaround is to edit the Department's status using the second method, i.e., via the All Departments option as noted section above. This method does not use the Department's various property values.

A permanent fix is to programmatically re-add the missing Policy Percentage entries. Please contact Technical Support for assistance.

 

Enterprise Vault (EV) Compliance Accelerator (CA) / Veritas Advanced Supervision (VAS) uses Departments as logical containers to house Monitored Employees for supervision/surveillance functions, such as Random Sampling, Searches, Reviews and Exports. When Departments are created, their default status is Open. This means they are available to users who have access to perform the various functions via Role-Based Access (RBA). Other statuses include Closed and Deleted. Deleted removes all items found by Random Sampling and Searches, and users can no longer access the Department. Closed simply places the Department into a status where it cannot be accessed without administrative access. Random Sampling/Searches/Exports will not run, but the data within the Department remains intact, and will be accessible if re-opened. There are 2 ways to close a Department. Both require the user to be assigned to an Application Role with the Create Departments Permission. 1. Via the Properties:
1.1. Open the Department in question.
1.2. Navigate to the Properties tab.
1.3. In the Client, click the drop-down menu next to Status. If using VAS, click on Edit Department, then click the drop-down menu next to Status.
1.4. Select Closed.
1.5. Click Save to save the change. 2. Via the Departments tab in the Client, or the Departments widget in VAS:
2.1. Click the All Departments option.
2.2. Select the Tree View (default selection) option, then either the List View or Expand all options as needed (Client only).
2.3. In the Summary pane, click on the Department in the list to select it. If multiple Departments need to be closed, CTRL click on each additional required Department if using the Client or select the box next to each Department if using VAS.
2.4. Click Close Department. There may be instances where attempting to close a Department via its Properties tab does not take effect and the Status immediately returns to Open. Conversely, attempting to Open a Closed Department also does not take effect and the Status immediately returns to Closed. Other related symptoms include being unable to change the Department Owner.