Custom Query for Oracle Stage in 8.01

[mac4rfree85]

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!!!!!

[ray.wurlod]

The problem has been reported from a stage called Transformer_1.

Maybe you're looking in the wrong place.

[chulett]

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?

[ray.wurlod]

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