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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tPostgresqlOutputBulkExec temp file on wrong server

I have talend and the Postgresql database running on separate servers. 
The tPostgresqlOutputBulkExec component of my job is failing with a "file not found" error...
Exception in component tPostgresqlOutputBulkExec_2_tPBE
org.postgresql.util.PSQLException: ERROR: could not open file "/tmp/XXXX_YYYY.tmp" for reading: No such file or directory
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)

From looking at the help and web, I understand that the filename option of the tPostgresqlOutputBulkExec is a temporary file on the database host server, but I am seeing this file on the talend server. I have the host field set to the database servers FQDN ( dbserver.example.com ) .
Why is tPostgresqlOutputBulkExec creating the file on the talend server?  Is this a bug?
Thanks
0683p000009MAwl.png 0683p000009MAwq.png
Labels (3)
1 Reply
Anonymous
Not applicable
Author

No this is not a bug, it is perhaps a missing information in the documentation. This component runs the bulk loader from the postgresql installation and this program expect a file on the postgresql server. A solution to solve this could be a NFS share mounted on the same mount point on your talend server and the postgresql server. Save your file in this NFS file system and it will work.