Hi All,
I got an error while loading data to table.
below am copying the error from the log
Stage_IBTLoan,1: Open failed for update:
update is: INSERT
INTO
STAGE_IBT_LOAN
(IBT_LOAN_SQ,CALENDAR_DT, IBT_CTPY_ID, IBT_POS_TYPE_CD, IBT_ISSUE_CTRY_CD, IBT_TRADE_CTRY_CD, IBT_MAT_DT, IBT_COLL_CCY_ID, IBT_SEC_ID, IBT_SEC_ID_TYPE, IBT_SEC_CLASS_ID, IBT_IDN_FLG, IBT_CONTRACT_AMT, IBT_MKT_VAL_AMT, IBT_AS_OF_DT, IBT_SETTL_DT, IBT_LM_TRAN_NO, IBT_LM_COLL_LOAN_NO, IBT_FUND_ACCT_NO, IBT_REBATE_RT, IBT_SETTLE_CD, IBT_COLL_CD, IBT_BUS_LINE_CD, LOAD_STATUS_CD)
VALUES
( :IBT_LOAN_SQ, :CALENDAR_DT, :IBT_CTPY_ID, :IBT_POS_TYPE_CD, :IBT_ISSUE_CTRY_CD, :IBT_TRADE_CTRY_CD, :IBT_MAT_DT, :IBT_COLL_CCY_ID, :IBT_SEC_ID, :IBT_SEC_ID_TYPE, :IBT_SEC_CLASS_ID, :IBT_IDN_FLG, :IBT_CONTRACT_AMT, :IBT_MKT_VAL_AMT, :IBT_AS_OF_DT, :IBT_SETTL_DT, :IBT_LM_TRAN_NO, :IBT_LM_COLL_LOAN_NO, :IBT_FUND_ACCT_NO, :IBT_REBATE_RT, :IBT_SETTLE_CD, :IBT_COLL_CD, :IBT_BUS_LINE_CD, :LOAD_STATUS_CD)
sqlcode is: -1843
esql complaint: ORA-01843: not a valid month
Let me know what caused this error?
thanks & regards,
Deepak
Strange Error: Invalid Month
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
what is your source file format, check the source data there should be some records which might have 1digit month or 1 digit date.Deepakinstyle wrote:Hi Ray,
thx for the reply.
but am able to run it for soem 1000 records, getting this problem only when i tried run with whole file which has around 25k records.
regards,
Deepak
"Attitude always and almost determines the altitude of your Life"