OAC: Data Sync Job Fails With "ORA-00933: SQL command not properly ended"
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:
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