Error calling Subroutine: DSD.Browse (Action=3);
Moderators: chulett, rschirm, roy
Error calling Subroutine: DSD.Browse (Action=3);
Hi,
We are working on DS7.5. The jobs run fine.
But when we try to view data from the DRS stage, it throws the error
Error calling Subroutine: DSD.Browse (Action=3);
Check Datastage is set up correctly in project 'DEVELOPMENT'
If we press Ok one more pop window will come saying 'Datasource is empty'
I checked the previous discussions on this. And also we tried all the given possible solutions. But none of them worked.
Pls let me know if anymore information is needed.
We are working on DS7.5. The jobs run fine.
But when we try to view data from the DRS stage, it throws the error
Error calling Subroutine: DSD.Browse (Action=3);
Check Datastage is set up correctly in project 'DEVELOPMENT'
If we press Ok one more pop window will come saying 'Datasource is empty'
I checked the previous discussions on this. And also we tried all the given possible solutions. But none of them worked.
Pls let me know if anymore information is needed.
Thanks,
Madhavi
Madhavi
Define an ODBC stage to the same datasource as you are trying to access from DRS and see if you get the same error message. Have you used DRS successfully in this project before?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
We have the same jobs with DRS stage running fine in DS7.1 in production and also we are able to view data there.
Now we are migrating the jobs from 7.1 to 7.5.
And in 7.5, there's no problem in running the jobs.
I replaced DRS stage with ODBC and I am able to view data.
But why is it so?
Now we are migrating the jobs from 7.1 to 7.5.
And in 7.5, there's no problem in running the jobs.
I replaced DRS stage with ODBC and I am able to view data.
But why is it so?
Thanks,
Madhavi
Madhavi
I just wanted to narrow down the cause to the DRS stage. Can you run the job? Do you have custom SQL in the DRS stage?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The reason I asked is that if you are using your own query it might be causing the issue, whereas it is unlikely that a generated query will cause the error you are having. Which one of the 3 types are you using?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
We are working on peoplesoft upgarde project.
One of the peoplesoft consultants told that we have to import all the bundles. we have done it.
But still getting the error.
When we try to view data from DRS stage, It is saying Error Calling subroutine DSD_Browse
or some times DSD_RECORD and some times DSD_SELECT.
Can u pls help us out in this regard?
One of the peoplesoft consultants told that we have to import all the bundles. we have done it.
But still getting the error.
When we try to view data from DRS stage, It is saying Error Calling subroutine DSD_Browse
or some times DSD_RECORD and some times DSD_SELECT.
Can u pls help us out in this regard?
Thanks,
Madhavi
Madhavi
Madhavi,
it sounds like we've reached the limits of what can be done here in the forum - it really might be a bug in the product. The next step is to go through your support provider and giving them a reproduceable test case. But it would be nice if you could leave feedback on this thread when you get the problem solved so that others might benefit in the future.
it sounds like we've reached the limits of what can be done here in the forum - it really might be a bug in the product. The next step is to go through your support provider and giving them a reproduceable test case. But it would be nice if you could leave feedback on this thread when you get the problem solved so that others might benefit in the future.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Error calling Subroutine:DSD.Browse (Action=3);Preview issue
[LAN] There are two ways you could avoid this problem (either of them could resolve the issue & we are not sure why this issue occurs in the first place).pmadhavi wrote:We have the same jobs with DRS stage running fine in DS7.1 in production and also we are able to view data there.
Now we are migrating the jobs from 7.1 to 7.5.
And in 7.5, there's no problem in running the jobs.
I replaced DRS stage with ODBC and I am able to view data.
But why is it so?
1. Remove all extra whitespaces and new line characters in your user created SQL statement and then 'preview' data.
2. Change "Pre Fetch Memory setting" value to zero (under 'General' tab) and try it.
Either or both of the above settings should solve your issue if not let us know
[LAN]: Did you notice that there was no solution provided for this problem? You may please better utilize your intelligence by answering such questions (you had 2 years time!) than giving comments like thischulett wrote:Umm... you did notice that the issue you responded to is pushing two years old, did you not?