Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

pedro
2012-04-26 09:07:28

Hi All

I have a nice chatting with Pavan online.
Finally we find the reason and fix it.
This is due to the wrong file path typed in tSystem.

Regards,
Pedro

tpk
2012-04-26 07:47:40

Hi Pedro,

The path which i gave was correct only there is nothing wrong in it. I am tired now with these, i don't see any examples for the syntax of correctly using tSystem, even though they are present it just a simple printing of "Hello World!"

Thanks and Regards,
Pavan

Skype: pavan.tummala1

pedro
2012-04-26 01:40:23

Hi Pavan

You'd better find the directory where WINZIP32 is located.
The error means the file path is wrong.

Regards,
Pedro

tpk
2012-04-25 20:13:57

Hi Pedro,

Any update/comments on the same?

Thanks and Regards,
Pavan

tpk
2012-04-25 18:34:48

Hi Pedro,

I had raised a ticket in JIRA and the link is below

http://jira.talendforge.org/browse/TDI-20874

Can you give me the same syntax for WinZip, i tried with the same syntax you had given no luck again the same story

new String[]{"C:/Program Files(x86)/WinZip/WINZIP32.exe","-e","C:/Test11/bcsteepandcheap_2012-04-10.tar.gz","C:/Test"}

I had attached the images of error

Thanks and Regards,
Pavan

pedro
2012-04-25 16:32:53

Hi Pavan

Got it.
You want to get hit_data.tsv. If I simply rename the archive file like *.gz, hit_data.tsv is not available.
Please report it on BugTracker.
Just say that tFileUnarchive can't unzip *.tar.gz correctly and offer them the URL to download these tar.gz files.

Now go back to use tSystem.
The reason why you get "No archives found" at Comment #22 is that you forgot to add suffix .gz.

The string in tSystem should be as below.

Code:

new String[]{"C:/Program Files/WinZip/WINZIP32.exe","-e","C:/Test1/bcbackcountry_2012-04-08.tar.gz","C:/test"}

What you tpye at Comment #22 is bcbackcountry_2012-04-08.tar.

I'm sure everything works fine this time.

Regards,
Pedro

tpk
2012-04-25 15:38:47

Hi Pedro,

If we change the name of the file it works but this is going to complicate the job as this extraction is interlinked with the job which we had discussed in the below link

http://www.talendforge.org/forum/viewtopic.php?id=23454

After extraction of each file 13 files will be extracted and from that 13 files i will read hit_data.tsv file which will be processed by the tOracleBulkExec which u can see the job in detail in the above link i had given. But if i do as you mention by changing the name of the file the extracted file name is changed to the changed gz file name and obviously tOracleBulkExec will fail because it will fetch for hit_data.tsv file. So this wont work out. I think this is definitely an issue with tFileUnarchive component, because my remaining all files are being extracted with out changing the file name, why should i now change the file name?


Thanks and Regards,
Pavan

janhess
2012-04-25 14:58:26

Do you need to change c:/Test to c:\\Test

pedro
2012-04-25 13:43:39

Hi Pavan

After some attempts, I find that the suffix of these two files are wrong.
They should be .gz but not tar.gz.
If I rename these two files, the tFileUnarchive works fine. Or I shall get the errors you mentioned above.

Code:

SizableSend.com-Upload-04-25-2012-887977---bcsteepandcheap_2012_04_10.gz
SizableSend.com-Upload-04-25-2012-887978---bcsteepandcheap_2012_04_10.gz

I do these tests in TOS 5.0.1 and TOS 5.1.0.
My OS is win7 32bit.

I don't think this is an issue related to file size.
Wait for your feedback.


Regards,
Pedro

tpk
2012-04-25 11:36:31

Hi Pedro,

Thank you very much, I will be waiting for your valuable feed back on the above.

Thanks and Regards,
Pavan

Code:

Thanks for your feedback.

I will download it soon and test it for you.
pedro
2012-04-25 10:20:26

Hi Pavan

Thanks for your feedback.

I will download it soon and test it for you.

Regards,
Pedro

tpk
2012-04-25 10:10:31

Hi Pedro,

I am giving you the links below where you can download the zip files and check what is wrong with the zip files and kindly suggest what i need to do to run it properly. The file format is fixed it can not be changed because this is the format that our client send us files daily from the past. Earlier we have an SSIS job which will call the WinZip.exe in the job to accomplish the extraction, now as we are moving the job to talend i am using tFileUnarchive to accomplish this job, but i think there is no much luck with me in using this component

bcbackcountry_2012-04-10.tar.gz... (207.55MB) - Completed
Download:    https://sizablesend.com/file/ec3xw3/bcb … _10.tar.gz
Short URL:    http://twelio.com/zyrqmt


bcsteepandcheap_2012-04-10.tar.gz... (194.49MB) - Completed
Download:    https://sizablesend.com/file/2s5fi2/bcs … _10.tar.gz
Short URL:    http://twelio.com/izjgn6

You can use the above path to download the files

Thanks and Regards,
Pavan


pedro wrote:

Hi Pavan

Could you send me an email and attach this tar.gz file?
I will test it for you.

Regards,
Pedro

tpk
2012-04-10 12:43:10

Hi Pedro,

Even i change the path as you mentioned still the same the alert appears to be same

Thanks and Regards,
Pavan

pedro
2012-04-10 12:19:41

Hi Pavan

This is because the file path "C:/Test1/bcbackcountry_2012-04-08.tar" is wrong.
You'd better recheck it and change it into this pattern.

Code:

"C:\\Test1\\bcbackcountry_2012-04-08.tar.gz"

Regards,
Pedro

tpk
2012-04-10 12:10:08

Hi Pedro,

I am getting the below error, can you help me out?

I have attached the images of the job and alert message.

Thanks and Regards,
Pavan

Board footer

Powered by FluxBB