Datastage DSR_PROJECT error

dilip.datastage · Post by **dilip.datastage** » Thu Mar 20, 2008 10:38 pm

Hi,

I have an issue which came up suddenly in between my work.
I was working on one project dwhproject3, designing jobs(Not triggered any job in backend). suddenly i started getting error

Error calling subroutine: DSR_PROJECT (Action=1); check DataStage is set up correctly in project dwhdrop3stgdev
(Unable to load subroutine on host (30105))

Not able to find the reason why it happend suddenly.

So closed the desinger and tried logging in again.

I have taken the restart of the server system too. but the message is still coming and not able to work.

The error is coming only in one project. other projects are working fine...

can anyone tell me the reson , why it happend and the resolution for this at the earliest.

Regards
Dilip

ray.wurlod · Post by **ray.wurlod** » Fri Mar 21, 2008 2:30 am

For this one you need someone with access to the source code of DSR_PROJECT (a helper subroutine) to find out what Action 1 is. That means your official support provider will need to be involved, since IBM does not release source code they will need also to be involved - through your correct channels, of course.

Has anyone moved the project to a different location using operating system utilities? That might cause it.

ArndW · Post by **ArndW** » Fri Mar 21, 2008 2:33 am

Do you have other projects on this installation and can you login to them?

ray.wurlod · Post by **ray.wurlod** » Fri Mar 21, 2008 5:10 am

dilip.datastage wrote:The error is coming only in one project. other projects are working fine...

ArndW · Post by **ArndW** » Fri Mar 21, 2008 5:15 am

deanwalker · Post by **deanwalker** » Fri Mar 21, 2008 3:14 pm

It will be interesting to know why the error message refers to a different project name to the one you are attaching to.
A support call is needed, but you could take a peek at the UV.ACCOUNT record for this project to see if it looks similar to your other projects.

kumar_s · Post by **kumar_s** » Fri Mar 21, 2008 3:23 pm

Also try to run DS.REINDEX ALL for that project. Make sure, you can have possible backup for the project.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 21, 2008 4:55 pm

... or it could be UV_SCHEMA or it might be VOC or it might be a host of other things. So many maybes. You need to know what the helper subroutine is trying to do.