DSXchange

Hi,

In our developement server there are three projects, we are able to loging on 2 projects but while loggging on 3rd one we are getting following error.

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

Kindly suggest to resolve this issue.

Thanks in Advance.

Regards,
Nitin

I kindly suggest you take your error string "Unable to load subroutine on host (30105)" and do an exact search of the forums. See if any of the other posts where people have had this exact same message help you at all.

What's different about the third project?

ray.wurlod wrote:What's different about the third project?

Hi,

Third project(that got corrupted) is developement project and other two are QA and Backup project. Configuration-wise all are same. That day we try to bring down the server, but there was a process in FINAL_WAIT status once process terminated we bring down the server.

But when start the server we got following maessage.

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

Please help us to resolve this issue.

Thanks in advance.

Regards,
Nitin

ray.wurlod wrote:What's different about the third project?

Hi,

Third project(that got corrupted) is developement project and other two are QA and Backup project. Configuration-wise all are same. That day we try to bring down the server, but there was a process in FINAL_WAIT status once process terminated we bring down the server.

But when start the server we got following maessage.

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

Please help us to resolve this issue.

Thanks in advance.

Regards,
Nitin

Connect to the server using telnet, cd to the problem project and try to invoke dssh once there (having executed $DSHOME/dsenv). If you can get to the TCL prompt, make sure that you are the only user in the project, then execute the DS.REINDEX ALL command. Let us know whether that solves the problem.

Hi Nitin,

If you can come up with more details.

Rgds,
Abhijit Gaikwad

RelianceDss wrote:Hi,

In our developement server there are three projects, we are able to loging on 2 projects but while loggging on 3rd one we are getting following error.

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

Kindly suggest to resolve this issue.

Thanks in Advance.

Regards,
Nitin

Hi Nitin,

If you can come up with more details.

Rgds,
Abhijit Gaikwad

RelianceDss wrote:Hi,

In our developement server there are three projects, we are able to loging on 2 projects but while loggging on 3rd one we are getting following error.

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

Kindly suggest to resolve this issue.

Thanks in Advance.

Regards,
Nitin

ray.wurlod wrote:Connect to the server using telnet, cd to the problem project and try to invoke dssh once there (having executed $DSHOME/dsenv). If you can get to the TCL prompt, make sure that you are the only user in the project, then execute the DS.REINDEX ALL command. Let us know whether that solves the problem.

Hi,

we did what you have suggested and restart the server using bin/uv.
but problem is still there.

Regards,
Nitin Swarnkar.

Hi Nitin,

If you can come up with more details.

Rgds,
Abhijit Gaikwad,

Hi Abhijit,
As i mentioned in my previous posts, While trying to restart server we stcuk up to a process, which is in FINAL_WAIT status. Then after some time if got trminated. Then we brought up the server. but when we try to logging in Dev project, system is throwing following error "Unable to load subroutine on host (30105)"

Regards,
Nitin.

Please verify that the connection via telnet was successful, that DS.REINDEX ALL succeeded. If so, please do the same but this time execute the command DS.CHECKER.

DSR_PROJECT is a "helper subroutine" which should be cataloged in the project. Therefore, while you're there, can you also execute the command LIST.ITEM VOC WITH @ID LIKE "...DSR...PROJECT..."

ray.wurlod wrote:Please verify that the connection via telnet was successful, that DS.REINDEX ALL succeeded. If so, please do the same but this time execute the command DS.CHECKER.

DSR_PROJECT is a "helper subroutine" which should be cataloged in the project. Therefore, while you're there, can you also execute the command LIST.ITEM VOC WITH @ID LIKE "...DSR...PROJECT..."

Hi Ray,

Thanks for your continous support.

We run this time DS.CHECKER. but there is a error message.
">DS.CHECKER
Unable to open the operating system file "DSG_BP.O/DSR_CHECKER.B".
[ENOENT] No such file or directory"

We have run LIST.ITEM VOC WITH @ID LIKE "...DSR...PROJECT..." command
the output of this command is

LIST.ITEM VOC WITH @ID LIKE "...DSR...PROJECT..." 11:08:43am 28 Aug 2007 PAGE
1

DSR_PROJECT
001 V
002 DSG_BP.O/DSR_PROJECT.B
003 B
004 BN
009 DSG_BP.O

Regards,
Nitin.

You must do a "LOGTO {YourProjectName}", the DS.CHECKER verb is not present in the master VOC

I just realized you have the verb, but not the object code for it. You have a bad project, just as Ray has stated.

You appear to have an incompletely-installed project. Some vital entries are missing from the VOC file. To ascertain which these are, please do all of the following.

1. Create a pointer to the VOC file in another project.
SETFILE /path/of/other/project/VOC otherVOC

2. Create a Select List of verbs in your VOC and save it.
SSELECT VOC WITH TYPE = "V" AND F3 = "B" TO 9
SAVE.LIST MY.VOC FROM 9

3. Create a Select List of verbs in the other VOC and save that.
SSELECT otherVOC WITH TYPE = "V" AND F3 = "B" TO 8
SAVE.LIST OTHER.VOC FROM 8

4. Identify those verbs that are in the other VOC but not yours.
LIST.DIFF OTHER.VOC
MY.VOC
VOC.DIFF

5. Activate the list of differences and produce a report.
GET.LIST VOC.DIFF
LISTV

6. Post the results here.

7. Copy the records from the other VOC to your VOC
GET.LIST VOC.DIFF
COPYI FROM otherVOC TO VOC
Y

8. Once all is well, delete the saved Select Lists
DELETE.LIST OTHER.VOC
DELETE.LIST MY.VOC
DELETE.LIST VOC.DIFF

[quote="ray.wurlod"]You appear to have an incompletely-installed project. Some vital entries are missing from the VOC file. To ascertain which these are, please do all of the following.

1. Create a pointer to the VOC file in another project.
SETFILE /path/of/other/project/VOC otherVOC

.........

Hi Ray,

The output of command

GET.LIST VOC.DIFF
LISTV

having 178 lines and it looks like

DSU.BuildUniqueDayHash" not found.
DSU.DSLinkData" not found.
DSU.DateToInternal" not found.
DSU.ElapsedTimeFromSeconds" not found.
.
.
.
"JOB.1104642348.DT.1431845202" not found.
"JOB.1104645382.DT.1431845204.TRANS1" not found.
"JOB.1104647800.DT.1431845203.TRANS1" not found.
"JOB.1104648530.DT.1431845206.TRANS1" not found.
"JOB.1105069104.DT.1431845199.TRANS1" not found.
"JOB.2144503925.DT.1420453989.TRANS1" not found.
"JOB.2144506915.DT.1420453988" not found.
"JOB.2145120227.DT.1420453985" not found.
"178 more record" not found.

when we tried to execute DS.CHECKER, we got an error message stating
"Unable to open the operating system file "DSG_BP.O/DSR_CHECKER.B".
[ENOENT] No such file or directory"

DSG_BP.O directory is not there in Dev(corrupted) projected but it is avaliable in BackUp and QA project.


Regards,
Nitin Swarnkar.