My Oracle Support Banner

OCI Database Management Service : Generate Active Session History Report Throws - Internal Error (Doc ID 2923672.1)

Last updated on JANUARY 13, 2024

Applies to:

OCI Database Management Service - Version NA to NA [Release NA]
Information in this document applies to any platform.

Symptoms

In a PDB Database Home Page, While trying to generate the AWR, Performance Hub Reports from Performance Hub --> Reports page. The Report generated works without issues.

But for the “Generate Active Session History Report”, the download button is greyed out as shown below:

Clicking on Cancel, closes the window. But throws the following exception:

QueryExecutionFailed: IO Error: The Network Adapter could not establish the connection query key: <Query Key> request Id: <Request ID> error code: dbmAwrSqlExecErr

Captured the HAR file during this operation. Following exception is seen:

awrDbSnapshotRanges

{
"code" : "InternalError",
"message" : "QueryExecutionFailed: IO Error: The Network Adapter could not establish the connection query key: <query key> request Id: <Request ID> error code: dbmAwrSqlExecErr"
}

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.