Products | Versions |
---|---|
TIBCO Collaborative Information Manager | - |
Not Applicable | - |
Resolution:
How to handle date datatype attribute/value while using dbloader
Environment:
==========
TIBCO Product name and version: TIBCO Collaborative Information Manager 7.x.x and 8.x.x
Operating System(s): All Operating Systems
Symptoms:
========
Following exception would be thrown when date datatype attribute is mapped with string datatype datasource attribute.
ID: C3E9C6EE_4369466E27AF5D780127B07D503839EF
DATETIME: 2010-03-30T20:12:34+00:00
EXCEPTIONMESSAGE: java.sql.SQLException: ORA-01861: literal does not match format string
STACKTRACE: java.sql.SQLException: ORA-01861: literal does not match format string
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:125)
at com.martquest.util.MqDebuggableStatement.executeUpdate(MqDebuggableStatement.java:388)
at com.martquest.util.MqDebuggableStatement.executeUpdate(MqDebuggableStatement.java:404)
at com.martquest.session.catalog.initialload.DBLoaderSsnBean.bulkInsetMCT(DBLoaderSsnBean.java:1414)
at com.martquest.session.catalog.initialload.DBLoaderSsn_6k4fjk_EOImpl.bulkInsetMCT(DBLoaderSsn_6k4fjk_EOImpl.java:364)
at com.martquest.session.catalog.initialload.DBLoaderBusinessDelegate.bulkInsetMCT(DBLoaderBusinessDelegate.java:131)
at com.martquest.catalog.engine.AsyncDBLoader.bulkLoadMct(AsyncDBLoader.java:583)
at com.martquest.catalog.engine.AsyncDBLoader.onAsyncCall(AsyncDBLoader.java:167)
at com.martquest.async.AsyncCallMessageListener.onMessage(AsyncCallMessageListener.java:57)
at com.martquest.messaging.MqNativeMessageListener.onMessage(MqNativeMessageListener.java:70)
at com.tibco.tibjms.TibjmsxSessionImp._submit(TibjmsxSessionImp.java:3944)
at com.tibco.tibjms.TibjmsxSessionImp._dispatchAsyncMessage(TibjmsxSessionImp.java:2197)
at com.tibco.tibjms.TibjmsxSessionImp$Dispatcher.run(TibjmsxSessionImp.java:3470)
DBERRORCODE: 1861
Cause:
=====
Resolution:
========
Map the date field as follows in the input mappings, when the value for ITEM_MASTER_BULK_LOAD.SALES_VARIANT_EFFECTIVE_DATE is the format of YYYYMMDD.
to_date(@ITEM_MASTER_BULK_LOAD.SALES_VARIANT_EFFECTIVE_DATE,'YYYYMMDD')
References:
=========