Hi all,
As a part of my daily job i have to copy files from source directory and paste them in one single directory and process each file at a time and after processing the first file i have to move the processed first file to another directory and remove it from the directory where the file is processed so that it will avoid processing the same file when the loop is repeated. To accomplish all the above mentioned process i have done one job. All the settings are given correctly for each component, but when i run my job an exception is thrown "File Not Found".
But, Literally the file with the name is present in the specified location, i don't understand why i am getting this exception, can any correct me what is wrong in my job and what should be corrected to run my job with out any errors?
I had attached the images of my job and the error which i got while executing my job.
Kindly help me to resolve the problem.
Thanks and Regards,
Pavan
Hi I don't know what you do with tOracleBulkExec. According to your requirement, you can create a job as below. There is no need to use three tFileList. Regards, Pedro
Hi Pedro,
Thanks for the pain you had taken out for doing an example job, I use tOracleBulkexec to process the unarchived file after it is unarchived. The example which you had given is good enough if the source directory i.,e C:/Test had only one zip file, but i have some 14-15 files in the source directory. So let me explain you in a more clear way in step wise manner
1. First i need to take the first file for the first iteration and pass it to tFileUnarchive so that it will unarchive the zip file
2. Now after the tFileUnarchive un-archives the zip file in C:/Extraction directory, now the tOracleBulkExec will process one .tsv file which is unzipped by the tFileUnarchive component.
3. After the tOracleBulkExec process is over now i need to remove the First processed zip file and move it to C:/Imported directory(Which means that all the processed files will be placed in this directory)
4. And also i need to delete the extracted files which are extracted in C:/Extraction (this is because when second file is processed tOracleBulkExec must not process the same files of the First zip file)
The above mentioned process should be iterated in a loop for about 14-15 times.
But the example you had given will not work in a loop. How can this be accomplished to do in a loop for the entire process for each single file at a time?
Thanks and Regards,
Pavan
Hi Pavan
Sorry for my delay to answer.
According to your description at comment #14, I create a new job.
This time i'm sure it will work fine. I simply use tFileList to loop.
Now there are two tar.gz files(abc.tar.gz and abc2.tar.gz) under C:\Test directory in my local computer.
Loop1: tFileList gets the absolute file path of abc.tar.gz.
tFileUnarchive unzip abc.tar.gz.
Use onComponentOK to trigger tOracleExec.
After finishing tOracleExec, use onComponnetOk to trigger tFileCopy. Copy abc.tar.gz from C:\Test to C:\Imported and remove source file(abc.tar.gz) in C:\Test.
Use tFileList_2 to iterate files under C:\Extraction. Then tFileDelete will delete one.csv.
Loop2 : Start to get abc2.tar.gz.
Regards,
Pedro
Hi Pedro,
I had done the changes which you had mentioned, in fact i had done the job the same way before but the output links which i had given to the components were wrongly given. I had given "Iterate" out put links to all the components earlier in my job. After changing the output links to "OnComponent OK" it worked. So based on this i had few questions
1. What is the difference between Iterate and OnComponent OK?
2. Why does the job failed if i use Iterate in all the components?
Hi Pavan Sorry for my delay to answer. According to your description at comment #14, I create a new job. This time i'm sure it will work fine. I simply use tFileList to loop. Now there are two tar.gz files(abc.tar.gz and abc2.tar.gz) under C:\Test directory in my local computer. Loop1: tFileList gets the absolute file path of abc.tar.gz. tFileUnarchive unzip abc.tar.gz. Use onComponentOK to trigger tOracleExec. After finishing tOracleExec, use onComponnetOk to trigger tFileCopy. Copy abc.tar.gz from C:\Test to C:\Imported and remove source file(abc.tar.gz) in C:\Test. Use tFileList_2 to iterate files under C:\Extraction. Then tFileDelete will delete one.csv. Loop2 : Start to get abc2.tar.gz. Regards, Pedro
1. What is the difference between Iterate and OnComponent OK? 2. Why does the job failed if i use Iterate in all the components?
I will explain it in a simple way. The difference between Iterate and OnComponentOK is that OnComponentOK(OnSubjobOk) will declare a new method in Job code for one component while using Iterate it will in the same method with previous component. When using Iterate, it may cause the wrong execution order of these components. Or sometimes some important values are not ready. When using OnComponentOK, the method where the first component exists will call this new method. Make sure the right order and prepare all global values... Regards, Pedro
