Routines

[laxmi_etl]

Hi-

In the repository under the routines
I have created one category in that i have written one Routine with a name test.
And I am calling that Routine in a routine activity sequence stage I am
giving that routine name it's working good.

my question is I want to edit that routine But I don't see that in the designer repository under Routines.I can see only the category i have created.

Thanks

[chulett]

Refresh the Repository Browser: View / Refresh, see if it shows then.

[laxmi_etl]

I did that somany times but still I don't see it.

[DSguru2B]

Try refreshing it. Also, is this happening only with this particular routine, or you cannot see any routines?

[laxmi_etl]

I am the only one who created .Nobody created userdefined routines here.

[sud]

well why you can't see ... I really don't know. But to edit it, open the sequence job and right click on the routine activity. Select "Edit Routine".

[DSguru2B]

Did you even save the routine. Create another routine with the name test. See if it allows you to do that, if it doesnt, then that means it exists and you just cant see it (indexing issue). Try creating one with different names and see if you can see any of them.

[laxmi_etl]

Yes, I got it.

Thank you somuch

[laxmi_etl]

Yes, I tried to do that but it's not allowing me create with the existing name.

Once I finish writing it I saved it and compiled it.


Thanks

[laxmi_etl]

If I create with different name it's allowing me to create

[laxmi_etl]

What is that indexing issue.
I am just curious

[DSguru2B]

Indexes on the repository table might be off. Thats one of the reasons you dont see routines and jobs in the repository. Search the forum for "REINDEX.ALL". Also learn when to run this command and what are the pre-requisites. Make sure you have the project backup. Search and learn.

[ray.wurlod]

Right mouse click on the Routine activity. You should be able to open the Routine by that means.