ORA-01861: literal does not match format string

[AkBar Dar]

I get the following error sometimes, but not all the time. I have Message Broker 6.1
And, I have three date field that I am inserting this insert statement.

(0x03000000:NameValue):Text = 'INSERT INTO Database.ERROR_MESSAGES ( CREATE_DATE, REQ
UEST_TYPE, REQUEST_CLIENT, METER_NBR, ERROR_CODE, ERROR_DESC, MESSAGE_TIME, RESPONSE_DEVICEID
, RESPONSE_ERROR_MESSAGE, REQUEST_MSG_DATE ) VALUES (EV.Current_Time, MDMref.RequestType, MD
Mref.RequestClient, MDMref.RequestDeviceId.deviceId, EV.RequestError, EV.RequestMessage, EV.M
essTime, EV.ResDeviceId, EV.ResErrMsg, EV.MessReqTime ) ' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.
cpp' (CHARACTER)
(0x03000000:NameValue):Line = 333 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2321 (INTEGER)
(0x03000000:NameValue):Text = 'Root SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (C
HARACTER)
(0x03000000:NameValue):Line = 453 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'HY000' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '1861' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA
-01861: literal does not match format string' (CHARACTER)

Regards,
AkBar Dar

Telecommute Day: Wednesday

Disclaimer This e-mail, and any attached file(s), is intended solely for the use of the individual or entity to whom this e-mail is addressed and may contain information that is privileged, confidential or exempt from disclosure. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender or call UI at 203-499-2222 and delete this message immediately from any computer. Any other use, retention, dissemination, retransmission, printing or copying of this e-mail or its contents (including any attached files) is strictly prohibited.

To unsubscribe, write to LISTSERV-0lvw86wZMd9k/bWDasg6f+***@public.gmane.org and,
in the message body (not the subject), write: SIGNOFF MQSERIES
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://listserv.meduniwien.ac.at/archives/mqser-l.html