Mload Error. Load was terminated by signal 1073741819

Tools & Utilities

Mload Error. Load was terminated by signal 1073741819

No idea why Mload failed in initial phase.  Could anyone help?

2015-08-19 05:03:03.675000 :Starting job  jira_issue_test

2015-08-19 05:03:03.675000 :Loading conf file  C:\workspace\DIS\DISMetrics\conf\jira\sql1.mld using  mload

     ========================================================================

     =                                                                      =

     =          MultiLoad Utility    Release MLOD.14.10.00.04               =

     =          Platform WIN32                                              =

     =                                                                      =

     ========================================================================

     =                                                                      =

     =     Copyright 1990-2013 Teradata Corporation. ALL RIGHTS RESERVED.   =

     =                                                                      =

     ========================================================================

**** 05:03:03 UTY2411 Processing start date: WED AUG 19, 2015

     ========================================================================

     =                                                                      =

     =          Logon/Connection                                            =

     =                                                                      =

     ========================================================================

0001 .LOGTABLE p_support_cn_t.JIRAISSUE_LOG;

0002 .LOGON vivaldi/bshu,;

**** 05:03:06 UTY8400 Current RDBMS supports Enhanced Statement Status

**** 05:03:08 UTY8400 Teradata Database Release: 14.10.04.504

**** 05:03:08 UTY8400 Teradata Database Version: 14.10.04.504

**** 05:03:08 UTY8400 Default character set: ASCII                         

**** 05:03:08 UTY8400 Current RDBMS has interval support

**** 05:03:08 UTY8400 Current RDBMS has UDT support

**** 05:03:08 UTY8400 Current RDBMS has Large Decimal support

**** 05:03:08 UTY8400 Current RDBMS has TASM support

**** 05:03:08 UTY8400 Maximum supported buffer size: 1M

**** 05:03:08 UTY8400 Data Encryption supported by RDBMS server

**** 05:03:22 UTY6211 A successful connect was made to the RDBMS.

**** 05:03:22 UTY6217 Logtable 'p_support_cn_t.JIRAISSUE_LOG' has been created.

     ========================================================================

     =                                                                      =

     =          Processing Control Statements                               =

     =                                                                      =

     ========================================================================

0003 DELETE FROM p_support_cn_t.JIRAISSUE;

**** 05:03:25 UTY1016 'DELETE' request successful.

0004 .BEGIN IMPORT MLOAD TABLES p_support_cn_t.JIRAISSUE

                         WORKTABLES p_support_cn_t.WT_JIRAISSUE

                         ERRORTABLES p_support_cn_t.ET_JIRAISSUE 

     p_support_cn_t.UV_JIRAISSUE;

     ========================================================================

     =                                                                      =

     =          Processing MultiLoad Statements                             =

     =                                                                      =

     ========================================================================

0005 .LAYOUT DATAIN_LAYOUT;

0006 .FIELD ISSUE * varchar(18);

0007 .FIELD Ticket * VARCHAR(50);

0008 .FIELD Category * VARCHAR(50);

0009 .FIELD SubCategory * VARCHAR(50);

0010 .FIELD RootCause * VARCHAR(50);

0011 .FIELD Created * varchar(10);

0012 .FIELD Resolved * varchar(10);

0013 .FIELD Assignee * VARCHAR(50);

0014 .FIELD TSummary * VARCHAR(255);

0015 .FIELD Reporter * VARCHAR(50);

0016 .FIELD Status * VARCHAR(50);

0017 .FIELD Satisfaction * VARCHAR(50);

0018 .FIELD NSatisfaciton * varchar(18);

0019 .FIELD NK * varchar(18);

0020 .FIELD Root_Cause_Categ * varchar(50);

0021 .FIELD Priority * varchar(50);

0022 .FIELD FUpdated * varchar(10);

0023 .DML LABEL INSERT_DML;

0024 INSERT INTO p_support_cn_t.JIRAISSUE

     values(

     :ISSUE ,

     :Ticket ,

     :Category ,

     :SubCategory ,

     :RootCause ,

     :Created ,

     :Resolved ,

     :Assignee ,

     :TSummary ,

     :Reporter ,

     :Status ,

     :Satisfaction ,

     :NSatisfaciton ,

     :NK,

     :Root_Cause_Categ ,

     :Priority ,

     :FUpdated

     );

0025 .IMPORT INFILE sql1.txt

       FORMAT VARTEXT '|'

       LAYOUT DATAIN_LAYOUT

       APPLY INSERT_DML;    

0026 .END MLOAD;

     ========================================================================

     =                                                                      =

     =          MultiLoad Initial Phase                                     =

     =                                                                      =

     ========================================================================

****Error. Load was terminated by signal 1073741819 ****

2015-08-19 05:04:33.597000 :Failed executing job when loading C:\workspace\DIS\DISMetrics\conf\jira\sql1.mld

Tags (1)
4 REPLIES
Teradata Employee

Re: Mload Error. Load was terminated by signal 1073741819

Does this happen every time you run that job?

Or is this an intermittent problem?

If this happens every time for this particular job, please open an incident with the GSC and let them help you work the issue.

-- SteveF

Re: Mload Error. Load was terminated by signal 1073741819

It happen every time.  Originally I ran it from Win7, it's ok; after I migrated it to Winserver 2003, it failed.

Teradata Employee

Re: Mload Error. Load was terminated by signal 1073741819

Signal 1073741819 means error code 0xC0000005 ( memory access violation ).

Please install all the latest TTU 14101 Efix patches of TeraGSS, TDICU , Cliv2, Dataconnector ( aka PIOM ) and Mload.

Please check the event viewer in Windows after the running the mload program and mention the details of  the error event.

The details mentioned in the error event will pinpoint which module is crashing due to memory access violation.

We tested Mload script which loads VARTEXT data and it worked fine.

Please provide the job script and datafile if they are not confidential.

Teradata Employee

Re: Mload Error. Load was terminated by signal 1073741819

Small correction. Its TTU1410 not TTU14101