DataLoad Community Forum Index DataLoad Community

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Apps Server Connection lost with Dataload Forms

 
Post new topic   Reply to topic    DataLoad Community Forum Index -> Forms Playback Support (.fld files)
View previous topic :: View next topic  
Author Message
SimonBroadhurst



Joined: 19 Oct 2006
Posts: 3

PostPosted: Fri Dec 15, 2006 9:24 am    Post subject: Apps Server Connection lost with Dataload Forms Reply with quote

Hi,

I've recently started to try and load high volume .fld files (20k plus records) to load gl code combinations. The load process often terminates with an Oracle Server connection lost error or exisitng code combination error even when the source file does not have duplicates. Anyone had something similar? Have been loading 5k to 8k records without issue up till now. Still using the original playback file. Is this a timing, buffer or similar issue?

Any help greatly appreciated
Back to top
View user's profile Send private message
DataLoad
Site Admin


Joined: 15 Nov 2005
Posts: 231
Location: Dorset, UK

PostPosted: Mon Jan 15, 2007 9:47 am    Post subject: Reply with quote

Simon,

We have seen similar issues to this. Although Forms Playback loads are very fast and reliable, etc, we need to remember that we are still loading the data through Oracle Forms. I doubt Oracle have tested Forms with 20K plus records and although loads of this size often work we should not expect Forms to scale as reliably as, say, the database.

There are things that can be done to debug this issue but if you can successfully load, say, in excess of 10K records we suggest that you just keep your load volumes down to a size that is reliable. With the correct setup you can run multiple loads in parallel so if you need to load, say, hundreds of thousands of records then you could run multiple 10k records loads in parallel or at least start your next load before the preceding load is complete.

Regards,

Jonathan Stuart,
DataLoad Support.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
jhebert



Joined: 08 Jan 2007
Posts: 1
Location: USA

PostPosted: Thu Mar 08, 2007 12:15 am    Post subject: Reply with quote

Hmm,

Subject line sounds like what we're encountering but much different circumstance. We make limited use of dataload - only one user running batches of about 100 records at a crack. She reported problems problems with Disconnects - sure enough I watched over her shoulder. It took 5 tries to load 100 records. 4 of the 5 were Disconnects and one was a data problem.

This happened a few months ago we modified settings/setup per information on metalink and it seemed fine but its come back. Is anyone else running into this. Any suggestions on troubleshooting these disconnects?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DataLoad Community Forum Index -> Forms Playback Support (.fld files) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group