tBigqueryOutput Local filename when running on CLoud instance
this error aappears to me when I try to run the job from talend cloud integration
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.<init>(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) ###
You are getting an exception when you try to write the Excel file or other output file to the folder /home/data1 because it does not exist on the machine with your remote engine or you do not have write permission to it. If the folder exists you should change the permission to let the Talend process write to it or just let everyone write to it, though this is less secure.
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.
You can use this directory in the path for your component to get the Java temp directory:
You are getting an exception when you try to write the Excel file or other output file to the folder /home/data1 because it does not exist on the machine with your remote engine or you do not have write permission to it. If the folder exists you should change the permission to let the Talend process write to it or just let everyone write to it, though this is less secure.
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.
You can use this directory in the path for your component to get the Java temp directory:
