Strange Error: Invalid Month

[Deepakinstyle]

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

[ray.wurlod]

Something like that Oracle expected MM/DD/YYYY and you delivered YYYY-MM/DD ?

[Deepakinstyle]

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

[kool78]

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

what is your source file format, check the source data there should be some records which might have 1digit month or 1 digit date.