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 and later
Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


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 and TimesTen was upgraded to


 Upgraded OBIEE to version and TimesTen to version


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