Teradata Connector BULK Load Error
Posted: Wed Nov 05, 2014 3:24 pm
Hi,
I'm trying to do BULK load using Teradata Connector stage, but the job is failing with below error
I did try playing with Array Size using 'Immediate' method , but job is estimated to complete 6 hrs
Full Error :
Thanks in advance
Major
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
Full Error :
Can someone please help with this 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)
Thanks in advance
Major