DSXchange

I am using two Surrogate Key Generators (SKG) to create/update SK's from two database tables.


If I use two jobs for each table, and run them one after another, both of the two jobs run OK.

But if I simply put the two jobs into one job (they are not connected to each other in anyway), I will get "Unable to open state file ... No such file or directory" error.

The two jobs do not share anything. The write to different files under the same directory.

What could be the cause of the error?
Thanks!

Welcome aboard.

Is either of the SKG stages configured to use state file? If so, are they both attempting to use the same state file?

Thanks.


No. The state files are in the same directory but have different names, ProdDim and StoreDim.

And if I replace the two Surrogate Key Generator stages with two sequential files stages, the job also runs without any problem.