OBIEE 12c - Data Cache not populating

Mark.Thompson

Something is behaving differently for me between 11g and 12c in terms of caching.  Can't quite figure out what it is.  Running OBIEE 12c on Windows 2008 Server.

I see ENABLE = YES in NQSConfig.ini.  When I'm connected to the repository in online mode, Manage>Cache is available, so caching is, in fact, enabled.

All tables in the physical layer are tagged as Cacheable.  All of their corresponding Alias tables are set to honor the default of their source table.

However, running an analysis - any analysis - does not populate the data cache.  Whether the analysis has fact columns only, dimension columns only, or fact and dimension columns together, it doesn't matter.  Manage>Cache in the repository shows 'no cache entries'. 

This exact set of steps populates the data cache in 11g, but not in 12c.

Thoughts?

SriniVEERAVALLI

in em do you see Cache enabled is checked at Capacity Management?

Mark.Thompson

Yes, it is checked.  (Incidentally, in 12c Oracle moved that option.  It is now located under Configuration > Performance.  The "Capacity Management" tab appears to have been removed in 12c.)

SriniVEERAVALLI

How about DATA_STORAGE_PATHS?

Mark.Thompson

Looks like DATA_STORAGE_PATHS is the usual "cache" 500MB.  The cache section of NQSConfig.ini is included here.

ENABLE = YES;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

# A comma separated list of <directory maxSize> pair(s).

# These are relative to the process instance directory.

#   e.g. DATA_STORAGE_PATHS = "nQSCache" 500 MB;

#   resolves to

#   $(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent/<instance_name>/nQSCache

DATA_STORAGE_PATHS = "cache" 500 MB; 

MAX_ROWS_PER_CACHE_ENTRY = 100000;  # 0 is unlimited size

MAX_CACHE_ENTRY_SIZE = 20 MB;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

MAX_CACHE_ENTRIES = 1000;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

POPULATE_AGGREGATE_ROLLUP_HITS = NO; 

USE_ADVANCED_HIT_DETECTION = NO; 

(If anyone from Oracle is monitoring, the description of the default cache path is wrong in NQSConfig.ini.  It was not changed to reflect the new default path in 12c.  The snippet from NQSConfig.ini shown above is from a generic 12c installation.)

Mark.Thompson

Srini, may I assume from your questions that caching in OBIEE 12c is working normally for you?

rmoff

Have you tried setting LOGLEVEL=2 and checking the BI Server query log for evidence of cache hit/creation? What about running with DISABLE_CACHE_SEED=0 as a request variable? Can you post the excerpt of the query log for an execution?

Mark.Thompson

I already had LOGLEVEL=2.  I ran a query for the purpose of including the session log here and wouldn't you know it...

That query hit the cache.  I don't know why.  I have not changed any of the caching settings.  I don't recall changing anything else either.  Go figure.

Poltergeists, I suppose.  I'll keep an eye on it and post back here if I can find a clear pattern in the next few days.

Mark.Thompson

Srini and rmoff, thank you for your replies.  I appreciate the help.