Execution of command did not complete successfully with exit code [-1073741819]

Tools & Utilities
Highlighted
C_P
Fan

Execution of command did not complete successfully with exit code [-1073741819]

Hi Gurus,

I have a tpump execution through command task. And intermittently it fails with an exit code [-1073741819]. (not always it fails)

Kindly help me on this. Please find below the code that is run through command task using:

" tpump < \honts8015\shares\HRBI_Prod\HRAppsRoot\TgtFiles\Bkp\SIL_w_employment_d.out.ctl "

.DATEFORM ANSIDATE;
.RUN FILE \honts8015\shares\HRBI_Prod\HRAppsRoot\ParameterFile\LOGON_Bkp.TXT;

.LOGTABLE WM_UTIL.TL_W_BUSN_LOCATION_D0;

.ROUTE MESSAGES WITH ECHO TO FILE '\honts8015\shares\HRBI_Prod\HRAppsRoot\TgtFiles\Bkp\SIL_w_busn_location_d.out.ldrlog' ;

DROP TABLE WM_UTIL.ET_W_BUSN_LOCATION_D0 ;

.BEGIN LOAD
ERRORTABLE WM_UTIL.ET_W_BUSN_LOCATION_D0
ERRLIMIT 0
CHECKPOINT 15
TENACITY 4
SESSIONS 16
SLEEP 6
SERIALIZE OFF
PACK 25
ROBUST OFF
NOMONITOR
MACRODB WW_HR_OBI_TPUMP
;

/* Begin Layout Section */

.Layout InputFileLayout;

.Field ROW_WID 1 CHAR( 12) ;
.Field GEO_WID 13 CHAR( 12) NULLIF GEO_WID = '*' ;
.Field ADDRESS_TYPE 25 CHAR( 30) NULLIF ADDRESS_TYPE = '*' ;
.Field BUSN_LOC_NAME 55 CHAR( 80) NULLIF BUSN_LOC_NAME = '*' ;
.Field BUSN_LOC_NUM 135 CHAR( 30) NULLIF BUSN_LOC_NUM = '*' ;
.Field BUSN_LOC_TYPE 165 CHAR( 30) NULLIF BUSN_LOC_TYPE = '*' ;
.Field CONTACT_NAME 195 CHAR( 255) NULLIF CONTACT_NAME = '*' ;
.Field CONTACT_NUM 450 CHAR( 30) NULLIF CONTACT_NUM = '*' ;
.Field PARENT_LOC_NAME 480 CHAR( 80) NULLIF PARENT_LOC_NAME = '*' ;
.Field PARENT_LOC_NUM 560 CHAR( 80) NULLIF PARENT_LOC_NUM = '*' ;
.Field ST_ADDRESS1 640 CHAR( 80) NULLIF ST_ADDRESS1 = '*' ;
.Field ST_ADDRESS2 720 CHAR( 255) NULLIF ST_ADDRESS2 = '*' ;
.Field CITY_NAME 975 CHAR( 80) NULLIF CITY_NAME = '*' ;
.Field POSTAL_CODE 1055 CHAR( 50) NULLIF POSTAL_CODE = '*' ;
.Field COUNTY 1105 CHAR( 50) NULLIF COUNTY = '*' ;
.Field STATE_CODE 1155 CHAR( 50) NULLIF STATE_CODE = '*' ;
.Field STATE_NAME 1205 CHAR( 80) NULLIF STATE_NAME = '*' ;
.Field STATE_REGION 1285 CHAR( 50) NULLIF STATE_REGION = '*' ;
.Field COUNTRY_CODE 1335 CHAR( 50) NULLIF COUNTRY_CODE = '*' ;
.Field COUNTRY_NAME 1385 CHAR( 80) NULLIF COUNTRY_NAME = '*' ;
.Field COUNTRY_REGION 1465 CHAR( 50) NULLIF COUNTRY_REGION = '*' ;
.Field PHONE_NUM 1515 CHAR( 30) NULLIF PHONE_NUM = '*' ;
.Field FAX_NUM 1545 CHAR( 30) NULLIF FAX_NUM = '*' ;
.Field EMAIL_ADDRESS 1575 CHAR( 255) NULLIF EMAIL_ADDRESS = '*' ;
.Field WEB_ADDRESS 1830 CHAR( 255) NULLIF WEB_ADDRESS = '*' ;
.Field ACTIVE_FLG 2085 CHAR( 1) NULLIF ACTIVE_FLG = '*' ;
.Field CREATED_BY_WID 2086 CHAR( 12) NULLIF CREATED_BY_WID = '*' ;
.Field CHANGED_BY_WID 2098 CHAR( 12) NULLIF CHANGED_BY_WID = '*' ;
.Field CREATED_ON_DT 2110 CHAR( 19) NULLIF CREATED_ON_DT = '*' ;
.Field CHANGED_ON_DT 2129 CHAR( 19) NULLIF CHANGED_ON_DT = '*' ;
.Field AUX1_CHANGED_ON_DT 2148 CHAR( 19) NULLIF AUX1_CHANGED_ON_DT = '*' ;
.Field AUX2_CHANGED_ON_DT 2167 CHAR( 19) NULLIF AUX2_CHANGED_ON_DT = '*' ;
.Field AUX3_CHANGED_ON_DT 2186 CHAR( 19) NULLIF AUX3_CHANGED_ON_DT = '*' ;
.Field AUX4_CHANGED_ON_DT 2205 CHAR( 19) NULLIF AUX4_CHANGED_ON_DT = '*' ;
.Field SRC_EFF_FROM_DT 2224 CHAR( 19) NULLIF SRC_EFF_FROM_DT = '*' ;
.Field SRC_EFF_TO_DT 2243 CHAR( 19) NULLIF SRC_EFF_TO_DT = '*' ;
.Field EFFECTIVE_FROM_DT 2262 CHAR( 19) ;
.Field EFFECTIVE_TO_DT 2281 CHAR( 19) NULLIF EFFECTIVE_TO_DT = '*' ;
.Field DELETE_FLG 2300 CHAR( 1) NULLIF DELETE_FLG = '*' ;
.Field CURRENT_FLG 2301 CHAR( 1) NULLIF CURRENT_FLG = '*' ;
.Field W_INSERT_DT 2302 CHAR( 19) NULLIF W_INSERT_DT = '*' ;
.Field W_UPDATE_DT 2321 CHAR( 19) NULLIF W_UPDATE_DT = '*' ;
.Field DATASOURCE_NUM_ID 2340 CHAR( 12) ;
.Field ETL_PROC_WID 2352 CHAR( 12) ;
.Field INTEGRATION_ID 2364 CHAR( 80) ;
.Field SET_ID 2444 CHAR( 30) NULLIF SET_ID = '*' ;
.Field TENANT_ID 2474 CHAR( 80) NULLIF TENANT_ID = '*' ;
.Field X_CUSTOM 2554 CHAR( 10) NULLIF X_CUSTOM = '*' ;
.Field GEO_COUNTRY_WID 2564 CHAR( 12) NULLIF GEO_COUNTRY_WID = '*' ;
.Field X_FACILITY_OPEN_DATE 2576 CHAR( 19) NULLIF X_FACILITY_OPEN_DATE = '*' ;
.Field X_FACILITY_OPEN_STATUS 2595 CHAR( 1) NULLIF X_FACILITY_OPEN_STATUS = '*' ;
.Field X_FACILITY_FUNCTION 2596 CHAR( 80) NULLIF X_FACILITY_FUNCTION = '*' ;
.Field X_FACILITY_FAMILY 2676 CHAR( 80) NULLIF X_FACILITY_FAMILY = '*' ;
.Field X_DIV_NBR 2756 CHAR( 22) NULLIF X_DIV_NBR = '*' ;
.Field X_STORE_TYPE 2778 CHAR( 10) NULLIF X_STORE_TYPE = '*' ;
.Filler EOL_PAD 2788 CHAR( 2) ;

/* End Layout Section */

/* begin DML Section */

.DML Label tagDML
Do insert for missing update rows;
UPDATE WW_HR_OBI_TABLES.W_BUSN_LOCATION_D
SET
GEO_WID = :GEO_WID ,
ADDRESS_TYPE = :ADDRESS_TYPE ,
BUSN_LOC_NAME = :BUSN_LOC_NAME ,
BUSN_LOC_NUM = :BUSN_LOC_NUM ,
BUSN_LOC_TYPE = :BUSN_LOC_TYPE ,
CONTACT_NAME = :CONTACT_NAME ,
CONTACT_NUM = :CONTACT_NUM ,
PARENT_LOC_NAME = :PARENT_LOC_NAME ,
PARENT_LOC_NUM = :PARENT_LOC_NUM ,
ST_ADDRESS1 = :ST_ADDRESS1 ,
ST_ADDRESS2 = :ST_ADDRESS2 ,
CITY_NAME = :CITY_NAME ,
POSTAL_CODE = :POSTAL_CODE ,
COUNTY = :COUNTY ,
STATE_CODE = :STATE_CODE ,
STATE_NAME = :STATE_NAME ,
STATE_REGION = :STATE_REGION ,
COUNTRY_CODE = :COUNTRY_CODE ,
COUNTRY_NAME = :COUNTRY_NAME ,
COUNTRY_REGION = :COUNTRY_REGION ,
PHONE_NUM = :PHONE_NUM ,
FAX_NUM = :FAX_NUM ,
EMAIL_ADDRESS = :EMAIL_ADDRESS ,
WEB_ADDRESS = :WEB_ADDRESS ,
ACTIVE_FLG = :ACTIVE_FLG ,
CREATED_BY_WID = :CREATED_BY_WID ,
CHANGED_BY_WID = :CHANGED_BY_WID ,
CREATED_ON_DT = :CREATED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
CHANGED_ON_DT = :CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
AUX1_CHANGED_ON_DT = :AUX1_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
AUX2_CHANGED_ON_DT = :AUX2_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
AUX3_CHANGED_ON_DT = :AUX3_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
AUX4_CHANGED_ON_DT = :AUX4_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
SRC_EFF_FROM_DT = :SRC_EFF_FROM_DT (DATE, FORMAT 'YYYYMMDD') ,
SRC_EFF_TO_DT = :SRC_EFF_TO_DT (DATE, FORMAT 'YYYYMMDD') ,
EFFECTIVE_TO_DT = :EFFECTIVE_TO_DT (DATE, FORMAT 'YYYYMMDD') ,
DELETE_FLG = :DELETE_FLG ,
CURRENT_FLG = :CURRENT_FLG ,
W_INSERT_DT = :W_INSERT_DT (DATE, FORMAT 'YYYYMMDD') ,
W_UPDATE_DT = :W_UPDATE_DT (DATE, FORMAT 'YYYYMMDD') ,
ETL_PROC_WID = :ETL_PROC_WID ,
SET_ID = :SET_ID ,
TENANT_ID = :TENANT_ID ,
X_CUSTOM = :X_CUSTOM ,
GEO_COUNTRY_WID = :GEO_COUNTRY_WID ,
X_FACILITY_OPEN_DATE = :X_FACILITY_OPEN_DATE (DATE, FORMAT 'YYYYMMDD') ,
X_FACILITY_OPEN_STATUS = :X_FACILITY_OPEN_STATUS ,
X_FACILITY_FUNCTION = :X_FACILITY_FUNCTION ,
X_FACILITY_FAMILY = :X_FACILITY_FAMILY ,
X_DIV_NBR = :X_DIV_NBR ,
X_STORE_TYPE = :X_STORE_TYPE
WHERE
ROW_WID = :ROW_WID
AND
EFFECTIVE_FROM_DT = :EFFECTIVE_FROM_DT (DATE, FORMAT 'YYYYMMDD')
AND
DATASOURCE_NUM_ID = :DATASOURCE_NUM_ID
AND
INTEGRATION_ID = :INTEGRATION_ID
;
INSERT INTO WW_HR_OBI_TABLES.W_BUSN_LOCATION_D (
ROW_WID ,
GEO_WID ,
ADDRESS_TYPE ,
BUSN_LOC_NAME ,
BUSN_LOC_NUM ,
BUSN_LOC_TYPE ,
CONTACT_NAME ,
CONTACT_NUM ,
PARENT_LOC_NAME ,
PARENT_LOC_NUM ,
ST_ADDRESS1 ,
ST_ADDRESS2 ,
CITY_NAME ,
POSTAL_CODE ,
COUNTY ,
STATE_CODE ,
STATE_NAME ,
STATE_REGION ,
COUNTRY_CODE ,
COUNTRY_NAME ,
COUNTRY_REGION ,
PHONE_NUM ,
FAX_NUM ,
EMAIL_ADDRESS ,
WEB_ADDRESS ,
ACTIVE_FLG ,
CREATED_BY_WID ,
CHANGED_BY_WID ,
CREATED_ON_DT ,
CHANGED_ON_DT ,
AUX1_CHANGED_ON_DT ,
AUX2_CHANGED_ON_DT ,
AUX3_CHANGED_ON_DT ,
AUX4_CHANGED_ON_DT ,
SRC_EFF_FROM_DT ,
SRC_EFF_TO_DT ,
EFFECTIVE_FROM_DT ,
EFFECTIVE_TO_DT ,
DELETE_FLG ,
CURRENT_FLG ,
W_INSERT_DT ,
W_UPDATE_DT ,
DATASOURCE_NUM_ID ,
ETL_PROC_WID ,
INTEGRATION_ID ,
SET_ID ,
TENANT_ID ,
X_CUSTOM ,
GEO_COUNTRY_WID ,
X_FACILITY_OPEN_DATE ,
X_FACILITY_OPEN_STATUS ,
X_FACILITY_FUNCTION ,
X_FACILITY_FAMILY ,
X_DIV_NBR ,
X_STORE_TYPE
) VALUES (
:ROW_WID ,
:GEO_WID ,
:ADDRESS_TYPE ,
:BUSN_LOC_NAME ,
:BUSN_LOC_NUM ,
:BUSN_LOC_TYPE ,
:CONTACT_NAME ,
:CONTACT_NUM ,
:PARENT_LOC_NAME ,
:PARENT_LOC_NUM ,
:ST_ADDRESS1 ,
:ST_ADDRESS2 ,
:CITY_NAME ,
:POSTAL_CODE ,
:COUNTY ,
:STATE_CODE ,
:STATE_NAME ,
:STATE_REGION ,
:COUNTRY_CODE ,
:COUNTRY_NAME ,
:COUNTRY_REGION ,
:PHONE_NUM ,
:FAX_NUM ,
:EMAIL_ADDRESS ,
:WEB_ADDRESS ,
:ACTIVE_FLG ,
:CREATED_BY_WID ,
:CHANGED_BY_WID ,
:CREATED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
:CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
:AUX1_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
:AUX2_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
:AUX3_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
:AUX4_CHANGED_ON_DT (DATE, FORMAT 'YYYYMMDD') ,
:SRC_EFF_FROM_DT (DATE, FORMAT 'YYYYMMDD') ,
:SRC_EFF_TO_DT (DATE, FORMAT 'YYYYMMDD') ,
:EFFECTIVE_FROM_DT (DATE, FORMAT 'YYYYMMDD') ,
:EFFECTIVE_TO_DT (DATE, FORMAT 'YYYYMMDD') ,
:DELETE_FLG ,
:CURRENT_FLG ,
:W_INSERT_DT (DATE, FORMAT 'YYYYMMDD') ,
:W_UPDATE_DT (DATE, FORMAT 'YYYYMMDD') ,
:DATASOURCE_NUM_ID ,
:ETL_PROC_WID ,
:INTEGRATION_ID ,
:SET_ID ,
:TENANT_ID ,
:X_CUSTOM ,
:GEO_COUNTRY_WID ,
:X_FACILITY_OPEN_DATE (DATE, FORMAT 'YYYYMMDD') ,
:X_FACILITY_OPEN_STATUS ,
:X_FACILITY_FUNCTION ,
:X_FACILITY_FAMILY ,
:X_DIV_NBR ,
:X_STORE_TYPE
) ;

/* end DML Section */

/* Begin Import Section */

.Import Infile '\honts8015\shares\HRBI_Prod\HRAppsRoot\TgtFiles\SIL_w_busn_location_d.out'
Layout InputFileLayout
Format Unformat
Apply tagDML
;

/* End Import Section */

.END LOAD;

.LOGOFF;

Regards,

C.P

1 REPLY
C_P
Fan

Re: Execution of command did not complete successfully with exit code [-1073741819]

All I could find was some information regarding the exit code:

-1073741819 = 0xC0000005

Access violation.

Indicates that the executed program has terminated abnormally or crashed.

Regards,

C.P