View previous topic :: View next topic |
Author |
Message |
raptors
Joined: 26 Oct 2006 Posts: 7
|
Posted: Tue Jul 31, 2007 7:26 pm Post subject: How can we determine a Forms PlayBack Load Completion |
|
|
Dear members,
We are using Data Load Professional to load records in oracle forms. we are using the Forms Play Back Method to accomplish this.
When we start the play back session , how can we determine , when the load is completed. In Macro Loads we have a status bar which displays the time and status of the load . By this we can know when the load is completed, but how can we do the same thing in Forms Play Back.
Your Comments are Highly Appreciated.
Thanks
Sandeep |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
David
Joined: 15 Nov 2005 Posts: 97 Location: Near Heathrow Airport, London
|
Posted: Fri Sep 07, 2007 11:44 am Post subject: |
|
|
Sandeep,
In DataLoad Classic, the whole process runs on the PC, so it knows how big the file is and how far through it is and when it is finished.
In DataLoad Professional, the PC is only used as a display device to show the results of the process (the load through Oracle Forms) which is being run on the server. The PC cannot determine how far through the process the server is, nor when it has completed.
The most reliable way to be certain that the playback has finished is to create a record file during the playback, then check that the last record in the record file reflects the last record in the playback file.
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 |
|
![](templates/subSilver/images/spacer.gif) |
raptors
Joined: 26 Oct 2006 Posts: 7
|
Posted: Mon Oct 08, 2007 10:26 pm Post subject: Urgent!!!!!!! |
|
|
David,
I understand that we open the record.fld file to see what records loaded by seeing the last record in it during the playback.
In Macro load suppose we have 100 records to load it will take 30 minutes for the load to complete. we can see the load completion status on the PC Visually, But in Dataload Professional during playback how can we determine when to see the record.fld file.
Suppose i have some thousands of records and i am using the playback method to load. I start the playback. After how much time should i go to record.fld file to see what records loaded in the system.
Here Time is the main factor. There is no means to determine the time for load completion. Iam really confused guys here.
If the records are less it will load fast but if we have more records it will take some time to load.If i can know that "some time", i can always come back after that time to see the log file(record.fild).
Dataload must provide some means for this. Correct me if i am wrong.
Suppose i start the playback and suppose it takes 10 minutes for the load to complete. Since here i am unaware of time for the load to complete, suppose i go after 5 min and see the log file then it always will show the wrong data since i went earlier than 10 minutes.
Thanks
sandeep |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
David
Joined: 15 Nov 2005 Posts: 97 Location: Near Heathrow Airport, London
|
Posted: Tue Oct 09, 2007 12:23 pm Post subject: |
|
|
Sandeep,
Take a look at the enry by DataLoad in http://www.dataload.net/forum/viewtopic.php?t=69 This may give you the pointers you need. Please let us know.
HTH _________________ 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 |
|
![](templates/subSilver/images/spacer.gif) |
DataLoad Site Admin
Joined: 15 Nov 2005 Posts: 231 Location: Dorset, UK
|
Posted: Tue Oct 23, 2007 6:51 pm Post subject: |
|
|
Sandeep,
Further to what David said, in forms playback loads you can see the load running in Oracle so you know when the load is complete because you see that data is no longer being populated in the form and Oracle returns to "normal" for you to use. If you are not seeing the form updates then it could be that these are turned off - as per David's last message - so you either need to turn these on (which is the best approach) or monitor the audit file on the server or have another session of Oracle open and query back records there to check for all the data being loaded.
Thanks and regards,
Jonathan Stuart |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
ktodd
Joined: 14 Nov 2007 Posts: 9
|
Posted: Wed Dec 19, 2007 3:12 pm Post subject: |
|
|
If you are familiar with the tables being updated by your script and have access to a query tool (ex. TOAD), just write some sql and you can monitor the new records as they are being created. This seems to be easiest approach to me, rather than continuing to open a file to seeing how many records have been created. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|