Running a job from TAC, you get a "tGEGreenplumGPLoad_1 gpload failed" error

Talend Version          6.3.1

Summary

While running a job from TAC, you get the following error in the Job Server logs:

[FATAL]: coe_s.emp_ff_to_ge_greenplum_load_upd_dev21_0_1.EMP_FF_to_GE_GREENPLUM_LOAD_UPD_DEV21 - tGEGreenplumGPLoad_1 gpload failed because: OSError: [Errno 13] Permission denied: '/root/gpAdminLogs'
Additional Versions  
Product Talend Data Integration
Component tGEGreenplumGPLoad_1
Problem Description

When you enable JobServer to run as a service in UNIX systems, you get the following error when using the tGEGreenplumGPLoad component.

[FATAL]:coe_s.emp_ff_to_ge_greenplum_load_upd_dev21_0_1.EMP_FF_to_GE_GREENPLUM_LOAD_UPD_DEV21 - tGEGreenplumGPLoad_1 gpload failed because: OSError: [Errno 13] Permission denied: '/root/gpAdminLogs'
Problem root cause If you run /etc/init.d/custom script as root, and even though you have your script configured to switch to the talend user using RUN_AS_USER, gpload expects the talend user to write under /root/gpAdminLogs. Since this directory is owned by root, it fails with the stated error. Even if you change the ownership of this particular directory to the talend user, it still fails with the same error. If you start the JobServer using the start_rs.sh script (default), this issue is not observed.
Solution or Workaround Run the script that starts your Jobserver as a service using the following command:
su -l talend -c "/etc/init.d/yourshscript.sh start"

This should take care of the permission issues; if not, have a scripting engineer take a look at your script.

 

For more information on gpload, see the following page: https://kb.informatica.com/solution/23/Pages/54/336129.aspx.

JIRA ticket number  
Version history
Revision #:
3 of 3
Last update:
‎09-08-2017 11:29 AM
Updated by:
 
Contributors