Exalytics Summary Advisor Statistics Generator Fails With Error: "nQSError: 13038 The user does not have impersonation privilege" (Doc ID 1497798.1)

Last updated on OCTOBER 14, 2016

Applies to:

Oracle Exalytics Software - Version 1.0.0.0.0 to 2.0.0.0.0 [Release 1.0 to 2.0]
Business Intelligence Server Enterprise Edition - Version 11.1.1.6.2 BP1 to 11.1.1.9.5 [Release 11g]
Linux x86-64

Symptoms

When using Oracle Exalytics and Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Admin Tool to generate statistics for aggregates in Summary Advisor,
the following errors are encountered:

[NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested  connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 13038] The user does not have impersonation privilege.
[nQSError: 98058] Summary Advisor statistics generation stopped.

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