Fatal Error & Warning , while runing the Job

kimbal · Post by **kimbal** » Tue Sep 18, 2007 1:11 am

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 .

Raghavendra · Post by **Raghavendra** » Tue Sep 18, 2007 1:13 am

Can you tell us what is the query you are using.
That will help people to analyse the problem.

JoshGeorge · Post by **JoshGeorge** » Tue Sep 18, 2007 1:50 am

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.

kimbal · Post by **kimbal** » Tue Sep 18, 2007 7:00 am

Thanks for your reply..

I am runing a query to change Fiscal year for my project.

chulett · Post by **chulett** » Tue Sep 18, 2007 7:07 am

Doesn't really matter what your query is, you've used user-defined sql and it is not syntactically correct. Fix it.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 18, 2007 4:27 pm

Examine the SQL that was sent to Oracle, find where the missing right parenthesis ought to go, and supply it.

say2prabhu1 · Post by **say2prabhu1** » Tue Sep 18, 2007 4:46 pm

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.