Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error at 10 - Control - BUDGET_DATA - delete previous check sum

695999Feb 1 2011 — edited Feb 1 2011
Hi -
I am trying to load flat file into oracle table using KMs (LKM FILE to SQL, IKM SQL Control Append and CKM Oracle).

Its a truncate and load process. I have set Truncate table option as 'Yes'.

But my process fails at the step 10 - Control - BUDGET_DATA - delete previous check sum

Description in the step is

delete from Exception getObjectNameDefaultPSchema("L", "SNP_CHECK_TAB", "W") :
where SCHEMA_NAME = 'ODI_STAGING'
and ORIGIN = '(13020)RFS_BUDGET.int FILE TO ORA BUDGETDATA'
and ERR_TYPE = 'F'


Error Reason is

933 : 42000 : java.sql.SQLException: ORA-00933: SQL command not properly ended

java.sql.SQLException: ORA-00933: SQL command not properly ended

-App
This post has been answered by Ankit J on Feb 1 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2011
Added on Feb 1 2011
#business-intelligence-applications, #data-integrator, #system-management-and-integration
6 comments
551 views