DSXchange

Posted: **Fri Aug 26, 2011 4:12 am**

Hi guys,

I am trying to run a custom query in Oracle stage. The query is running fine in SQL developer.

So, i gave Tablename (1 of the 4 source tables). GenerateSQL is No.
Then i gave the Custom query in User-Defined SQL.
And Pre 4.2 User-defined as 'Yes'.

My metadata is matching the select clause.

But my job is aborting with the below error.

Code: Select all

Abnormal termination of stage TestCLOB_PromoStgEDWLoad..Transformer_1 detected

Can somebody help me.

Cheers!!!!!

Posted: **Fri Aug 26, 2011 5:38 am**

The problem has been reported from a stage called Transformer_1.

Maybe you're looking in the wrong place.

Posted: **Fri Aug 26, 2011 7:21 am**

And yet we all know that active stages in Server jobs report the errors regardless of what actually caused it. Was there a "From previous run..." entry added after you Reset the job?

Posted: **Fri Aug 26, 2011 4:36 pm**

I guess we need to know a little more about your job design.

DSXchange

Custom Query for Oracle Stage in 8.01

Custom Query for Oracle Stage in 8.01