Page 1 of 1
Fatal Error & Warning , while runing the Job
Posted: Tue Sep 18, 2007 1:11 am
by kimbal
Hi All
Iam runing a job in windows ,My source is In Oracle.i am using a query , THE JOB GOT ABORTED .
[b]Error as:
missing right parenthesis
and the warning as
Attempting to Cleanup after ABORT raised in stage [/b]
kindly do the needful .
Posted: Tue Sep 18, 2007 1:13 am
by Raghavendra
Can you tell us what is the query you are using.
That will help people to analyse the problem.
Posted: Tue Sep 18, 2007 1:50 am
by JoshGeorge
ORA-00907: missing right parenthesis
Cause: A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses must be entered in pairs.
Action: Correct the syntax and retry the statement.
Posted: Tue Sep 18, 2007 7:00 am
by kimbal
Thanks for your reply..
I am runing a query to change Fiscal year for my project.
Posted: Tue Sep 18, 2007 7:07 am
by chulett
Doesn't really matter what your query is, you've used user-defined sql and it is not syntactically correct. Fix it.
Posted: Tue Sep 18, 2007 4:27 pm
by ray.wurlod
Examine the SQL that was sent to Oracle, find where the missing right parenthesis ought to go, and supply it.
Posted: Tue Sep 18, 2007 4:46 pm
by say2prabhu1
First run the SQL query in Toad or SQL navigator and check whether the query is returning the rows or not.
You could have missed some comma operator in the SQL query.
Then copy the same query from TOAD and paste it in Datastage Oracle stage.