Error importing a job in the project

prakashsahoo · Post by **prakashsahoo** » Wed Dec 27, 2006 11:19 pm

While trying to import a job into the project we are getting the following error:

Error calling subroutine:DSR_JOB(Action=2);check DataStage is set up correctly in project xxx
(The connection is broken (81002))

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 11:30 pm

Try closing the DS Manager client and then importing the job again. If that doesn't work, you should probably try re-indexing. Using Search facility with 'DS.REINDEX ALL' would lead you in the right direction.

prakashsahoo · Post by **prakashsahoo** » Wed Dec 27, 2006 11:40 pm

I tried doing it many times but every time same error is popping up.Is there any other reason for the error

prakashsahoo · Post by **prakashsahoo** » Wed Dec 27, 2006 11:53 pm

Can you please tell me How to do reindexing and where to do?

I_Server_Whale · Post by **I_Server_Whale** » Wed Dec 27, 2006 11:57 pm

Did you try 'searching' at all? For a start, you can click this LINK.

Make sure you take all the necessary precautions.

Whale.

prakashsahoo · Post by **prakashsahoo** » Thu Dec 28, 2006 12:37 am

Can you please guide me how to do it? I have searched, but couldn't got properly how to start.

Should I have to run the command DS.REINDEX ALL in the Datastage server Project Directory?

Precautions means -

In the same server, around 8 Datastage Projects are available.
I have seen from link provided by you that, no DS Client should connect to the Server? Does it mean, no DSClient should connect to any project in the server or only to the current project where I am experiencing the problem?

Can you please tell me what other necessary precautions required?

narasimha · Post by **narasimha** » Thu Dec 28, 2006 12:54 am

Can you please guide me how to do it? I have searched, but couldn't got properly how to start.

Should I have to run the command DS.REINDEX ALL in the Datastage server Project Directory?

Check this post ArndW describes the steps

Precautions means -

In the same server, around 8 Datastage Projects are available.
I have seen from link provided by you that, no DS Client should connect to the Server? Does it mean, no DSClient should connect to any project in the server or only to the current project where I am experiencing the problem?

Its best to do a REINDEX while having exclusive access to DS.
Refer to this post

ray.wurlod · Post by **ray.wurlod** » Thu Dec 28, 2006 6:10 am

Not "best", essential. If you don't have exclusive access to the project, the reindexing process will invalidate the indexes, but not be able to rebuild them successfully.

Other users can be using other projects, but you MUST have exclusive access to any project you are re-indexing.

prakashsahoo · Post by **prakashsahoo** » Thu Dec 28, 2006 6:40 am

Thanks for information.

Can you please tell me, while executing the command DS.REINDEX ALL, whether nobody should login to the Server or any DSClient must not connect to the Server?

As I have told there are more than 8 projects setup in the same server, any one can connect to the other projects at anytime while I am executing the command.

Is it correct that no DSClient should connect to the Project where I am experiencing the problem (for which I will execute the DS.REINDEX ALL command) or no DSClients should not connect to any of the Projects in the Server or nobody (physically connected) should connected to the server.

Please clarify this (as it is in Production)

I_Server_Whale · Post by **I_Server_Whale** » Thu Dec 28, 2006 12:49 pm

ray.wurlod wrote: Other users can be using other projects, but you MUST have exclusive access to any project you are re-indexing.

This tells you that you should have exclusive access to the project you are re-indexing. So, it doesn't matter about other projects.

No DS clients should be connected to the DS Server through the project you will be re-indexing (All DataStage users must be logged out).

Now, execute the DS.REINDEX ALL command from the DSAdmin.

Whale.

chulett · Post by **chulett** » Thu Dec 28, 2006 2:27 pm

I know that Conventional Wisdom says you'll be fine as long as no-one is connected to the specific project you need to reindex. However, I've typically found that it probably isn't going to work until you get everyone out. And even then you're best off bouncing the DataStage server first to clear up any leftover crappola before you do anything. My two cents.

I_Server_Whale · Post by **I_Server_Whale** » Thu Dec 28, 2006 3:52 pm

chulett wrote:I know that Conventional Wisdom says you'll be fine as long as no-one is connected to the specific project you need to reindex. However, I've typically found that it probably isn't going to work until you get everyone out. And even then you're best off bouncing the DataStage server first to clear up any leftover crappola before you do anything. My two cents.

In total accordance

ray.wurlod · Post by **ray.wurlod** » Thu Dec 28, 2006 4:11 pm

I'm going to guess that Craig's users use Host View in Manager or other mechanism for switching between projects. That such users have touched the project to be reindexed may, indeed, cause a problem, since some of the internal code uses file variables in COMMON.

Technically (and practically in my experience) it is sufficient to verify that no users are using the project (via the list_readu command) before proceeding to re-index the projecct.

prakashsahoo · Post by **prakashsahoo** » Fri Dec 29, 2006 12:08 am

Thanks All for help.
I have successfully executed the DS.REINDEX ALL.

Now able to import the Jobs in Manager successfully. I have executed the DS.REINDEX ALL with exclussive access (dsadm) and when no DSClient was connected to the DSServer.

But it lead to another problem.
when I am trying to open a job, it is not opening and throwing me error -

****
(61223) Unknown Stage Type ('CCustomStage') found in Job
This View of the JOb will be incomplete until the missing Stage is restored.

******

where as I was able to open the Jobs successfully before Reindexing the Project.

Can you Please guide me.

ray.wurlod · Post by **ray.wurlod** » Fri Dec 29, 2006 12:46 am

Please begin a new thread. The new problem is unrelated to the topic of this thread. Further it now becomes important to know what kind of job this is, so please post the new question in either the server forum or the parallel forum.