PRIMARY KEY constraint 'F9312_PK' error

PRIMARY KEY constraint \'F9312_PK\' error

Hi list,

we have some trouble with the sec. history table. In the ent. server log I have following error message:

"[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'F9312_PK'. Cannot insert duplicate key in object 'F9312'. - SQLSTATE: 23000"

I tried to rebuild indexes and also generated this table again but still receiving this error message. Unfortunately I can't turn on the debug log on the PD box.

Does anyone saw this one before? Would appreciate any ideas/feedback.

cheers,

Adrian

E1 8.0 (SP22_K1) Intel, Citrix, JAS, SQL2000

RE: PRIMARY KEY constraint \'F9312_PK\' error

We do have the same problem.. Let us know if there is any Fix for this.

OneWorld XE update 4 SP23J1 Oracle 9i HP 90000


Regards

Prabhakar

Re: PRIMARY KEY constraint \'F9312_PK\' error

I actually opened a call about this some time back. Oracle's response was that they are bogus error messages and that they can be ignored.

Nice solution, huh?

Re: PRIMARY KEY constraint \'F9312_PK\' error

They may have also added "By design".

The PK is just not selective enough, so half inserts never make it. You can potentially do a mod: make the PK wider. You will have more data in the table too, as a result...

Re: RE: PRIMARY KEY constraint \'F9312_PK\' error

Gyus, I received an answer from JDE support. Yes this is an known issue. Two possible solutions, 1. turn off sec. history in the jde.ini or 2. wait until the SP24 is out it should include a fix for this issue.

THX for your quick response!

cheers,

Adrian