A fix is available
APAR status
Closed as program error.
Error description
GreenPlum Connector read jobs do not abort when the database throws the SQL_ERROR due to any of the problematic situations. One such error message that was observed in the "[GreenPlum] ERROR: http response code 500 from gpfdist'. However this error can be avoided by using the proper values to CC_GP_PIPE_WAIT_DELAY and CC_GP_MAX_RECORD_LENGTH environment variables.
Local fix
add CC_GP_PIPE_WAIT_DELAY and CC_GP_MAX_RECORD_LENGTH environment variables.
Problem summary
GreenPlum Connector read jobs might hang whenever the GreenPlum Database Server throws an error message in response to SQLExecDirect with a return code of SQL_ERROR.
Problem conclusion
Code has been corrected to abort the job whenever the GreenPlum Database Server throws SQL_ERROR for SQLExecDirect call which executes the insert into statement.
Temporary fix
Correct the conditions such that the GreenPlum Database Server doesn't throw the return code SQL_ERROR.
Comments
APAR Information
APAR number
JR60085
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
912
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-10-01
Closed date
2018-10-22
Last modified date
2018-10-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
RB30 PSY
UP
RB70 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"912"}]
Document Information
Modified date:
03 September 2021