Using Surrogate Key generator-Job Aborted

[sanjayS]

Hi,

Am trying to generate a sequence of numbers starting from 1 by using surrogate key generator stage.

Am having an input column as Emp_Name and in output i need Emp_name numbered as 1,2,3....

The job looks like

Input----Surrogatekeystage-----output

When running,the job gets aborted with log

Could not find key state file Emp_Name
The runLocally() os the operator failed

PLease clarify..

Thanks,
Sai.

[ray.wurlod]

The pathname you have given for the state file does not refer to an existing state file.

You do need to create/initialize a state file for each surrogate key. Have you done that?

[sanjayS]

Thanks Ray..

I didnt created separate file to store the values....

Now its working fine..

Thanks
sai.