My Oracle Support Banner

Error "String Was Not Recognized as a Valid Datetime" When Drilling To DATETIME In Active Data Cache. (Doc ID 791398.1)

Last updated on MARCH 27, 2020

Applies to:

Oracle BAM (Business Activity Monitoring) - Version to [Release AS10gR3]
Information in this document applies to any platform.
This problem can occur on any platform.


When you try to drill down details using + sign, after drilling down to hierarchy on a DATE field, the following error occurs:

"String was not recognized as a valid DateTime"
  1. The date field is defined as DATETIME on Active Data Cache and Dimension/Hierarchy is created based on the DATETIME field.
  2. 1st level display the details OK and after getting down to next level using the hierarchy and displaying details at the 2nd level generates the error.


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

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