My Oracle Support Banner

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.

Symptoms

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

MESSAGE:::
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
...

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.