Web Gen Error in 812 Multi Language

eSky

eSky

Well Known Member
Hi,

This is fresh 812 Installation.
Server: Windows
Database: Oracle 9.2.0.7
Release: 812 TR 8.96H1
Multi Language:- English, Simplified Chinese, Traditonal Chinese.
Websphere: 6.0.2.0

On starting Web Gen (before Connecting to Direct Genration) there is primary key violation on F989999 table.

SQLException occured in the SQLPhysicalConnection.insert(): | Vendor code = 1, SQL state = 23000 | Table or View Name = F989999 | Data Source = Central Objects - PY812 java.sql.SQLException: ORA-00001: unique constraint (PY812.F989999_PK) violated

This error it comes when i try to connect to Do Direct Generation. I have seen that when i try to connect for direct generation it inserts data in F989999 and F9899998 Tables. This looks to be a DataDictionary Items.


Right now:-
I have disabled the primary key on Table from Oracle and after this the generation was done but it was very slow.


Does anyone have a solution on this.
 
Hi Vivek,

the reason for slow record insertion could be that F989999/98 tables already have data in it.. and if yes then generation pri\ocess will not be simply insertion in tables.. it will be more of find and update which will def' take more time..

I think for this problem at entirely, you may try to recreate table (F989999) table and try generation.. let see how much it helps you..

catch you later..


eSky <[email protected]> wrote:
Hi,

This is fresh 812 Installation.
Server: Windows
Database: Oracle 9.2.0.7
Release: 812 TR 8.96H1
Multi Language:- English, Simplified Chinese, Traditonal Chinese.
Websphere: 6.0.2.0

On starting Web Gen (before Connecting to Direct Genration) there is primary key violation on F989999 table.

SQLException occured in the SQLPhysicalConnection.insert(): | Vendor code = 1, SQL state = 23000 | Table or View Name = F989999 | Data Source = Central Objects - PY812 java.sql.SQLException: ORA-00001: unique constraint (PY812.F989999_PK) violated

This error it comes when i try to connect to Do Direct Generation. I have seen that when i try to connect for direct generation it inserts data in F989999 and F9899998 Tables. This looks to be a DataDictionary Items.


Right now:-
I have disabled the primary key on Table from Oracle and after this the generation was done but it was very slow.
!

Does anyone have a solution on this. Thanks OneWorld Xe SP20 ,AS/400 V5R1 OneWorld XE SP22, Sun Solaris V440 WebSphere XE SP22, Sun Solaris V240 EnterpriseOne 8.10 8.94, AS/400 V5R2.
 
Disabling primary key is not the correct solution.
I have to do proper web gen with Primary key Enable at oracle.
 
If your trying for full generation, why can't you truncate the table F989999 and F989998 and try. In this way it will get new records.
 
Back
Top