topic Re: tGreenplumGPLoad component gives gpload error in Talend Studio

tGreenplumGPLoad component gives gpload error

_AnonymousUser — Sat, 16 Nov 2024 12:07:02 GMT

We are having issues while using the tGreenplumGPLoad component. The data file and control file is created correctly and the target table gets created successfully and also the Talend job ends with errorcode as 0 but a dialog box is displayed after which the job ends. The message displayed in dialog box is as below:
"See the logfile 'C:\Python25\dist\gpload.exe.log' for details"
And below is the error in the gpload.exe.log file:

"gpload was unable to import The PyGreSQL Python module (pg.py) - DLL load failed: The specified procedure could not be found."

However, python is correctly installed in my machine. The data does not get migrated.
Appreciate any help on this.

Thanks,
Hemant

Re: tGreenplumGPLoad component gives gpload error

Anonymous — Mon, 21 Jan 2013 08:48:50 GMT

Hi,
What version do you used? Talend open studio for Data integration or Talend Enterprise studio for Data integration, sorry for the misunderstanding.
Best regards
Sabrina

Re: tGreenplumGPLoad component gives gpload error

_AnonymousUser — Mon, 21 Jan 2013 09:13:37 GMT

Hi Sabrina,
Thanks for a prompt reply! We are currently using Talend Open Studio 5.2.0 and it does have a tGreenplumGPLoad component. Actually when we started using this component, it was working fine with small tables, but since we tried it with a huge table of abt 80 crore rows, we are getting this kind of issue. We even re-installed the Greenplum client, Python & TOS, but to no avail.
Appreciate any response on this.
Thanks,
Hemant

Re: tGreenplumGPLoad component gives gpload error

_AnonymousUser — Mon, 06 Mar 2017 06:38:32 GMT

Hi Sabina,
I have installed tgreenplum loader correctly. It is working fine from command line and able to upsert data
However when I run from tsystem using command "cmd /c gpload.py -f gpload.yml" I get below error
Error -gpload was unable to import the pygresql python module (pg.py) dll load failed with error code 193
Please suggest solution
regards
Vinit