Oracle Exalytics: Aggregate Persistence Script Fails With Error "TT15100: User EXALYTICS lacks privilege ADMIN"
(Doc ID 1531823.1)
Last updated on APRIL 02, 2024
Applies to:
Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.2.0 [Release 1.0]Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 to 11.1.1.6.7 [Release 11g]
Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 to 11.2.2.4.0 [Release 11.2]
Information in this document applies to any platform.
Symptoms
- 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:
[10058][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 11.2.2.4.1 ODBC Driver][TimesTen]TT15100: User EXALYTICS lacks privilege ADMIN -- file "comp.c", lineno 7762, procedure "sbPtCheckPrivs"
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |