OAC: "[JDSError : 120] Unauthorized Keyword In SQL Statement Blocked By Agent Security Policy" Error While Using RDG
(Doc ID 2662371.1)
Last updated on NOVEMBER 09, 2023
Applies to:
Oracle Analytics Cloud - Version N/A and laterInformation in this document applies to any platform.
Symptoms
After successfully installing and configuring Remote Data Gateway (RDG) in OAC console and when attempting to create a connection from OAC to database you get the following type error which can be seen in the RDG log file:
<timestamp> ERROR datasource:122 - Unauthorized keyword in SQL statement blocked by agent security policy
<timestamp> ERROR datasource:122 - STATEMENT_DOES_NOT_MATCH_REGEX_PATTERN [JDSError : 120] Unauthorized keyword in SQL statement blocked by agent security policy
Cause - Unauthorized keyword in SQL statement blocked by agent security policy
Action - Please contact system adminsitrator for the required access.
oracle.bi.datasource.agent.util.Validator.isStatementValid(Validator.java:48)
oracle.bi.datasource.agent.util.Validator.isValid(Validator.java:27)
oracle.bi.datasource.agent.executor.JobExecutor.executeRDataJob(JobExecutor.java:94)
oracle.bi.datasource.agent.executor.JobExecutor.run(JobExecutor.java:273)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Changes
None
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 |
| Changes |
| Cause |
| Solution |