R98403 - Oracle Lost Connectivity

[digitalfallout]

Hello,
I am running jde migration from sql server 2000 to Oracle RAC 10g using the R98403 ube. I ran the ube but I keep losing connectivity with Oracle database. Has anyone else faced this issue. Here are the errors in the logs

940/3752 MAIN_THREAD Fri Jan 23 17:18:46.244000 Jdb_ctl.c3944
Starting OneWorld

940/3752 MAIN_THREAD Fri Jan 23 17:18:50.557000 Env.cpp142
Solution Explorer Started

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.846000 dbperfrq.c456
OCI0000178 - Unable to execute - INSERT INTO PPDTA.F00165 (GDOBNM, GDTXKY, GDMOSEQN, GDGTMOTYPE, GDLNGP, GDUSER, GDUPMJ, GDTDAY, GDGTITNM, GDQUNAM, GDGTFILENM, GDGTFUTS1, GDGTFUTS2, GDGTFUTS3, GDGTFUTS4, GDGTFUTM1, GDGTFUTM2, GDTXFT) VALUES BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18)

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.893000 dbperfrq.c462
OCI0000179 - Error - ORA-03135: connection lost contact

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.893001 Jdb_drvm.c1116
JDB9900401 - Failed to execute db request

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.893002 Jtp_cm.c1336
JDB9900255 - Database connection to F00165 (Business Data - PPORCL) has been lost.

940/1368 WRK:Starting jdeCallObject Fri Jan 23 23:24:07.493000 Jdb_exet.c6144
JDB3400009 - Failed to perform Insert for F00165

940/1368 WRK:Starting jdeCallObject Fri Jan 23 23:24:07.493001 Gt_F00165.c1372
JDEGTCopyF00165FromDataSource: Insert Fail on Object, Keys, Sequence


Any help is highly appreciated

 

[More Cowbell]

Are the databases separated by Ethernet segments?



Check the LAN speed between servers hosting the DBs by opening a command
window on the server running the UBE and executing this while the UBE is
launched:



ping [DB server name] =96t



Response time should be <1ms for a LAN



Good luck!

_____

From: [email protected] [mailto:[email protected]] On
Behalf Of c00lcnc
Sent: Saturday, January 24, 2009 11:00 PM
To: [email protected]
Subject: R98403 - Oracle Lost Connectivity



Hello,
I am running jde migration from sql server 2000 to Oracle RAC 10g using the
R98403 ube. I ran the ube but I keep losing connectivity with Oracle
database. Has anyone else faced this issue. Here are the errors in the logs

940/3752 MAIN_THREAD Fri Jan 23 17:18:46.244000 Jdb_ctl.c3944
Starting OneWorld

940/3752 MAIN_THREAD Fri Jan 23 17:18:50.557000 Env.cpp142
Solution Explorer Started

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.846000 dbperfrq.c456
OCI0000178 - Unable to execute - INSERT INTO PPDTA.F00165 (GDOBNM, GDTXKY,
GDMOSEQN, GDGTMOTYPE, GDLNGP, GDUSER, GDUPMJ, GDTDAY, GDGTITNM, GDQUNAM,
GDGTFILENM, GDGTFUTS1, GDGTFUTS2, GDGTFUTS3, GDGTFUTS4, GDGTFUTM1,
GDGTFUTM2, GDTXFT) VALUES
BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND 12,
:BND13,:BND14,:BND15,:BND16,:BND17,:BND18)

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.893000 dbperfrq.c462
OCI0000179 - Error - ORA-03135: connection lost contact

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.893001
Jdb_drvm.c1116
JDB9900401 - Failed to execute db request

940/1368 WRK:Starting jdeCallObject Fri Jan 23 20:47:54.893002 Jtp_cm.c1336
JDB9900255 - Database connection to F00165 (Business Data - PPORCL) has been
lost.

940/1368 WRK:Starting jdeCallObject Fri Jan 23 23:24:07.493000
Jdb_exet.c6144
JDB3400009 - Failed to perform Insert for F00165

940/1368 WRK:Starting jdeCallObject Fri Jan 23 23:24:07.493001
Gt_F00165.c1372
JDEGTCopyF00165FromDataSource: Insert Fail on Object, Keys, Sequence


Any help is highly appreciated

CNC/DBA 8.10 with 8.96_I1, Windows and Sql 2000 platform

_____


The entire
<http://www.jdelist.com/ubb/showflat.php?Cat=3D&Board=3DOW&Number=3D14215 JDELIST thread is available for viewing.


Looking for a job? Check out the Job
Opportunites
forum


This is the JDELIST EnterpriseOne Mailing List.
JDELIST is not affiliated with JDEdwards=AE.

To unsubscribe from this list via email, Click
<mailto: [email protected]?Subject=3DUnsubscribe&Body=3DSirs,% 0A
Pl
ease remove this address from the JDELIST EnterpriseOne% 20M

 

[altquark]

[ QUOTE ]

940/1368 WRK:Starting jdeCallObject Fri Jan 23 23:24:07.493001 Gt_F00165.c1372
JDEGTCopyF00165FromDataSource: Insert Fail on Object, Keys, Sequence


[/ QUOTE ]

It looks as if your primary key is giving an issue with the F00165 - media objects.

Check to see if you have any duplicate rows. Is this the only table that is causing an issue - perhaps you need to copy this table separately.

Otherwise, if this issue is occurring on all tables, then as the previous poster stated it is likely you have a network connectivity issue.