Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
dbaranda
Contributor
Contributor

Error in tFileFetch "method failed: http/1.1 407 proxy authentication required" when trying to download a file from the Internet.

I have TOS 7.2.1 installed in my computer and I´m trying to use tFileFetch in a job to download a CSV file from the internet. I need to go throw a proxy so this is my configuration:

0683p000009M8ae.png

When I run it I get the following error:

0683p000009M8bg.png

 

I also tried to configure the proxy from the "Preferences" menu option with the same result:

0683p000009M8bl.png 

 

Please advise. I can't figure out any thing else to try. I have seaeched in this web without finding any other possible thing to do. Thanks.

Labels (3)
3 Replies
Anonymous
Not applicable

Hello,

Does the same URL (used in tFileFetch) work from the browser? No proxy or special certificate is involved?

Could you please try to call it in a tSystem with exactly the same proxy information (host, port, username and password) to see if it works well?

Best regards

Sabrina

dbaranda
Contributor
Contributor
Author

The url works in Chrome and downloads a file:

https://www.stats.govt.nz/assets/Uploads/Annual-enterprise-survey/Annual-enterprise-survey-2018-fina...

 

I have tried to run it with tSystem as you suggested. This is the command:

"wget https://www.stats.govt.nz/assets/Uploads/Annual-enterprise-survey/Annual-enterprise-survey-2018-fina... -e use_proxy=yes -e https_proxy=http://proxyma.corp.iberdrola.com:8080 --proxy-user=XXXXXX--proxy-password=******!"

 

It does NOT work. The error is:

xception in component tSystem_1 (Prueba_3)
java.io.IOException: Cannot run program "wget": CreateProcess error=2, El sistema no puede encontrar el archivo especificado
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at local_project.prueba_3_0_1.Prueba_3.tSystem_1Process(Prueba_3.java:319)
at local_project.prueba_3_0_1.Prueba_3.runJobInTOS(Prueba_3.java:655)
at local_project.prueba_3_0_1.Prueba_3.main(Prueba_3.java:505)

 

 

dbaranda
Contributor
Contributor
Author

I did manage to run it with tSystem as you suggested. It reads the proxy information and works just fine. 

I still can´t make it worjk form TFileFetch. Please advice.