OAC: Data Sync Job Fails With "ORA-00933: SQL command not properly ended"

(Doc ID 2373143.1)

Last updated on MARCH 14, 2018

Applies to:

Oracle Analytics Cloud Service - Version 17.4.5 and later
Oracle Business Intelligence Cloud Service - Version 17.4.5 and later
Information in this document applies to any platform.


You are executing a load job but it fails.  In the task log (under <DATASYNC_HOME>/log/<JOB_NAME>.<PROCESS_ID>) you see:

Irrecoverable Error
Running Custom Sql list Delete All Current Data INSTANCE 1

executing sql (Delete curr data from Prod Ship:TARGET)
delete from <schema_name>.<table_name> where <filter>;

"Delete curr data from Prod Ship" failed on "TARGET"
SQL: delete from <schema_name>.<table_name> where <filter>;
Error: MESSAGE:::ORA-00933: SQL command not properly ended

EXCEPTION CLASS::: java.sql.SQLSyntaxErrorException

Execution of custom sql file failed.

EXCEPTION CLASS::: com.siebel.analytics.etl.etltask.IrrecoverableException


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