Stavors
Active Member
Apologies to KLONG - I posted this as a reply to him rather than a new post.
I too am trying to rebuild the cross reference relationships and followed the advice given in this thread. The process seems to be working okay but is taken hours and hours to run for any one version. Is this normal or have we some issue we need to address?
I notice that in the JDE.LOG we keep getting entries like the following and there are many thousands of these......
1508/1840 Thu Jun 06 06:09:09 2002 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO DV7333.F980021 (SJOBNM, SJFMT, SJDTAN, SJOBJP, SJATRP, SJDL01, SJKYSQ, SJFCTNM, SJAPPLID) VALUES
BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9)
1508/1840 Thu Jun 06 06:09:09 2002 DBPERFRQ.C384
OCI0000179 - Error - ORA-00001: unique constraint (DV7333.F980021_PK) violated
1508/1840 Thu Jun 06 06:09:09 2002 jdb_drvm.c917
JDB9900401 - Failed to execute db request
1508/1840 Thu Jun 06 06:09:09 2002 jdb_exet.c4474
JDB3400009 - Failed to perform Insert for F980021
We also get entries such as ...
1508/1840 Thu Jun 06 06:06:53 2002 B9800030.c2417
****CROSS-REF DETECTS ER MISMATCH****
1508/1840 Thu Jun 06 06:06:53 2002 B9800030.c2421
The Data Structure, T15403, only has 18 members while the app/form, R15403/S25, calls member # 30.
Should we be concerned??
Any help please?
I too am trying to rebuild the cross reference relationships and followed the advice given in this thread. The process seems to be working okay but is taken hours and hours to run for any one version. Is this normal or have we some issue we need to address?
I notice that in the JDE.LOG we keep getting entries like the following and there are many thousands of these......
1508/1840 Thu Jun 06 06:09:09 2002 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO DV7333.F980021 (SJOBNM, SJFMT, SJDTAN, SJOBJP, SJATRP, SJDL01, SJKYSQ, SJFCTNM, SJAPPLID) VALUES
BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9) 1508/1840 Thu Jun 06 06:09:09 2002 DBPERFRQ.C384
OCI0000179 - Error - ORA-00001: unique constraint (DV7333.F980021_PK) violated
1508/1840 Thu Jun 06 06:09:09 2002 jdb_drvm.c917
JDB9900401 - Failed to execute db request
1508/1840 Thu Jun 06 06:09:09 2002 jdb_exet.c4474
JDB3400009 - Failed to perform Insert for F980021
We also get entries such as ...
1508/1840 Thu Jun 06 06:06:53 2002 B9800030.c2417
****CROSS-REF DETECTS ER MISMATCH****
1508/1840 Thu Jun 06 06:06:53 2002 B9800030.c2421
The Data Structure, T15403, only has 18 members while the app/form, R15403/S25, calls member # 30.
Should we be concerned??
Any help please?