Error in viewing the data

rkdatastage · Post by **rkdatastage** » Thu Jan 24, 2008 5:28 am

Hi

I am trying to view data from a DRS Stage table configured to connect to Oracle 10g database - I am encountering this error
----
Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project Dev_OP
----
After this message it is prompting " Data source is empty "

But actually there are 10 records in the table when i had executed the select statement in SQL prompt. I had used the same SQL query which was genereated by the DRS Stage.

Kindly share your ideas

Thanks in advance

Regards
RK

ray.wurlod · Post by **ray.wurlod** » Thu Jan 24, 2008 7:12 am

Whatever the error was in the data browser it has prevented the return of rows from the table, hence the "is empty" message. You need to involve your support provider who can ascertain what action #3 for the helper routine DSD.Browse is, and thereby narrow the focus of your investigation.

chulett · Post by **chulett** » Thu Jan 24, 2008 8:23 am

To help diagnose - does this happen with all attempts to view Oracle data? Just this one job? Just this one query? Just this one table?

rkdatastage · Post by **rkdatastage** » Mon Jan 28, 2008 12:41 am

Hi All
Thanks for your response.

I had tried to read the data from the table with another job and it is provinding all the information. Till now i am analyzing that there are some locking issue with the table , but now i am able to read the data from the particualar table . But when i try to read data from my previous job it has the same error. What are the chances that the job may corrupted or any thing i am missing while identifying the problem.

Kindly giude me

Thanks in advance

RK

ray.wurlod · Post by **ray.wurlod** » Mon Jan 28, 2008 9:25 pm

Unlikely that the job is corrupted; far more likely that one of the properties in the Oracle stage is not set quite right.