If she logs into a different machine is she able to review?  What OS is her computer?  Any differences between her and others that work?

We didn't try a new machine yet.

OS is Windows 7

Everything is basically setup the same across all employees. Does CA use java ? Will reinstalling java help ?

We have v 4.0

I now have 2 employees with the same issue...

One thing to note is we recently created a new cust db, on the old cust db they are still able to review emails.

The issue is only on the new cust db. Sampling only ocucrs on the new DB.

Its fixed now. I restarted the EVAMS service.. just hope this doesn't occur daily...

Just noticed this error in the event viewer as well.

APP AS - Customer ID: 3 - An Error has occured when updating a marking item. System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblComment_tblPrincipal". The conflict occurred in database "XXXX table "dbo.tblPrincipal", column 'PrincipalID'.

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblIntMarkHistory_tblPrincipal". The conflict occurred in database "EVCA_COMPLIANCE_US02", table "dbo.tblPrincipal", column 'PrincipalID'.

ERROR_usp_DiscoveredItem_Upd_AddMark|17695

The statement has been terminated.

The 'usp_Comment_Add' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

The statement has been terminated.

at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)

at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)

at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)

at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)

at KVS.Accelerator.Common.TraceDLCommand.Update(IDbDataAdapter adapter, DataSet ds, Boolean RetryDLs)

at KVS.Accelerator.Items.DiscoveryItems.UpdateDS(DiscoveryItemDS DS)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Is that error before or after you restarted the service?

This is before.. it occured a couple times. (looks like the times when the users tried to mark the messages)

Ok, so it seems like the restart cured the issue.  I would just monitor it for a day or two to see if it recurs. You could set up an alert for that event id so it will let you know if it does happen again.

Even i had noticed this issue and same is my case if i restart evams it will get fix but after couple of days it will recoccur also noticed that i get out of memory error on the CA server at the same time not sure if that is related.