Surrogate Key stage issue
Moderators: chulett, rschirm, roy
Surrogate Key stage issue
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Surrogate Key stage issue
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.
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.