Question regarding this syntax for reading zip file contents with Flat File Reader component:
zip:(/path/file.zip)#innerfolder/filename.txt - Reads a specified file compressed in the file.zip file.
I am trying to read a specified file contained in a zip file. The syntax below works correctly.
zip:(${DATAIN_DIR}/CMTestFile.zip)#dim_ident.dat
My question is: if for some reason, on a particular day the specified file was not contained in the zip file sent by the client, why does the zip syntax above not indicate a missing source file as it would in the case of a non-zip file?
zip:(${DATAIN_DIR}/CMTestFile.zip)#dim_ident.dat
if dim_ident.dat is missing from the directory the graph runs successfully:
---------------------------------------------------------------------------------
14:59:06,211 INFO [WatchDog_14] Read CR Identity READ_CR_IDENTITY FINISHED_OK
14:59:06,211 INFO [WatchDog_14] %cpu:0 Out:0 0 0 0 0
14:59:06,211 INFO [WatchDog_14] Out:1 0 0 0 0
14:59:06,211 INFO [WatchDog_14] ---------------------------------** End of Log **--------------------------------
14:59:06,211 INFO [WatchDog_14] Execution of phase [0] successfully finished - elapsed time(sec): 0
${DATAIN_DIR}/dim_ident.dat
(if this file is missing from the directory the error is:
Component [Read CR Identity:READ_CR_IDENTITY] finished with status ERROR. (Out0: 0 recs, Out1: 0 recs)
Component pre-execute initialization failed.
File is unreachable: sandbox://client_etl/data-in/dim_ident.dat
File client_etl:data-in/dim_ident.dat does not exist
In the event that the specified file within the zip is not present, I would like to raise an error. Is there a way to do this using the above zip syntax?
Thanks,
Heather
zip:(/path/file.zip)#innerfolder/filename.txt - Reads a specified file compressed in the file.zip file.
I am trying to read a specified file contained in a zip file. The syntax below works correctly.
zip:(${DATAIN_DIR}/CMTestFile.zip)#dim_ident.dat
My question is: if for some reason, on a particular day the specified file was not contained in the zip file sent by the client, why does the zip syntax above not indicate a missing source file as it would in the case of a non-zip file?
zip:(${DATAIN_DIR}/CMTestFile.zip)#dim_ident.dat
if dim_ident.dat is missing from the directory the graph runs successfully:
---------------------------------------------------------------------------------
14:59:06,211 INFO [WatchDog_14] Read CR Identity READ_CR_IDENTITY FINISHED_OK
14:59:06,211 INFO [WatchDog_14] %cpu:0 Out:0 0 0 0 0
14:59:06,211 INFO [WatchDog_14] Out:1 0 0 0 0
14:59:06,211 INFO [WatchDog_14] ---------------------------------** End of Log **--------------------------------
14:59:06,211 INFO [WatchDog_14] Execution of phase [0] successfully finished - elapsed time(sec): 0
${DATAIN_DIR}/dim_ident.dat
(if this file is missing from the directory the error is:
Component [Read CR Identity:READ_CR_IDENTITY] finished with status ERROR. (Out0: 0 recs, Out1: 0 recs)
Component pre-execute initialization failed.
File is unreachable: sandbox://client_etl/data-in/dim_ident.dat
File client_etl:data-in/dim_ident.dat does not exist
In the event that the specified file within the zip is not present, I would like to raise an error. Is there a way to do this using the above zip syntax?
Thanks,
Heather
-
Hi Heather,
Thank you for reporting this issue, I have taken the liberty of creating a ticket in our system and our Developers are currently working on establishing a fix for our next CloverETL release. In the meantime, I have created a workaround that will cause the graph to fail if the specified file is not present in the zip.
ZipReader.grf
Please sign in to leave a comment.
Comments 3