My Oracle Support Banner

Timestamp getting Corrupted when Consuming Message from AQ Adapter, 'Invalid date value' (Doc ID 1607806.1)

Last updated on AUGUST 06, 2023

Applies to:

Oracle Service Bus - Version 11.1.1.7.0 to 12.1.3.0.0
Oracle SOA Suite - Version 11.1.1.7.0 to 12.1.3.0.0 [Release 11gR1 to 12c]
Information in this document applies to any platform.

Symptoms

Timestamp getting corrupted after 11g PS6 upgrade.

ACTUAL BEHAVIOR
---------------
When OSB proxy service is consuming the message through the AQ Adapter, the timestamp 2013-10-17T15:35:46.000-0500 has the wrong format where the COLON is missing in 0500.

Due to this, all of the messages are erroring out with "dateTime: error: date: Invalid date value".

Error seen in osb .out log:

 

EXPECTED BEHAVIOR
-----------------------
Expected format: 2013-10-17T15:35:46.000-05:00

Changes

 Upgrade from PS4 to PS6.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.