Skip Navigation and Search to Content

Search Team Elements - Discussion - Concursive Corporation

Main Content

  • Status: Caution
  • PostgreSQL
  • Open Source Initiative (OSI)
  • Java

Team Elements

Back to Topics

  1. Issues and Open Discussion

You need to be logged in to post messages.

Contact duplicated at insert

7/14/2008 12:00 PM

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

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

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