Last updated on JANUARY 23, 2013
Applies to:Oracle Financial Services Profitability Analytics - Version 5.6 to 5.6 [Release 5]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 to 7.2.12 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
For Oracle Financial Services Profitability Analytics (PFTBI) 5.6, you are running the Cube Build process. The Batch fails on the Aggregate Data task. The following error is listed in the DataCruncher_xxxxxx_1_Task1.log from $FIC_DB_HOME/log/dc:
2012-11-14 | 01:02:58 | dc | INFO | | | Before Fetching data -- Start -- 1:2:58
2012-11-14 | 01:02:58 | dc | WARN | | | No Records in the Dataset OR Invalid Dataset
2012-11-14 | 01:02:58 | dc | WARN | | |
2012-11-14 | 01:02:58 | dc | SEVERE | | | Processing failed for Dataset DSPMRP02
2012-11-14 | 01:02:58 | dc | SEVERE | | | Error : Batch Processing Failed
2012-11-14 | 01:02:58 | dc | SEVERE | | | While Cube Processing : Task aborted 0
The error causes the Aggregate Data task to fail and stops the Cube Build.
Steps to Reproduce:
1. Go to Operations > Batch Maintenance
2. Create a new Batch
3. Create a new Task under the Batch with the following:
Components = Aggregate Data
Cube Parameter = PFACPLPR
4. Go to Batch Execution and run the Batch
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