PFTBI Aggregate Data Task Fails with 'No Records in the Dataset OR Invalid Dataset' Error (Doc ID 1520841.1)

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)

Symptoms

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.

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