Problem with Export by Category

[gdean]

Hi,

I get the following error while trying to export jobs from datastage manager using the option 'Export by Category'.

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

This happens only with the jobs. I am able to exports all other components like the table definitions, routines etc by the "category". Also, I am able to export individual jobs successfully.

Can anybody suggest a possible solution to this?

Thank You,
Gregg

[ray.wurlod]

This could indicate that the CATEGORY index on DS_JOBS or DS_JOBOBJECTS needs re-building, or it may be a bug. What exact version are you running?
Some time when you can get exclusive access, execute the following command either through the Administrator client Command window or via a telnet session in a dssh shell.

Code: Select all

 DS.REINDEX ALL

[gdean]

Thank you Ray. We are using version 6.0 We recently created a new project and this happens only in the new project. So, before re-indexing all the users should be out of datastage?

Thank You,
Gregg

[chulett]

So, before re-indexing all the users should be out of datastage?

Yes - all users.