This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.

Tools
Enthusiast

This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.

Hi All,

I am using the MLOAD script in UNIX:

.LOGTABLE logatble;

.RUN FILE /work/user/user1;

DROP TABLE wrktab;

DROP TABLE ettab;

DROP TABLE uvtab;

.BEGIN MLOAD

 TABLES tabl1

  WORKTABLES  wrktab   

ERRORTABLES ettab               

uvta;

 .LAYOUT INPUTLAYOUT;

 .FIELD IN_STRTGY_SRC_CD     1   CHAR(2)  NULLIF IN_STRTGY_SRC_CD=' ';

 .FIELD IN_TACTIC_ID      3   CHAR(50) NULLIF IN_TACTIC_ID=' ';

 .FIELD IN_TRGT_TYP_CD      53  CHAR(3)  NULLIF IN_TRGT_TYP_CD=' ';

 .FIELD IN_EVNT_ACTVY_TYP_CD     56  CHAR(2)  NULLIF IN_EVNT_ACTVY_TYP_CD=' ';

 .FIELD IN_EVNT_ACTVY_TYP_CD_VRSN   58  CHAR(2)  NULLIF IN_EVNT_ACTVY_TYP_CD_VRSN=' ';

 .FIELD IN_ENCODING_IND      60  CHAR(1)  NULLIF IN_ENCODING_IND=' ';

 .FIELD IN_FIELD_DESC               61  CHAR(17) NULLIF IN_FIELD_DESC=' ';

 .FIELD IN_FILENAME      78  CHAR(50) NULLIF IN_FILENAME=' ';

 .FIELD IN_FILENAME_SUFFIX     128 CHAR(8)  NULLIF IN_FILENAME_SUFFIX=' ';

 .FIELD IN_VNDR_TRANSMISSION_CD     136 CHAR(2)  NULLIF IN_VNDR_TRANSMISSION_CD=' ';

 .FIELD IN_EMAIL_NOTIF_ADDR     138 CHAR(30) NULLIF IN_EMAIL_NOTIF_ADDR=' ';

 .FIELD IN_PROCESS_TYP      168 CHAR(1)  NULLIF IN_PROCESS_TYP=' ';

 .FIELD IN_USRID             169 CHAR(8)  NULLIF IN_USRID=' ';

 .FIELD IN_FILLER             177 CHAR(4)  NULLIF IN_FILLER=' ';

 .FIELD IN_TIMESTAMP             181 CHAR(26) NULLIF IN_FILLER=' ';

.DML LABEL INSERT_FINEREC;

INSERT INTO tbl1

      (

 STRTGY_SRC_CD

 ,TACTIC_ID

 ,TRGT_TYP_CD

 ,EVNT_ACTVY_TYP_CD

 ,EVNT_ACTVY_TYP_CD_VRSN

 ,ENCODING_IND

 ,FIELD_DESC

 ,FILENAME

 ,FILENAME_SUFFIX

 ,VNDR_TRANSMISSION_CD

 ,EMAIL_NOTIF_ADDR

 ,PROCESS_TYP

 ,USRID

 ,FILLER

 ,CNTRL_ID

 ,EMAIL_IND

 ,VN_ERR_CD

 ,ERR_REC

 ,ATTEMPT_NO

 ,LOAD_TIMESTAMP

 ,CNTRL_DTL_MOVED_IND

 )

VALUES (

 :IN_STRTGY_SRC_CD,

 :IN_TACTIC_ID,

 :IN_TRGT_TYP_CD,

 :IN_EVNT_ACTVY_TYP_CD,

 :IN_EVNT_ACTVY_TYP_CD_VRSN,

 :IN_ENCODING_IND,

 :IN_FIELD_DESC,

 :IN_FILENAME,

 :IN_FILENAME_SUFFIX,

 :IN_VNDR_TRANSMISSION_CD,

 :IN_EMAIL_NOTIF_ADDR,

 :IN_PROCESS_TYP,

 :IN_USRID,

 :IN_FILLER,

 NULL,

 NULL,

 NULL,

 'N',

 0,

 :IN_TIMESTAMP,

 NULL

);

.IMPORT INFILE /work/scripts/cmpbypass/temp/finerec.txt

      FORMAT UNFORMAT

      LAYOUT INPUTLAYOUT

      APPLY INSERT_FINEREC;

.END MLOAD;

.LOGOFF;

and getting the error:This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.

Please help.

Thanks,

Terankit

2 REPLIES
Teradata Employee

Re: This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.

It would be helpful to see the entire MultiLoad output, but without that I can answer that the issue has to do with a synchronization problem between MultiLoad and the database.

They both have to be in sync with each other on a restart.

In other words, MultiLoad cannot think that the restart should resume in the DML Phase while the database thinks the job needs to resume in the Acquisition Phase.

If this was an initial job, then it could signal that the restart logtable exists from a previous job.

So, in order to assist more, I would need to know more speficia about the job.

-- SteveF
Enthusiast

Re: This MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS.

Hi Feinholz,

thanks for the reply. The issue was , i was using different temp and error table names. It is working now. thanks agian.