Teradata Connector BULK Load Error

[major]

Hi,

I'm trying to do BULK load using Teradata Connector stage, but the job is failing with below error

Code: Select all

DBMS code 2113: Operator(libloadop.so) instance(1): INITIATE method failed with status = Fatal Error 

I did try playing with Array Size using 'Immediate' method , but job is estimated to complete 6 hrs

Full Error :

Teradata_Connector_93,0: RDBMS code 2113: Operator(libloadop.so) instance(1): INITIATE method failed with status = Fatal Error SQL statement: INSERT INTO CM_RAW.PHARMACY_CLAIM_WRK(OUTBOUND_FILE_ID,OUTBOUND_FILE_GEN_DT_TIME,INBOUND_FILE_ID,INTERFACE_CTRL_REL_NO,EDGE_SVR_VRSN,EDGE_SVR_PROC_ID,INBOUND_FILE_GEN_DT_TIME,
OUTBOUND_FILE_TYP_CD,EDGE_SVR_ID,ISS_ID,INBOUND_FILE_SUBM_DT_TIME,INBOUND_FILE_SUBM_TYP,ISSUER_RECORD_ID,ISSUER_ID,ISSUER_STAT_TYP_CD,ISSUER_ERR_ELEM_NAME,
ISSUER_ERR_ELEM_VALUE,ISSUER_ERR_TYP_CD,ISSUER_ERR_MSG,ISSUER_ERR_DTL,
PLAN_RECORD_ID,PLAN_ID,PLAN_STAT_TYP_CD,PLAN_ERR_ELEM_NAME,PLAN_ERR_ELEM_VALUE,PLAN_ERR_TYP_CD,PLAN_ERR_MSG,PLAN_ERR_DTL,CLAIM_RECORD_ID,CLAIM_ID,CLAIM_STAT_TYP_CD,
CLAIM_ERR_ELEM_NAME,CLAIM_ERR_ELEM_VALUE,CLAIM_ERR_TYP_CD,
CLAIM_ERR_MSG,CLAIM_ERR_DTL) VALUES(:OUTBOUND_FILE_ID,:OUTBOUND_FILE_GEN_DT_TIME,:INBOUND_FILE_ID,:INTERFACE_CTRL_REL_NO,:EDGE_SVR_VRSN,:EDGE_SVR_PROC_ID,:INBOUND_FILE_GEN_DT_TIME,:OUTBOUND_FILE_TYP_CD,
:EDGE_SVR_ID,:ISS_ID,:INBOUND_FILE_SUBM_DT_TIME,
:INBOUND_FILE_SUBM_TYP,:ISSUER_RECORD_ID,:ISSUER_ID,:ISSUER_STAT_TYP_CD,:ISSUER_ERR_ELEM_NAME,:ISSUER_ERR_ELEM_VALUE,:ISSUER_ERR_TYP_CD,:ISSUER_ERR_MSG,:ISSUER_ERR_DTL,
:PLAN_RECORD_ID,:PLAN_ID,:PLAN_STAT_TYP_CD,:PLAN_ERR_ELEM_NAME,
:PLAN_ERR_ELEM_VALUE,:PLAN_ERR_TYP_CD,:PLAN_ERR_MSG,:PLAN_ERR_DTL,:CLAIM_RECORD_ID,:CLAIM_ID,:CLAIM_STAT_TYP_CD,:CLAIM_ERR_ELEM_NAME,:CLAIM_ERR_ELEM_VALUE,:CLAIM_ERR_TYP_CD,
:CLAIM_ERR_MSG,:CLAIM_ERR_DTL) (CC_TeraParallelTransporter::initiate, file CC_TeraParallelTransporter.cpp, line 1,288)

Can someone please help with this error.

Thanks in advance
Major

[chulett]

Perhaps this?

[major]

Hi Chulett , thanks for the reply.

Issue has been resolved after using Teradata Connector variant 12

Thanks
Major