My Oracle Support Banner

Data Integration Platform Cloud "bad SQL grammar" Error when Trying to Run Data Preparation Task on Schema Owned by SYS (Doc ID 2487244.1)

Last updated on APRIL 29, 2019

Applies to:

Data Integration Platform Cloud Classic - Version 18.2.3 and later
Data Integration Platform Cloud - Version 18.2.3 and later
Information in this document applies to any platform.

Symptoms

This knowledge article reflects updated product names. Data Integration Platform Cloud (DIPC) was formerly known as Autonomous Data Integration Platform Cloud (ADIPC). Data Integration Platform Cloud Classic (DIPC Classic or DIPC-C) was formerly known as Data Integration Platform Cloud (DIPC). Please see KM <document 2493395.1> for the full list of recently renamed PaaS services.

The following error is received when trying to perform a Data Preparation task on a schema owned by SYS:

StatementCallback; bad SQL grammar [select OBJECT_NAME from dba_objects where object_type='DATABASE LINK' and OBJECT_NAME like 'DBLINK_CONN01%']; nested execption is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Changes

 

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
References


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