I am getting this error all of a sudden:
"Error persisting business object Customer Duplicate entry '4853' for key 1"
Does anyone have an idea why this would occur and how to resolve it
Thank You
Error persisting business object
Hi
I am a bit confused as to how a primary key can be duplicated. Is the Aware system generating the ID key or is it a database function ?
When I look at the table, I don't see any duplications in the Primary Key, but I suspect, when adding a new Customer, the primary key the system tries to create already exists. Hows that possible
Also, something strange with the primary key numbering , The most recent IDs are in the 7850 range, then all of a sudden it drops down to 3 digit ID numbers , could that be an indicator that something funny is happening ?
This is new territory for me ! maybe support could comment on this
I am using MYSQL 5.0 and the state of the DB is fine, and no error logs
I am a bit confused as to how a primary key can be duplicated. Is the Aware system generating the ID key or is it a database function ?
When I look at the table, I don't see any duplications in the Primary Key, but I suspect, when adding a new Customer, the primary key the system tries to create already exists. Hows that possible
Also, something strange with the primary key numbering , The most recent IDs are in the 7850 range, then all of a sudden it drops down to 3 digit ID numbers , could that be an indicator that something funny is happening ?
This is new territory for me ! maybe support could comment on this
I am using MYSQL 5.0 and the state of the DB is fine, and no error logs
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
What you are saying is correct - there is no way Aware IM would create a duplicate primary key (unless, of course, there is some bug, but I have never heard of this particular problem before).
Maybe it is related to indexing rather than primary keys - are you using indexes anywhere in your application?
Maybe it is related to indexing rather than primary keys - are you using indexes anywhere in your application?
Aware IM Support Team
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
This error is generated by the database, not by Aware IM, so it is possible that the problem has nothing to do with Aware IM. If you Google on "Duplicate entry '4853' for key 1" you will find quite a few posts about this problem - some of them suggest database corruption. Please have a look there - you may find your solution.
Aware IM Support Team