File pattern was specified this indicates the pattern

[SURA]

Hello All

I had a situation to use file pattern to pull all the .csv files using Sequential file stage.

Read Method = File Pattern
File = #FILE_NAME#

Code: Select all

variable 

FILE_NAME = F:\ETL\TMP_LND\*.csv

Job is running good, but not picking all the files (in random).

I am getting the below warning in the Director:

SourceFiles:Fileset /E=/Temp/import_tmp_198567dba73b1.fs contails no files. If a file pattern was specified this indicates the pattern returned no files.

I raised a PMR with IBM and confirmed , they can reproduce the same issue in their environment.

I will update once i get the solution.

I trust this will help, if any of you facing the same issue!

DS User

[eph]

Hi,

I face the same issue using the 8.1. As the note in this APAR, you should install fix pack 1 for v8.5, or the JR37268 patch (if available for 8.5). It might then correct the bug

Regards,
Eric

[Teej]

Greetings --

Please do not rely on that patch for the file pattern issue. It address a different issue.

We are currently investigating this.

-T.J.

[pavankvk]

Hi Teez,

we are facing the exact same issue on windows environment. Using 11.3 version..I cant believe its still a bug in the latest. Do you have a solution/work around?

[chulett]

They haven't posted here in almost four years. Perhaps you should contact support.

[SURA]

I am the one initiated this thread. Let me check my emails and get back to you.

[SURA]

I am not able to find a solution provided by IBM. IBM wasn't able to reproduce the issue from their side.

I think, i have changed the logic and i am not using file pattern anymore.

The problem i had with IBM was, they are not simulating the same env there! For example mine is in Windows OS whereas i found good number of times, IBM tried to find the issue using Unix OS.

What i can offer you is Good Luck.

Notes: Try to bring the file name as one of the column will help you to track which file is missing.

[naveenkumar.ssn]

hi

I tried with the unix environment, I could not find this issue.

However not sure with the windows environment.

probably my turn around would be concatenate all the files into a single file using before job sub routine.

Many Thanks

Regards
Naveen