Error calling subroutine

Rubu · Post by **Rubu** » Tue Apr 19, 2005 5:34 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Apr 19, 2005 6:34 am

Check whether the dir pointed by UVTEMP in your uvconfig (generally /tmp) is full.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2005 5:48 pm

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

Rubu · Post by **Rubu** » Tue Apr 19, 2005 7:47 pm

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

Ray, Thanks a lot.

It solved the problem. can you please put some more light on it. Why it is necessary to REINDEX ALL?

Regards
rubu

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2005 9:12 pm

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.