Fatal Error with the message key value already kept

VARUN · Post by **VARUN** » Tue Dec 05, 2006 12:17 am

Hi,
I am facing an weired error with out giviing much information for debugging.
Job is aborting by displaying the message:
Fatal Error: Source CLCL_ID is already kept

The job was ran perfectly for the first time, and when i try running once again it is throwing this error even while validating the job.

Please suggest me how to resolve this. The job is fetching the data from a dataset and with the help of lookup on sybase table loading the data to the target dataset.

Thanks,
Saka

kumar_s · Post by **kumar_s** » Tue Dec 05, 2006 12:57 am

Is it all the message you get? Are you sure that there is no change after the first run and the second? Is CLCL_ID a field or a name of the stage? Will it allow you to do a force compile?

VARUN · Post by **VARUN** » Wed Dec 06, 2006 5:36 am

Hi,
CLCL_ID is the key field on which the joining condition is defined in the lookup transfromation.
Job is compiling successfully, but while running or validating then the job is abrting with this message.

appreciate ur help.

Thanks,
Saka

ray.wurlod · Post by **ray.wurlod** » Wed Dec 06, 2006 7:42 pm

Please post the full detailed text of the log message, including the stage name and partition number.

bvishwanathr · Post by **bvishwanathr** » Sun Mar 18, 2007 10:08 pm

Hi,

I'am also facing the same kind of a problem. Following is the error message we get :
"main_program: Fatal Error: Source "DC_TRLR_D" is already kept."
Till date we havenot seen this error in our development region , the same job runs fine in our production environment.
Even if i import the same job from production onto my developmet server/region it throws me this error.

Can any one tell when exactly we get these kinda messages ?