Well, you simply need to remove the offending record in the server_hit table. You could probably just empty the table "delete from server_hit" if you don't care about it's contents.
However, it's odd that you would get this error to begin with. I'm wondering if it has to do with past problems with mysql not resolving down to the millisecond level (like postgresql). Maybe someone else can chime in. ------Original Message------ From: Sachin To: user@ofbiz.apache.org ReplyTo: user@ofbiz.apache.org Subject: SQL Exception while executing the following:INSERT INTO SERVER_HIT Sent: Jun 14, 2012 3:40 AM Getting this error: SQL Exception while executing the following:INSERT INTO SERVER_HIT Exception: org.ofbiz.entity.GenericDataSourceException com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '44200-root.main-2012-06-14 16:06:28-REQUEST' for key 1 -- View this message in context: http://ofbiz.135035.n4.nabble.com/SQL-Exception-while-executing-the-following-INSERT-INTO-SERVER-HIT-tp4633545.html Sent from the OFBiz - User mailing list archive at Nabble.com. Sent via BlackBerry by AT&T
