Error Message

The following events are seen in the Event Viewer:

Log Name: Veritas Enterprise Vault
Source: Accelerator Service Processor
Event ID: 105
Task Category: None
Level: Error
Keywords: Classic
Description:
APP AS - Customer ID: 4 - an error occured retrieving cases for a user. System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values.
at System.Data.ConstraintCollection.AddForeignKeyConstraint(ForeignKeyConstraint constraint)
at System.Data.ConstraintCollection.Add(Constraint constraint, Boolean addUniqueWhenAddingForeign)
at System.Data.DataRelationCollection.DataSetRelationCollection.AddCore(DataRelation relation)
at System.Data.DataRelationCollection.Add(DataRelation relation)
at System.Data.DataRelationCollection.Add(String name, DataColumn parentColumn, DataColumn childColumn)
at KVS.Accelerator.Case.Cases.GetCaseTreeForUser(Int32 principalID, String permissionsNeeded, Boolean administrator, CaseType aCaseType, CaseStatus aCaseStatus, Boolean getSecurityForPrincipal, String getSecurityRolesForOtherPrincipals, Int32 AttributeID1, Int32 AttributeID2, Int32 AttributeID3)

V-437-105

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Service Processor
Event ID:      311
Task Category: None
Level:         Error
Keywords:      Classic
Description:
APP AS - Customer ID: 4 - An error has occured when initializing a Search. System.Data.SqlClient.SqlException (0x80131904): CaseID,SearchID,CaseIDs and TenantID should not be null at same time.At least one of the parameter should be supplied as input
  at Symantec.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
  at Symantec.EnterpriseVault.DatabaseAccess.EVSqlDataAdapter.Fill(DataTable dataTable)
  at KVS.Accelerator.Search.Search.GetGenericSearchesDataSet(DataSet DS, EVSqlDataAdapter aSqlDataAdapter, String TableName, Int32 SearchID, Int32 CaseID, String CaseIDs, Boolean ScheduleRun, Int64 RowVersion, Boolean IncludeDeleted)
ClientConnectionId:7e321a3a-5be5-41c6-8675-4c04b1b8f8a1
Error Number:51000,State:1,Class:16 - An error has occured when initializing the table: Detail

V-437-311

The following entries are seen in Dtrace of the AcceleratorService process:

EV-H    {-} Exception: Error Case_Cases_RetrievingCases Info:{AcceleratorEvent} {C4} an error occured retrieving cases for a user. System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values.|   at System.Data.ConstraintCollection.AddForeignKeyConstraint(ForeignKeyConstraint constraint)|   at System.Data.ConstraintCollection.Add(Constraint constraint, Boolean addUniqueWhenAddingForeign)|   at System.Data.DataRelationCollection.DataSetRelationCollection.AddCore(DataRelation relation)|   at System.Data.DataRelationCollection.Add(DataRelation relation)|   at System.Data.DataRelationCollection.Add(String name, DataColumn parentColumn, DataColumn childColumn)|   at KVS.Accelerator.Case.Cases.GetCaseTreeForUser(Int32 principalID, String permissionsNeeded, Boolean administrator, CaseType aCaseType, CaseStatus aCaseStatus, Boolean getSecurityForPrincipal, String getSecurityRolesForOtherPrincipals, Int32 AttributeID1, Int32 AttributeID2, Int32 AttributeID3) Diag: Type:System.Exception ST: Inner:None

If the CA Customer database predates version 8.0, it is possible the table tblCase may contain an Open or Closed Department with CaseID 4 where this CaseID has a NULL TenantID. In this scenario, CA is unable to populate the Department hierarchy and Department properties, thus resulting in the errors.

A possible workaround would be to use the List View instead of the (default) Tree View. To do this:

- Go to the Departments Tab.
- The first button from the left under the Departments header will be highlighted. This is the Tree View button.
- Click on the List View button under Departments. This should be the second button from the left under the Departments header, next to the Tree View button.
- The Departments should now be listed.

Note - There may still be some unexpected behaviour noticed when attempting to run Application Searches or attempting to assign Roles in Parent/Child Departments.

There are no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software at the present time. However, the issue is currently scheduled to be addressed in the next major revision of the product. Please note that Veritas Technologies LLC reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests. Veritas' plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.