Page 1 of 1

Using file pattern option in the sequential file

Posted: Tue Aug 28, 2007 6:42 am
by sarat.srinivas@tcs.com
Hi All,
I have two text files which have the job log of two respective jobs say Job1,Job2, in a placed in a folder. I am using another job for reading these log files everytime after the jobs are exceuted. I am trying to use the file pattern option in the sequential file, and tried giving the path of the files where they are placed like C:\folder\*.txt.
If am doing view data it is giving me the error:
##I TFCN 000001 17:59:19(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TOSH 000002 17:59:19(001) <main_program> orchgeneral: loaded
##I TOSH 000002 17:59:19(002) <main_program> orchsort: loaded
##I TOSH 000002 17:59:19(003) <main_program> orchstats: loaded
##W TCOS 000049 17:59:19(004) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 17:59:19(005) <main_program> createFilesetFromPattern(): Couldn't find any files on host with pattern "*.txt".
>##E TOIX 000138 17:59:20(001) <Sequential_File_0> At least one filename or data source must be set in APT_FileImportOperator before use.
>##E TFSR 000019 17:59:20(005) <main_program> Could not check all operators because of previous error(s)
>##E TCOS 000029 17:59:20(006) <main_program> Creation of step finished with status = FAILED


Can I pls know what is setting filename in APT_FileImportOperator ?
Pls help me how to proceed in this regard.
Thanks!

Re: Using file pattern option in the sequential file

Posted: Tue Aug 28, 2007 8:36 am
by sud
Couldn't find any files on host with pattern "*.txt".
Check if there are any files with .txt extension available or not, that seems to be the problem. And, hope you are not specifying a path on your client machine, the URL has to be for a server directory.

Re: Using file pattern option in the sequential file

Posted: Tue Aug 28, 2007 11:07 pm
by sarat.srinivas@tcs.com
[/quote]

Check if there are any files with .txt extension available or not, that seems to be the problem. And, hope you are not specifying a path on your client machine, the URL has to be for a server directory.[/quote]


Hi Sud,
Thanks for the reply!
There are .txt files in the path specified and the system I am presently working this job is the server system itself,and I gave the path of the same windows machine.

Posted: Wed Aug 29, 2007 7:30 am
by harshada
>##E TOIX 000138 17:59:20(001) <Sequential_File_0> At least one filename or data source must be set in APT_FileImportOperator before use.
from this error what i gather is that you should atleast provide part of the file name
example : C:\folder\partfile*.txt