Errors during jobs import

[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

[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

[ray.wurlod]

You might also check the indexing in the project, since the helper subroutine was DSR_SELECT.

[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

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