04-16-2014 09:34 AM
I have an issue with 1 client who Review buttons are not working. They did in the past.
She currently has 68 messages to review but when she clicks on Review, Pending... nothign happens. She has the same role as other employees who currently dont have issues. I also made myself a delgate and I was able to reivew the emails.
We tried to reinstall CA client and reboot the PC. What else can we do ?
Solved! Go to Solution.
04-16-2014 11:32 AM
I don't see java here:
Article:HOWTO58721 | | | Created: 2011-08-01 | | | Updated: 2013-07-12 | | | Article URL http://www.symantec.com/docs/HOWTO58721 |
What version of .Net do you have?
04-16-2014 10:08 AM
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?
04-16-2014 11:24 AM
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 ?
04-16-2014 11:32 AM
I don't see java here:
Article:HOWTO58721 | | | Created: 2011-08-01 | | | Updated: 2013-07-12 | | | Article URL http://www.symantec.com/docs/HOWTO58721 |
What version of .Net do you have?
04-16-2014 11:40 AM
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.
04-16-2014 11:45 AM
Its fixed now. I restarted the EVAMS service.. just hope this doesn't occur daily...
04-16-2014 11:47 AM
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.
04-16-2014 11:51 AM
Is that error before or after you restarted the service?
04-16-2014 01:25 PM
This is before.. it occured a couple times. (looks like the times when the users tried to mark the messages)
04-16-2014 01:35 PM
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.
04-22-2014 03:12 AM
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.
04-22-2014 04:48 AM
Greetings, Vione and Cdee;
Please veriff if you have .NET 4.0 on your CA server. If you do, remove it immediately. .NET 4.0 is not supported in any version of CA (or DA) and has been found to cause random issues with the product's performance.
Also check for .NET 4.5 and remove it if found as it is also not supported (yet).
Finally, check your CA servers' automatice update setting to ensure it is set to automatically download Microsoft updates but allow you to select when to install them. Having your CA servers set to automatically download and install Microsoft updates has been known to cause problems as .NET 4.0 and 4.5 are part of those updates. We recommend NOT allowing the automatic installation of updates. The automatic download is fine, just not the automatic installation of the updates.
04-23-2014 01:06 AM
Hi Rob,
Thanks for the feedback just cross verified and noticed that .net 2.0 SP2 .net 3.02 Sp2 and 3.5 sp is installed on the server.
04-28-2014 08:04 AM
.Net 3.5 SP1 or a greater SP to 3.5 is OK as long as 4.0 or greater (including 4.5) is NOT installed. If you've got any flavor of .NET 4.x installed on the Accelerator server, please remove it as these versions are known to cause issues.
We're working to get .NET 4.5 certified, but no ETA on that as yet.
04-30-2014 02:55 AM
Thanks for the update Ken.
07-09-2014 07:30 AM
I just wanted to update the fix we use for this issue.
Clearing the client cache has been resolving the issue and the issue does not return for the same user
It seems to be related to the new cust db. One is on SQL 2003 and the new one is on SQL 2008. Not sure if this was the issue.
To clear the client cache - Holdthe ctrl key - then click on the Symantec logo in the bottom right corner.