OBIEE 12c: Reports Failing With "[nQSError: 52061] The cache entry /.../obis1/cache/NQS__XXXX.TBL, has been corrupted" While Seeding Cache First Time
(Doc ID 2231313.1)
Last updated on JULY 17, 2021
Applies to:Business Intelligence Server Enterprise Edition - Version 22.214.171.124.0 to 126.96.36.199.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.'.
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