My Oracle Support Banner

OAC : "500 - Internal Server Error" When Converting String Column To Date (Doc ID 2543000.1)

Last updated on NOVEMBER 28, 2019

Applies to:

Oracle Analytics Cloud - Version 18.3.3 and later
Information in this document applies to any platform.

Symptoms

When converting string to date using "custom" format set as yyyy-MM-dd-HH.mm.ss.000000, the conversion succeeds, but shows below error in data visualization project.


Steps To Replicate 

1. Create data set using below sample data in xlsx file.

Sample Data
id time
1 2011-10-14-12.55.13.000000
2 2014-12-09-08.39.58.000000
3 2015-10-29-15.05.21.000000

 

 

 

 

 

 

 

 

 

2. Click on "Options" of time dimension column and select "convert to date"
3. Enter the custom format as yyyy-MM-dd-HH.mm.ss.000000
4. Add Step
5. Apply changes and create project to replicate the error "500 - Internal Server Error. Please try again in a few moments".

Changes

 

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.