My Oracle Support Banner

How to Troubleshoot Empty ARF Datawarehouse Tables (Doc ID 1611113.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle ATG Web Commerce Business Intelligence - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

The reporting tool (OBIEE or Cognos) displays no data of a certain type.

The datawarehouse SQL tables have no data in them, or the row count does not grow as expected for the volume of site traffic.

The loader queue does not pick up log file information automatically from the temporary directory created on the loader server instance.

Cause

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
Symptoms
Cause
Solution
 Are the correct application modules included in the build of the Production servers?
 Are the log files continuing to grow?
 Is the shared fileystem for log files accessible by the Loader server?
 Do the log files ever rotate so that smaller log files with datestamps in the file names are written?
 If you run the rotate() method on a FileLogger component manually, are the log files added to queueEntry items?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.