DSXchange

Hi All,

When I tried to export data stage server jobs in particular category using manager, it gives error as follows..

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

But it allows to export entire project.

Can anyone advise on this please!

Your project might be corrupted. First thing is to make a UNIX backup of the project directory immediately if you haven't done that already.

Try executing the TCL command "COUNT DS_JOBS" from a shell if you know how to do that, or as a command from the DataStage Administrator. If you get a number then that is a good thing; if you get an error message please post that here for further steps. You should also try a "COUNT DS_JOBOBJECTS" if the DS_JOBS file had no errors.

Proceed with the suggestions given by Arnd, And if you manage to import the exported dsx sucessfully into another project, try to do REINDEX for DS_JOBS of the current project. This might also help.

More likely would be a need to re-index DS_JOBOBJECTS. Best is to re-index ALL. You need exclusive access to the project to run DS.REINDEX successfully.

ArndW wrote:Your project might be corrupted. First thing is to make a UNIX backup of the project directory immediately if you haven't done that already.

Try executing the TCL command "COUNT DS_JOBS" from a shell if you know how to do that, or as a command from the DataStage Administrator. If you get a number then that is a good thing; if you get an error message please post that here for further steps. You should also try a "COUNT DS_JOBOBJECTS" if the DS_JOBS file had no errors.

Hi Arnd,

I executed the above two commands successfully as you suggested. Do I need to proceed with reindexing after importing the dsx file into another project. Why shouldn't I rendex the jobs in current project without importing the dsx file.

Your subject was "unable to export", not import. Re-indexing the Repository database makes the export utility more likely to be able to find all the components. To import a successfully exported project into a different project ought not to require any re-indexing, unless that project also had a corrupted Repository.

The fact that those two main files seem to be OK and not corrupted is a good thing! Go ahead and do the DS.TOOLS reindex when nobody else is in DataStage and chances are very good that your error will disappear.