Problem with a transformer stage

plazanet · Post by **plazanet** » Tue Nov 30, 2004 7:38 am

I have a job which load ten files in a database.
But for two days (without any change) I have a problem with the beginning of the job:
For all trasformer, I have in the log this line:
PCchp9:Tranformer_5 (or another number) :DSD.StageRun Active stage starting, tracemode = 0.

exept for one transformer.
The link of this transformer stay blue (waiting data) and the job never stop.

can somebody help me?

thanks

kcbland · Post by **kcbland** » Tue Nov 30, 2004 7:57 am

Can you please describe what the link is doing? Is it reading a file and loading a table? If it is sitting and spinning it could be a metadata issue - it's trying to interpret the file and can't read a row because the definition of a row is fouled. It could be that the database is busy getting ready to run the load query, is there a DELETE statement executing that you're waiting on?

Unless you tell us what your job is doing, we have NO CLUE what to look at.