https://community.qlik.com/t5/Talend-Studio/tBigqueryOutput-Local-filename-when-running-on-CLoud-instance/m-p/2311885#M82886 <P><SPAN>You are getting an exception when you try to write the Excel file or other output file to the folder&nbsp;/home/data1&nbsp;because it does not exist on the machine with your remote engine or you do not have write permission to it.&nbsp; If the folder exists you should change the permission to let the Talend process&nbsp;write to it or just let everyone write to it, though this is less secure.</SPAN></P> <P>&nbsp;</P> <P><SPAN>I would suggest using the default Java temp directory, which is platform independent and will work on any machine, e.g. locally on your workstation, in the cloud or an on premise machine with the remote engine.</SPAN></P> <P>&nbsp;</P> <P><SPAN>You can use this directory in the path for your component to get the Java temp directory:</SPAN></P> <PRE>System.getProperty("java.io.tmpdir")</PRE> <P>&nbsp;</P> Sat, 18 May 2019 02:42:12 GMT nfz11 2019-05-18T02:42:12Z https://community.qlik.com/t5/Talend-Studio/tBigqueryOutput-Local-filename-when-running-on-CLoud-instance/m-p/2311884#M82885 <P>this error aappears to me when I try to run the job from talend cloud integration</P><P><SPAN>Step 5319d8d0-0b2b-427e-9d08-a923e8293f93 failed with code -1 and error Job stopped with errors or unable to run. ### Job STARTED at 2019/05/16 12:04:51 (jobId=06e1488ad43b144a71f44, jobExecutionId=20190516120451_O4ieR) ### Exception in component tBigQueryOutput_1_tBQOB (BigQuery_Excel_Export) java.io.FileNotFoundException: /home/data1 (Permission denied) at java.io.FileOutputStream.open0(Native Method) at java.io.FileOutputStream.open(Unknown Source) at java.io.FileOutputStream.&lt;init&gt;(Unknown Source) at tahatesting.bigquery_excel_export_1_0.BigQuery_Excel_Export.tBigQueryInput_2Process(BigQuery_Excel_Export.java:585) at tahatesting.bigquery_excel_export_1_0.BigQuery_Excel_Export.runJobInTOS(BigQuery_Excel_Export.java:1988) at tahatesting.bigquery_excel_export_1_0.BigQuery_Excel_Export.main(BigQuery_Excel_Export.java:1820) ### Job ENDED WITH ERROR at 2019/05/16 12:04:52 (jobId=06e1488ad43b144a71f44, jobExecutionId=20190516120451_O4ieR) ###</SPAN></P> Sat, 16 Nov 2024 05:49:02 GMT https://community.qlik.com/t5/Talend-Studio/tBigqueryOutput-Local-filename-when-running-on-CLoud-instance/m-p/2311884#M82885 Anonymous 2024-11-16T05:49:02Z https://community.qlik.com/t5/Talend-Studio/tBigqueryOutput-Local-filename-when-running-on-CLoud-instance/m-p/2311885#M82886 <P><SPAN>You are getting an exception when you try to write the Excel file or other output file to the folder&nbsp;/home/data1&nbsp;because it does not exist on the machine with your remote engine or you do not have write permission to it.&nbsp; If the folder exists you should change the permission to let the Talend process&nbsp;write to it or just let everyone write to it, though this is less secure.</SPAN></P> <P>&nbsp;</P> <P><SPAN>I would suggest using the default Java temp directory, which is platform independent and will work on any machine, e.g. locally on your workstation, in the cloud or an on premise machine with the remote engine.</SPAN></P> <P>&nbsp;</P> <P><SPAN>You can use this directory in the path for your component to get the Java temp directory:</SPAN></P> <PRE>System.getProperty("java.io.tmpdir")</PRE> <P>&nbsp;</P> Sat, 18 May 2019 02:42:12 GMT https://community.qlik.com/t5/Talend-Studio/tBigqueryOutput-Local-filename-when-running-on-CLoud-instance/m-p/2311885#M82886 nfz11 2019-05-18T02:42:12Z