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 

How to continue to next record once an ERROR occurs.

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



Joined: 19 Dec 2006
Posts: 12
Location: New York, NY

PostPosted: Mon Feb 05, 2007 11:47 am    Post subject: How to continue to next record once an ERROR occurs. Reply with quote

Hi,

While testing an Oracle load, there was a case where a particular record could not be loaded because it was already in the system. It stopped and gave me the pop-up message and wanted me to click OK. So I clicked ESCape first to unfreeze the screen and then clicked OK.

How do I get the load to continue on from the next record, or do I have to make a note of where it stopped and then edit the playback file, and continue/restart from there?

Thanks,
Joe
Back to top
View user's profile Send private message Send e-mail
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Mon Feb 05, 2007 9:33 pm    Post subject: Reply with quote

Joe,

You cannot continue after an error. You have to edit the playback file, and continue/restart from next record.

Cool HTH

David
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
rappaj



Joined: 19 Dec 2006
Posts: 12
Location: New York, NY

PostPosted: Tue Feb 06, 2007 2:32 pm    Post subject: continuing on error Reply with quote

David,

Thanks for the reply back.

Joe
Back to top
View user's profile Send private message Send e-mail
DataLoad
Site Admin


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

PostPosted: Tue Feb 06, 2007 6:20 pm    Post subject: Reply with quote

Furthermore, this is not possible with Forms Playback. It is a limtation of Oracle's forms playback scripting that we cannot have procedural processing of issues, etc. In an ideal world we would be able to do this but at least the forms playback loads stop on error rather than continuing to load data as is the case with Macro laods.

Regards,

Jonathan Stuart
Back to top
View user's profile Send private message Send e-mail Visit poster's website
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