Problem in exporting job by category

legendkiller · Post by **legendkiller** » Sun Mar 12, 2006 11:23 pm

Hi,

I am getting error while trying to export job from manager by category option.

here error is coming for one particular project only and when export is by category.( I am able to export the individual job for same project) even dsadm usedid is throwing same error.

Is this is problem related to project settings.

error - error caling subroutine Datastage DSR_SELECT( Action =7); check the datastage is set up curretly in project ( subroutine failed to complete successfully(30107))

rasi · Post by **rasi** » Mon Mar 13, 2006 12:21 am

Hi

Your problem mostly releates to repository. Do a search on this forum there are number of posts covered for this problem.

kumar_s · Post by **kumar_s** » Mon Mar 13, 2006 1:17 am

If you are able to export all the jobs in the Category individually and if not as category, then reindexing your project should work.

legendkiller · Post by **legendkiller** » Mon Mar 13, 2006 3:26 am

I will also like to know that what exactley re-indexing will do and how to do it

ArndW · Post by **ArndW** » Mon Mar 13, 2006 3:49 am

If a DataStage hashed file/table has an index on a column, any SELECTs that use that column as part of the selection criteria will use the index. If the index has somehow become corrupt or invalid, a SELECT on that file will return incorrect rows even though the file itself contains the correct information. You can reindex your project using the DS.TOOLS command line menu from TCL or from the Administrator.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 13, 2006 5:57 am

Reindex merely rebuilds the database indexes on your Repository database.

legendkiller · Post by **legendkiller** » Mon Mar 13, 2006 11:17 pm

Hi All,

Thanks for all the responses. I have never done this before so just i want to know some more things before i do this

1) Is this re-indexing is done for one particular project. I have 3-4 different project and problem that i have mentioned is coming for only one project.

2) If it can be done only for particular project then is there is impact on other projects.

3) What types of steps i need to follow before starting re-indexing for project. ( Do i need to ensure that all connection to particular project or datastage are closed).

4) Finally where can i find help on DS.TOOl utility so that i can get connand for re-indexing

kumar_s · Post by **kumar_s** » Mon Mar 13, 2006 11:43 pm

Yes, you need to make sure all the connection are closed.
Reindexing is proejct oriented. So reindexing one project wont affect other.
AS mentioned, you can find the the DS.TOOLS under the administrator client window.
Use dsadm for this purpose.
Goto project tab in the administrator client, select the required project. Click on the Command button. Type in DS.TOOLS and Execute. You would get the list of items ot be entered. Type 2.