Error calling Subroutine: DSD.Browse (Action=3);

pmadhavi · Post by **pmadhavi** » Wed Mar 08, 2006 8:58 am

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.

ArndW · Post by **ArndW** » Wed Mar 08, 2006 9:07 am

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?

pmadhavi · Post by **pmadhavi** » Wed Mar 08, 2006 9:21 am

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?

ArndW · Post by **ArndW** » Wed Mar 08, 2006 9:32 am

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?

pmadhavi · Post by **pmadhavi** » Wed Mar 08, 2006 10:12 am

we have 3 Query types in DRS stage.
1. Generated SQL Query
2. User defined SQL Query
3. User defined SQL query file.

Can u pls explain me what can be the reason of DRS behaving this way?

ArndW · Post by **ArndW** » Wed Mar 08, 2006 10:18 am

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?

pmadhavi · Post by **pmadhavi** » Wed Mar 08, 2006 10:28 am

ArndW wrote: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?

\

We are using generated SQL.

pmadhavi · Post by **pmadhavi** » Wed Mar 08, 2006 1:02 pm

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?

ArndW · Post by **ArndW** » Thu Mar 09, 2006 10:16 am

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.

mahi_mahi · Post by **mahi_mahi** » Thu Mar 09, 2006 1:18 pm

What is DRS stage ?? where and why we use that stage...
i never came across that in my datastage version

Mahi

ray.wurlod · Post by **ray.wurlod** » Thu Mar 09, 2006 4:59 pm

Dynamic RDBMS Stage. Introduced (iirc) in 7.0.

lan · Post by **lan** » Sat Dec 15, 2007 11:24 pm

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?

[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).
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

chulett · Post by **chulett** » Sun Dec 16, 2007 9:45 am

Umm... you did notice that the issue you responded to is pushing two years old, did you not?

lan · Post by **lan** » Tue Dec 18, 2007 11:21 am

lan · Post by **lan** » Tue Dec 18, 2007 11:23 am

chulett wrote:Umm... you did notice that the issue you responded to is pushing two years old, did you not?

[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 this

DSXchange

Error calling Subroutine: DSD.Browse (Action=3);

Error calling Subroutine: DSD.Browse (Action=3);

Error calling Subroutine:DSD.Browse (Action=3);Preview issue