(40521) Unable to retrive the link details for the stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
badhri
Participant
Posts: 42
Joined: Tue Mar 19, 2002 8:15 pm

(40521) Unable to retrive the link details for the stage

Post by badhri »

Greetings,

When i open the job it throws up some error message like "Record <> in file DS_JOBOBJECTS does not exist". And finall it throws up the error message "(40521) Unable to retrive the link details for the stage"

PLease let me know if you have encounted this and the corrective action.

Thanks,
Badhri ...
Badhrinath Krishnamoorthy
www.cognizant.com
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Post by mandyli »

Hi Badhri,


are you using any of DS_LINKRow count routine in your job..


Thanks
Man
badhri
Participant
Posts: 42
Joined: Tue Mar 19, 2002 8:15 pm

Post by badhri »

No, is a simple job with simple transformations. No routines are used.

Badhri ...
mandyli wrote:Hi Badhri,


are you using any of DS_LINKRow count routine in your job..


Thanks
Man
Badhrinath Krishnamoorthy
www.cognizant.com
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You have lost the record in DS_JOBOBJECTS that describes the link, but the reference to it has not been deleted from its parent object (one of the stages to which the link was connected).

If the link is one that has been deleted from the design, the correct solution is to delete the reference from the parent object (stage) record in DS_JOBOBJECTS. Alas there is no utility for effecting such a repair, so you will probably need to import the job from a successful export.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply