Unable to load subroutine on host (30105

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Unable to load subroutine on host (30105

Post by RelianceDss »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What's different about the third project?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Post by RelianceDss »

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
RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Post by RelianceDss »

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
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Abhijeet1980
Participant
Posts: 81
Joined: Tue Aug 15, 2006 8:31 am
Location: Zürich
Contact:

Re: Unable to load subroutine on host (30105

Post by Abhijeet1980 »

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
Kind regards
Abhijit Gaikwad
Abhijeet1980
Participant
Posts: 81
Joined: Tue Aug 15, 2006 8:31 am
Location: Zürich
Contact:

Re: Unable to load subroutine on host (30105

Post by Abhijeet1980 »

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
Kind regards
Abhijit Gaikwad
RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Post by RelianceDss »

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.
RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Re: Unable to load subroutine on host (30105

Post by RelianceDss »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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..."
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Post by RelianceDss »

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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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.
Last edited by ArndW on Tue Aug 28, 2007 1:22 am, edited 1 time in total.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by 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

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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RelianceDss
Premium Member
Premium Member
Posts: 27
Joined: Wed Apr 11, 2007 12:53 am

Post by RelianceDss »

[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.
Post Reply