DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
nehavin
Participant



Joined: 02 Jul 2012
Posts: 2

Points: 21

Post Posted: Sun Feb 24, 2019 9:59 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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?
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42923
Location: Denver, CO
Points: 221366

Post Posted: Mon Feb 25, 2019 2:22 am Reply with quote    Back to top    

Welcome. It would probably be helpful if you shared the actual abort / error message with us.

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54501
Location: Sydney, Australia
Points: 295558

Post Posted: Wed Feb 27, 2019 4:23 pm Reply with quote    Back to top    

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 ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
mouthou
Participant



Joined: 04 Jul 2004
Posts: 193

Points: 1874

Post Posted: Mon Mar 11, 2019 11:41 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours