Code: Select all
OCI_LU
|
|
|
HASH
|
|
OCI_IN-----TFM----OCI_OUT
The OCI_OUT is set to insert rows without clearing.
The job runs through and then aborts with an "Abnormal Termination" but does however insert the required rows into the target table.
Dont undesrstand why the "Abnormal Termination" occurs.
Ive included log entries for the termination and pre and post termination log entries.
Pre Warning Log
X0001_Create_Initial_PL_Table..IQ_DIM_COMPANY: INSERT INTO PL_ENTRY_HISTORY(PL_ENTRY_HISTORY_SEQ_NO, PL_FILENAME, PL_FILE_QTR, PL_FILE_YEAR, PL_ACTIVE, PL_KEY, COMPANY_CODE, COMPANY_DESCRIPTION, TREATY_CATEGORY_CODE, TREATY_CATEGORY_DESCRIPTION, CORPORATE_ADJUSTMENT, TREATY_NATURE, TREATY_NATURE_DESCRIPTION, COUNTRY_CODE_ISO, COUNTRY_DESCRIPTION, FAS_CODE, FAS_DESCRIPTION, CLASS_OF_BUSINESS_CODE, CLASS_OF_BUSINESS_L3_CODE, CLASS_OF_BUSINESS_DESCRIPTION, RESULT_RESP_ID_ECON, RESULT_RESP_DESCRIPTION, TREATY_NUMBER, TREATY_DESCRIPTION, TREATY_SECTION, TREATY_SECTION_DESCRIPTION, STATUS_CODE, STATUS_DESCRIPTION, ACTUARIAL_SEGMENT, ACTUARIAL_SEGMENT_DESCRIPTION, PERIOD_START_DATE, PERIOD_END_DATE, INVOLVEMENT, INVOLVEMENT_DESCRIPTION, UNDERWRITING_YEAR, OCCURRENCE_YEAR, ACCOUNTING_YEAR, ENTRY_CODE_4, ENTRY_CODE_5, ENTRY_DESCRIPTION, GL_ACCOUNT, GL_ACCOUNT_DESCRIPTION, ESTIMATE_CODE, ESTIMATE_DESCRIPTION, REPORTING_ENTRY_CODE, PREV_CURR_YEAR, TRANSACTION_CURRENCY, ACCOUNTING_QUARTER, TC, GBP) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50)
Warning Log
Attempting to Cleanup after ABORT raised in stage X0001_Create_Initial_PL_Table..Transformer_163
Post Warning Log
Job X0001_Create_Initial_PL_Table aborted.