Hi
Suddenly we started getting the following error in all the projects. Please Help.
Error:
Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project gref300_phII_synch
(Subroutine failed to complete successfully (30107))
Regards
rubu
Error calling subroutine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Given that the helper subroutine was DSR_SELECT, check also that the indexing in the Repository is completely up to date. At a time when you have exclusive access to the project, execute DS.REINDEX ALL (from a dssh environment on the server or through the Administrator client Command window).
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.
Ray, Thanks a lot.ray.wurlod wrote:Given that the helper subroutine was DSR_SELECT, check also that the indexing in the Repository is completely up to date. At a time when you have exclusive access to the project, execute DS.REINDEX ALL (from a dssh environment on the server or through the Administrator client Command window).
It solved the problem. can you please put some more light on it. Why it is necessary to REINDEX ALL?
Regards
rubu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's probably not necessary to reindex all tables, but it's quicker than wading through the repository database for the project trying to figure out which of them needs reindexing.
If you'd told us which branch of the repository you had selected, and from which DataStage client, the answer probably could have been narrowed down somewhat.
If you'd told us which branch of the repository you had selected, and from which DataStage client, the answer probably could have been narrowed down somewhat.
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.