Page 1 of 1

Errors during jobs import

Posted: Wed Feb 16, 2005 12:01 pm
by eoyylo
Hi,
sometime during the import of jobs in a project the next errors occurs:

Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project EBIS_REVISIONE_ARC
(Subroutine failed to complete successfully (30107))


Can anyone help to explain/avoid this problem?

thanks in advance

Ragards

Mario

Re: Errors during jobs import

Posted: Wed Feb 16, 2005 2:53 pm
by ogmios
First check your diskspace (whether you're not in a disk full condition).

Secondly try to cut your imports in smaller pieces, v5 had some problems with very big import files.

Ogmios

Posted: Wed Feb 16, 2005 8:00 pm
by ray.wurlod
You might also check the indexing in the project, since the helper subroutine was DSR_SELECT.

Posted: Thu Feb 17, 2005 1:46 am
by eoyylo
Hi,
in the HD I have eough space (about 1GB).
The file that I try to import contain about 10 - 20 jobs (job and job sequencer)

I try to clueanup the projects but it doesn't produce any result.
I try to delete and re-create the projects but it is impossible to recreate.

How can I check the index in the project? With the CLEANUP button in DataStage Administrator?

Thanks

Regards

Mario

Posted: Thu Feb 17, 2005 4:13 am
by ray.wurlod
You attempt to delete and re-create the project may have left things in an inconsistent state. You must have Administrator rights to do this. This problem is addressed in a different thread.

Assuming your project is intact, use the command

Code: Select all

DS.REINDEX ALL 
to re-build all the indices in the Repository. You must have exclusive access (and be logged in with Administrator rights) to do this.