Oracle Exalytics: Aggregate Persistence Script Fails With Error "TT15100: User EXALYTICS lacks privilege ADMIN"
(Doc ID 1531823.1)
Last updated on MARCH 31, 2019
Applies to:Oracle Exalytics Software - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0 to 220.127.116.11.7 [Release 11g]
Oracle TimesTen In-Memory Database - Version 18.104.22.168.0 to 22.214.171.124.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 126.96.36.199.1 ODBC Driver][TimesTen]TT15100: User EXALYTICS lacks privilege ADMIN -- file "comp.c", lineno 7762, procedure "sbPtCheckPrivs"
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