DSR_JOB (Action=2); check DataStage is set up correctly

anilkona · Post by **anilkona** » Wed Apr 27, 2005 9:44 am

We have two DataStage projects on AIX box. Both projects are sharing the same DataStage server engine.

When we try to create a new job, we run in to the following error. We are able to run jobs successfully.

The error messages are as follows:
Error calling subroutine: DSR_JOB (Action=2); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))

Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))

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

Does anyone has any idea what could be the cause of the above mentioned errors?

Thanks and Regards,
Anil

ArndW · Post by **ArndW** » Wed Apr 27, 2005 10:08 am

Is this error reproduceable? It looks identical to the error message you see in the designer after a timeout.

In the offending project can you open up existing jobs? What happens when you save them or do a "save as" another name? Can you view and/or modify components in the manager in this project?

anilkona · Post by **anilkona** » Wed Apr 27, 2005 10:26 am

When I try to save an existing job, it gives me following error message:

Error creating job TEST to copy into
Another job is being created - please try again later

And if I try to create a new job with same name 'TEST', I get an error that another job is being created with the same name.

If I try to create a new job with a different name, I get following errors:

Another job is being created - please try again later

Unable to return an attached Job.

Thanks for your time,
-Anil

ArndW · Post by **ArndW** » Wed Apr 27, 2005 10:35 am

Anil,

it looks like you are either having concurrency problems (you might have a process that has taken a lock than is no longer responding) or perhaps a corrupt file. It is more likely that you have a concurrency issue here! (that's the good news)

If you can, restart DS (best choice) or go into the director and use Job -> Cleanup Resources to see if there are process locks there that should not be.

anilkona · Post by **anilkona** » Wed Apr 27, 2005 10:53 am

I get the same error after clearing locks, logging out processes using DS.TOOLS command and finally restarting the DS Server.

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

Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project 89Upgrade
(The connection is broken (81002))

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

Thanks for your time,
-Anil

ArndW · Post by **ArndW** » Wed Apr 27, 2005 11:43 am

Did you do a (2) and (4) in DS.TOOLS and make sure that no errors occurred?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 27, 2005 12:21 pm

Is this happening in one project or all projects?
What if you create a new project and do these actions on the new proj?
Did you cleanup and reindex your project?

anilkona · Post by **anilkona** » Wed Apr 27, 2005 12:25 pm

This seems to be happening only on one project.
what do u mean by cleaning the project and indexing? Please let me know if there is any tools or set of instructions to perform these operations.

Thanks,
-Anil

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 27, 2005 12:33 pm

Search for those topics in the forum. There are several and detailed posts already present.

anilkona · Post by **anilkona** » Wed Apr 27, 2005 12:42 pm

You are the man.
Re-indexing seems to have solved the problem. Thanks a lot

But when I try to create a job with DB2/UDB stage and try to open the stage, the client freezes.

But the job itself is getting saved fine.

Any idea why the DataStage designer client freezes. DataStage Designer is running on Windows XP SP2 box.

Thanks,
-Anil

anilkona · Post by **anilkona** » Wed Apr 27, 2005 3:51 pm

Finally I had to uninstall the client, remove all the entries from the registry and re-install the client software. That fixed the problem of DataStage designer hanging while opening DB2/UDB stage definition.

Thanks for all your help

-Anil