My Oracle Support Banner

OAC: Adding Connection Scripts To The Connection Pool in the RPD Causes the Subject Area To Fail With '[JDSError : 77] 17,021 : Missing defines - Cause: SQLException is thrown from the datasource Action' (Doc ID 2442262.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud - Classic - Version 17.1.3 to 105.4.0 [Release 17 to 105.3]
Oracle Analytics Cloud
Information in this document applies to any platform.


You have few connection scripts defined in the connection pool for an RPD that you have loaded in Oracle Analytics Cloud (OAC).

The subject area associated with the connection pool failed with the below error:


When you remove the connection scripts, you are able to see data in the report.


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

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