topic Re: Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file in Talend Studio

Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file

Anonymous — Sat, 16 Nov 2024 03:27:19 GMT

Morning,

I am trying to launch a task on an Engine running on my PC, which writes some records onto Snowflake. If I run the job through Talend Studio it works fine. If I launch a task from the management console, I get the following exception.

tDBOutputBulkExec_1 UNEXPECTED_EXCEPTION:{message=An error occurred while creating temporary file. El sistema no puede encontrar la ruta especificada}org.talend.daikon.exception.TalendRuntimeException: UNEXPECTED_EXCEPTION:{message=An error occurred while creating temporary file. El sistema no puede encontrar la ruta especificada} at org.talend.components.snowflake.ee.runtime.loaders.utils.SnowflakeExceptionUtils.getTalendRuntimeException(SnowflakeExceptionUtils.java:27)

Attached is a screenshot of the job.

Re: Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file

Anonymous — Mon, 27 Jan 2020 14:08:52 GMT

This looks like a permissions issue on your server. On your local machine you will have permission to write to the filesystem anywhere (most likely), whereas on the server either your staging location does not exist or the user running the job does not have permission to write to it.

Re: Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file

Anonymous — Mon, 27 Jan 2020 15:15:10 GMT

Indeed, I am working with a VPN, which is activated in my machine. Still, the Remote Engine is also running on my machine so I would guess it also runs under the same VPN session? Is there some parameter I have to alter? There is something that I am clearly missing. Thanks for your help.

Re: Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file

Anonymous — Mon, 27 Jan 2020 15:42:57 GMT

If the Remote Engine is running on your machine and this is not working, it could be because the Remote Engine is running under a different user account which does not have access to write files. A VPN should not really make any difference here. I think the best thing for you to do is to raise a support call. They can take a look at your job and see how you are configured and will likely be able to see the issue quite quickly.

Re: Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file

Anonymous — Tue, 28 Jan 2020 14:41:41 GMT

Good afternoon,

I uninstalled the Remote Engine and installed via the zip file under C:\Users\<myuser>. This way the error was solved and the job runs correctly on the Remote Engine. Thanks for your help.

Re: Exception in component tDBOutputBulkExec_1 message=An error occurred while creating temporary file

Anonymous — Sat, 01 Feb 2020 18:08:42 GMT

Not a problem. Glad you got your problem solved.