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
Error in viewing the data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: