Surrogate key stage in MPP system.

seanc217 · Post by **seanc217** » Fri Oct 17, 2008 8:52 am

Hi All,

I am having an issue when running my job on a 2 node system.
When I first ran the job it complained that it could not find the state file. I changed my config file to run on one node and it worked OK.

I figured it was complaining because it could not see the state file on the other node. So I nfs mounted the surrogate key directory on the second node so that the state file is visible to the second node. Now when I run my job I get an error: "Unable to lock state file <path to file here>: No locks availble."

Does any one have an idea how to implement surrogate keys on an MPP system?

Thanks!

seanc217 · Post by **seanc217** » Fri Oct 17, 2008 9:31 am

I have opened a ticket with support I will update this post when I get a resolution.

Thanks!