OBIEE 12c: NQSSERVER Cache Seeding Issue (Doc ID 2231313.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.1.0 to 12.2.1.2.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) , 12c,

NQSSERVER cache is enabled but for first run of the report to seed cache, it fails with below error message captured in report session log

Query Result Cache: [59123] The query for user 'xxxx' was not inserted into the query result cache.
Additional information (if any): '[nQSError: 52061] The cache entry, /ORACLE_HOME/user_projects/domains/DOMAIN_NAME/servers/obis1/cache/NQS__xxxxxx_xxxxx_xxxx.TBL, has been corrupted;
could not finish the operation in Local row count mismatch. We have attempted to remove this entry. Please re-issue your query. If the problem persists, please restart OBIS to resolve the issue.'.

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