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)

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms