Oracle Exalytics: Aggregate Persistence Script Fails With Error "TT15100: User EXALYTICS lacks privilege ADMIN"
Last updated on MARCH 20, 2015
Applies to:Oracle Exalytics Software - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 to 18.104.22.168.7 [Release 11g]
Oracle TimesTen In-Memory Database - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 11.2]
Information in this document applies to any platform.
- You use Oracle Exalytics with TimesTen (TT) database.
- You want to create an aggregate table on the TT server
- The TT connection pool is set in the OBIEE Repository (RPD).
- Aggregate persistence wizard completes and an aggregation script is created. However, when trying to run the aggregate creation script via the nqcmd command, it fails with following error:
[State: S1000] [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
Statement preparation failed
The NQServer log shows additional errors:
[nQSError: 16001] ODBC error state: 28000 code: 15100 message: [TimesTen][TimesTen 188.8.131.52.1 ODBC Driver][TimesTen]TT15100: User EXALYTICS lacks privilege ADMIN -- file "comp.c", lineno 7762, procedure "sbPtCheckPrivs"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms