Error Calling Subroutine in DataStage Director
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Error Calling Subroutine in DataStage Director
Hello Everyone,
We are getting "Error calling subroutine " while opening the Director. There are multiple errors one after another:
Error calling subroutine: DSR_EXECJOB (Action=23); check DataStage is set up correctly in project DSTESTPROJECT
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project DSTESTPROJECT
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_PROJECT (Action=7); check DataStage is set up correctly in project DSTESTPROJECT
(The connection is broken (81002))
Here are some observations:
- This is specific is one project. All other projects are fine
- Error is in Director only. Designer is working fine- I can open the jobs in designer etc.
- All users are getting this error in director.
- Disk space seems to be fine
This is what I have done so far:
1. Use "Reindex all" for rebuilding the indexes - used DS.TOOLS for this
2. clearing &PH& directory: Used CLEAR.FILE command
Any help will be deeply appreciated:
Can there be an issue with RT log files?- How can I check that?
Please share your thoughts.
Thanks in advance.
We are getting "Error calling subroutine " while opening the Director. There are multiple errors one after another:
Error calling subroutine: DSR_EXECJOB (Action=23); check DataStage is set up correctly in project DSTESTPROJECT
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project DSTESTPROJECT
(The connection is broken (81002))
Error calling subroutine: *DataStage*DSR_PROJECT (Action=7); check DataStage is set up correctly in project DSTESTPROJECT
(The connection is broken (81002))
Here are some observations:
- This is specific is one project. All other projects are fine
- Error is in Director only. Designer is working fine- I can open the jobs in designer etc.
- All users are getting this error in director.
- Disk space seems to be fine
This is what I have done so far:
1. Use "Reindex all" for rebuilding the indexes - used DS.TOOLS for this
2. clearing &PH& directory: Used CLEAR.FILE command
Any help will be deeply appreciated:
Can there be an issue with RT log files?- How can I check that?
Please share your thoughts.
Thanks in advance.
Last edited by just4geeks on Thu May 05, 2011 8:31 am, edited 1 time in total.
Attitude is everything....
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
In one of the post I saw that
-no clients should be open at all and connected to any projects?
- or no one should be connected to the project I need to rebuild indexes on? or
what are other requirements to get exclusive access?
Thanks
what does exclusive access means ?"project may need re-indexing (using DS.REINDEX ALL next time you can get exclusive access to the project)."
-no clients should be open at all and connected to any projects?
- or no one should be connected to the project I need to rebuild indexes on? or
what are other requirements to get exclusive access?
Thanks
Attitude is everything....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
Mine is to but I get the same issue now and then.
I look in Process explorer and I can see the designer or director processes its just that they loose the connection to the dsapi_server and slave process.
I usually just close the client and reconnect and its fine.
This usually happens when I leave them open all night. But its not consistant!!
I know thats not an answer, but I share your pain.
Maybe some day I will run that accross support when I am talking to them.
If I get an answer I will pass it on.
I look in Process explorer and I can see the designer or director processes its just that they loose the connection to the dsapi_server and slave process.
I usually just close the client and reconnect and its fine.
This usually happens when I leave them open all night. But its not consistant!!
I know thats not an answer, but I share your pain.
Maybe some day I will run that accross support when I am talking to them.
If I get an answer I will pass it on.
"Don't let the bull between you and the fence"
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Any other suggestions or ideas will be greatly appreciated!
is "Global Session Properties" in web console ( Administration>Session Management) has some bearing on it also?
Our settings are:
Inactive Session Timeout: 900 seconds
Check Inactive Sessions Every:120 seconds
Maximum Sessions: 60
Current Sessions: 28
is "Global Session Properties" in web console ( Administration>Session Management) has some bearing on it also?
Our settings are:
Inactive Session Timeout: 900 seconds
Check Inactive Sessions Every:120 seconds
Maximum Sessions: 60
Current Sessions: 28
Attitude is everything....
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Premium Member
- Posts: 644
- Joined: Sat Aug 26, 2006 3:59 pm
- Location: Mclean, VA
Yes it may be related!just4geeks wrote:Any other suggestions or ideas will be greatly appreciated!
is "Global Session Properties" in web console ( Administration>Session Management) has some bearing on it also?
Our settings are:
Inactive Session Timeout: 900 seconds
Check Inactive Sessions Every:120 seconds
Maximum Sessions: 60
Current Sessions: 28
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI