table name required

tostay2003 · Post by **tostay2003** » Thu Mar 23, 2006 3:07 pm

I keep getting this error.

Table Name is a required link property for Link XYZ.

I have the setup this way :

a) both oracle stages are linked to Tranformer as lookup
b) I am getting the error for oracle stage 1

OracleStage1 -----> Aggregator -------> OracleStage2
| |
| |
| |
TRANSFORMER

I have checked the oracle stage1, the table name exists. what could be the possibility. Even checked in the aggregator. Dont know where i am going wrong?

tostay2003 · Post by **tostay2003** » Thu Mar 23, 2006 3:08 pm

I didnt get the figure, properly. The two veritcal lines are one for each oracle stage

tostay2003 · Post by **tostay2003** » Thu Mar 23, 2006 3:10 pm

Also theres a warning message which states that,

Attempting to Cleanup after ABORT raised in stage OracleStage1

tostay2003 · Post by **tostay2003** » Thu Mar 23, 2006 3:31 pm

I got the problem. Sorry to trouble. I wasnt builidng the SQL query for both the Links of OracleStage1. I was doint it only for one i.e the link to the transformer. I didnt build SQL query for the link going to aggregator stage.

Thanks for bearing

I_Server_Whale · Post by **I_Server_Whale** » Thu Mar 23, 2006 3:32 pm

Good job! And thanks for getting back and letting us know.

Naveen.