Team Elements

Main Content

Contact duplicated at insert

Back to Topics

You need to be logged in to post messages.

Contact duplicated at insert

7/14/2008 12:00 PM

By Ricardo V.

hi,

I have discovered that after insert some contacts (about 900) the system starts to duplicate the contacts. when I insert a contact with and id of 900 the system create another contact with the same data and with an id between 100 and 400. The big problem isn't the duplicate data, the problem is that the contacts with ids between 100 and 400 has been erased.
I have installed centric 5.0.5 with apache 6, but I discovered the same problem in the 5.0.3 version.

Have any of you the same problem?

Best Regards,
Ricardo

RE: Contact duplicated at insert

1. 7/14/2008 12:54 PM

By Michael H.

Ricardo Vidal wrote:
hi,

I have discovered that after insert some contacts (about 900) the system starts to duplicate the contacts. when I insert a contact with and id of 900 the system create another contact with the same data and with an id between 100 and 400. The big problem isn't the duplicate data, the problem is that the contacts with ids between 100 and 400 has been erased.
I have installed centric 5.0.5 with apache 6, but I discovered the same problem in the 5.0.3 version.

Have any of you the same problem?

Best Regards,
Ricardo
-----

More of a hint than an answer as im still ramping up on the project. It sounds like you are dealing with an issue of the current sequence in the database. What database are you using?

RE: Contact duplicated at insert

2. 7/18/2008 1:06 PM

By Ricardo V.

Michael Hoffman wrote:
More of a hint than an answer as im still ramping up on the project. It sounds like you are dealing with an issue of the current sequence in the database. What database are you using?
-----
I had installed Centric 5.0.4 with MSSQL 2000 as database.
Also I installed centric 5.0.4 and 5.0.5 with MSSQL server 2005 as database. And the issue appears in each installation.
Ill try mysql as database.

Regards,
Ricardo

2 results found

How to use the Discussion

Select the forum topic or create a new one for your own business or group.
Reply to a question or comment someone has posted.
Press Save.

Who can respond to discussions?

Anyone can respond to a forum topic.
A manager can make a new forum.
Everyone can read the discussion.

Why use the Discussion?

The Discussion area is a great place for networking, getting advice, sharing an opinion or answering questions. The site is populated with topics, called forums, that help visitors ask questions or make comments in an organized manner. Anyone can ask questions or share insights and views about your business or organization. Not only can you answer questions, but this area allows others to answer or comment. This area is the place where people are actively engaged with each other.