Hi when i am running a job,it was getting ann warning msg like below:
DataStage Job 600 Phantom 6645
Job Aborted after 1 errors logged.
Attempting to Cleanup after ABORT raised in stage etlBsl2WSSoPLACEMENT..xfmOpenDeal
DataStage Phantom Aborting with @ABORT.CODE = 1
in the previous warning ,it was showing one row's data..
so what whoul be the problem..can u pls suggest ....
Thanks
Fareed
Phantom error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Reset the job in Director. This may yield an event "from previous run..." that contains useful diagnostic information. Otherwise, are there any other warnings in the job log?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
phantom error
Thanks Ray
before that phantom error one warning is there.it is giving the complete record data in the warning msg. like this...
etlBsl2WSSoPLACEMENT..xfmOpenDeal: The value of the row is: AS_OF_DATE = 2006-12-13 SOURCE_CONTRACT_NUM = 00972006062140604 SOURCE_SYSTEM_ID = WSS SOURCE_ACCOUNT_NUM = 00009103205 COUNTERPARTY_ID = NULL COUNTERPARTY_NAME = HBOS TREASURY SVCS PLC COUNTERPARTY_TYPE = BANK COUNTRY = UNITED KINGDOM COUNTERPARTY_ADDRESS = NULL SOURCE_PRODUCT_TYPE = INTERBANK MM LOAN ASSET SOURCE_PRODUCT = PLACEMENTS SOURCE_PRODUCT_SUB_TYPE = MML STT_RATING = NULL SHORT_LIMIT = NULL LONG_LIMIT = NULL OUTSTANDING = 100000000 TRADE_DATE = 2006-06-21 SEC_ISSUE_DATE = NULL SEC_COUNTRY_OF_ISSUE = NULL MATURITY_DATE = 2007-06-26 SETTLEMENT_DATE = 2006-06-26 REPRICING_DATE = NULL REPRICING_BASE = FI REPRICING_FREQUENCY = NULL INT_PMT_DATE = NULL INT_PMT_TERM = NULL ACCRUED_INTEREST = 2351835.62 CURRENCY = GBP INTERNAL_COMPANY_FLAG = 0 NOTES = NULL PRIN_GL_NUM = NULL ACCR_INT_GL_NUM = NULL STT_UNIT = 0097 BUSINESS_UNIT = NULL ACCRUAL_CODE = ACT365 INTEREST_AT_MATURITY = 5020000 INTEREST_RATE = 5.02 INSTRUMENT_STATUS = NULL ASSET_LIABILITY_CODE = A CITY = LON PARENT_NUM = 00009103942 PARENT_NAME = BANK OF SCOTLAND TSY SV GLASGOW PARENT_FUND_NUM = NULL SWIFT_ID = BOFSGB22XXX CUSIP = NULL PAR_VALUE = NULL TRADE_PRICE = NULL MCH_FUND_NUM = NULL FILE_NAME = NULL RATING_MOODY = NULL RATING_STDPOOR = NULL UNREALIZED_PL_GL_NUM = NULL FCS_GL_NUM = NULL PRODUCT_TYPE_ID = 14 OUTSTANDING_USD_EQVL = 196595000 INTEREST_AT_MATURITY_USD_EQVL = 9869069 ACCRUED_INTEREST_USD_EQVL = 4623591.237139 CALC_EXCHANGE_RATE = 1.96595 CRITICAL_ERROR_FLAG = N RDR_INCLUDE_FLAG = Y RDR_PROCESSED_FLAG = N ERR_ASST_LBLTY_NULL = N ERR_ASST_LBLTY_INVALID = N ERR_SRC_ACCT_NUM_NULL = N ERR_OUTSTANDING_NULL = N EXCL_LIABILITY = N EXCL_CLOSED_MATURED = N EXCL_FUTURE_DATED = N
so what will be the problem..is the prblem is with the record..
before that phantom error one warning is there.it is giving the complete record data in the warning msg. like this...
etlBsl2WSSoPLACEMENT..xfmOpenDeal: The value of the row is: AS_OF_DATE = 2006-12-13 SOURCE_CONTRACT_NUM = 00972006062140604 SOURCE_SYSTEM_ID = WSS SOURCE_ACCOUNT_NUM = 00009103205 COUNTERPARTY_ID = NULL COUNTERPARTY_NAME = HBOS TREASURY SVCS PLC COUNTERPARTY_TYPE = BANK COUNTRY = UNITED KINGDOM COUNTERPARTY_ADDRESS = NULL SOURCE_PRODUCT_TYPE = INTERBANK MM LOAN ASSET SOURCE_PRODUCT = PLACEMENTS SOURCE_PRODUCT_SUB_TYPE = MML STT_RATING = NULL SHORT_LIMIT = NULL LONG_LIMIT = NULL OUTSTANDING = 100000000 TRADE_DATE = 2006-06-21 SEC_ISSUE_DATE = NULL SEC_COUNTRY_OF_ISSUE = NULL MATURITY_DATE = 2007-06-26 SETTLEMENT_DATE = 2006-06-26 REPRICING_DATE = NULL REPRICING_BASE = FI REPRICING_FREQUENCY = NULL INT_PMT_DATE = NULL INT_PMT_TERM = NULL ACCRUED_INTEREST = 2351835.62 CURRENCY = GBP INTERNAL_COMPANY_FLAG = 0 NOTES = NULL PRIN_GL_NUM = NULL ACCR_INT_GL_NUM = NULL STT_UNIT = 0097 BUSINESS_UNIT = NULL ACCRUAL_CODE = ACT365 INTEREST_AT_MATURITY = 5020000 INTEREST_RATE = 5.02 INSTRUMENT_STATUS = NULL ASSET_LIABILITY_CODE = A CITY = LON PARENT_NUM = 00009103942 PARENT_NAME = BANK OF SCOTLAND TSY SV GLASGOW PARENT_FUND_NUM = NULL SWIFT_ID = BOFSGB22XXX CUSIP = NULL PAR_VALUE = NULL TRADE_PRICE = NULL MCH_FUND_NUM = NULL FILE_NAME = NULL RATING_MOODY = NULL RATING_STDPOOR = NULL UNREALIZED_PL_GL_NUM = NULL FCS_GL_NUM = NULL PRODUCT_TYPE_ID = 14 OUTSTANDING_USD_EQVL = 196595000 INTEREST_AT_MATURITY_USD_EQVL = 9869069 ACCRUED_INTEREST_USD_EQVL = 4623591.237139 CALC_EXCHANGE_RATE = 1.96595 CRITICAL_ERROR_FLAG = N RDR_INCLUDE_FLAG = Y RDR_PROCESSED_FLAG = N ERR_ASST_LBLTY_NULL = N ERR_ASST_LBLTY_INVALID = N ERR_SRC_ACCT_NUM_NULL = N ERR_OUTSTANDING_NULL = N EXCL_LIABILITY = N EXCL_CLOSED_MATURED = N EXCL_FUTURE_DATED = N
so what will be the problem..is the prblem is with the record..
skf
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is that the entire error/warning message? There's nothing in what you've posted that helps, unless one of the columns that has NULL as its value is defined as not nullable.
What was the result of resetting the job?
What was the result of resetting the job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.