Cube Data Aggregation Fails with 'Error : ORA-01840: Input Value Not Long Enough for Date Format'
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms