OAC: Data Sync Job Fails With "ORA-00933: SQL command not properly ended"
(Doc ID 2373143.1)
Last updated on OCTOBER 17, 2019
Applies to:Oracle Analytics Cloud - Classic - 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
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