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.
Search found 2 matches
- Thu Jan 31, 2013 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "Unable to open state file ... No such file or director
- Replies: 2
- Views: 1919
- Wed Jan 30, 2013 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "Unable to open state file ... No such file or director
- Replies: 2
- Views: 1919
"Unable to open state file ... No such file or director
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 &quo...