Page 1 of 1
Surrogate Key stage issue
Posted: Sun Feb 24, 2019 9:59 pm
by nehavin
We recently migrated the OS from Sun Solaris to some Linux version. However, all jobs using the surrogate key tab in transformer are aborting. There are over 600 odd jobs. The source is specified as file. Is there something we missed or the only way to fix the issue is recreate the surrogate key source file and execute the jobs again?
Posted: Mon Feb 25, 2019 2:22 am
by chulett
Welcome. It would probably be helpful if you shared the actual abort / error message with us.
Posted: Wed Feb 27, 2019 4:23 pm
by ray.wurlod
Did you migrate the SK state file? It's likely there's some kind of incompatibility (possibly something as simple as byte order).
My advice would be to re-create the SK state file. You can get the values from the old system and initialize the state file with those.
Re: Surrogate Key stage issue
Posted: Mon Mar 11, 2019 11:41 pm
by mouthou
Assuming that your migration included the surrogate key files to new Linux platform, couple of things you could check:
1. if the files have been moved by the deployment team properly (as these are binary files) without errors
2. if the files have got any unusual permission attributes for making it inaccessible
As chulett said, the errors which you get in job failure will only give us some idea.