Running OBIEE 11g NQCMD On Oracle Exalytics To Refresh TimesTen Aggregates Fails With Error: "[OracleBIServerComponent] [ERROR:1] [] [] ... [nQSError: 84003] [Aggregate Persistence] Checkin failed." (Doc ID 1540481.1)

Last updated on MARCH 29, 2013

Applies to:

Oracle Exalytics Software - Version 1.0.0.2.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.6.8 and later
Information in this document applies to any platform.

Symptoms

Environment includes recently upgraded Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and TimesTen (TT) 11g products on an Oracle Exalytics server. 
Created TT aggregates successfully by running the "create aggregates" script via NQCMD. A global consistency check is run on the repository (RPD) and also completes successfully. 
If the "create aggregates" script is run again, it fails while running the "delete aggregates" clause and the following errors are reported in the NQServer.log:

[2013-03-13T13:45:39.000+01:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004pwr6PT2BCCw85njH7iZ0006Yt0004jX] [tid: 4508f940] : [nQSError: 84003] [Aggregate Persistence] Checkin failed.

This issue can be reproduced using the following steps:

  1. Build aggregates in TT by running the "create aggregates" script via the OBIEE 11g nqcmd.
  2. After the aggregates have been successfully created, check for the global consistency of the RPD and save it.  There are no errors.
  3. Re-run the "create aggregates" script  and it fails with the error listed above.

This problem did not occur until OBIEE was upgraded to version 11.1.1.6.8 and TimesTen was upgraded to 11.2.2.4.1

Changes

 Upgraded OBIEE to version 11.1.1.6.8 and TimesTen to version 11.2.2.4.1.

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