OBIEE 12c: NQSSERVER Cache Seeding Issue
Last updated on JULY 17, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 12c]
Information in this document applies to any platform.
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:  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.'.
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