My Oracle Support Banner

Cube Data Aggregation Fails with 'Error : ORA-01840: Input Value Not Long Enough for Date Format' (Doc ID 1512404.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.1 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


During an Oracle Financial Services Profitability Analytics (PFTBI) 5.x implementation, when you run the Aggregate Data and Create Cube tasks for the Cube Build, the batch fails and the following error is in the Data Cruncher log in $FIC_DB_HOME/log/dc:

2012-07-26 | 13:09:32 | dc | SEVERE | | | Error : ORA-01840: input value not long enough for date format

The following errors are in the OlapEngine log in $FIC_DB_HOME/log/olap:

2012-07-25 | 17:55:48 | olapengine | SEVERE | | | Error : Could not open file for reading while checking for datafile : /<ftpshare>/<infodom>/scripts/cube/20120725/PFACPMMR/PFACPMMR0.DAT_0
2012-07-25 | 17:55:48 | olapengine | SEVERE | | | Error : Checking for datafile for an aggregate failed
2012-07-25 | 17:55:48 | olapengine | SEVERE | | | Error : Data Files are not present

The error prevents the cube from being created.

Steps to Reproduce:

1. Go to Operations > Batch Maintenance
2. Create a new Batch
3. Create two new Tasks with the following:

Task1: Component = Aggregate Data
Task2: Component = Create Cube

4. Execute the batch in Operations > Batch Execution

The batch fails.


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.