error in view data
Moderators: chulett, rschirm, roy
error in view data
Hi,
I am on datastage Server edition 7.5.1 on AIX server.
I am connecting to an oracle database via a DRS stage.
The map runs fine, however when i try to view data. I get the following line or error message
Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project PORU02
Data Source is Empty
Error calling subroutine: DSD.Browse (Action=2); check DataStage is set up correctly in project PORU02
(The connection is broken (81002))
Finally I have to close the client to connect to the same job again.
The maps run fine and I am able to import table definitions etc.
I only have a problem with view data!
Awaiting a reply.
Thanks in advance!
Renita
I am on datastage Server edition 7.5.1 on AIX server.
I am connecting to an oracle database via a DRS stage.
The map runs fine, however when i try to view data. I get the following line or error message
Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project PORU02
Data Source is Empty
Error calling subroutine: DSD.Browse (Action=2); check DataStage is set up correctly in project PORU02
(The connection is broken (81002))
Finally I have to close the client to connect to the same job again.
The maps run fine and I am able to import table definitions etc.
I only have a problem with view data!
Awaiting a reply.
Thanks in advance!
Renita
-
- Premium Member
- Posts: 50
- Joined: Tue Jan 02, 2007 1:40 am
-
- Premium Member
- Posts: 50
- Joined: Tue Jan 02, 2007 1:40 am
Ok, it doesn't sound like you have configured DataStage for Oracle yet. There are specific changes you need to make to your dsenv file that are documented in the configuration guides. Have you done so? Do you have an Oracle client installed on the DataStage server?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi Chulett,
I have finished the configuration related to Oracle. The dsenv has been setup correctly all all environment variables are set.
The maps run successfully, hence the server can connect to the database. The outputs also are correct.
However the problem is only with the view data via the database stage.
Thanks,
Renita
I have finished the configuration related to Oracle. The dsenv has been setup correctly all all environment variables are set.
The maps run successfully, hence the server can connect to the database. The outputs also are correct.
However the problem is only with the view data via the database stage.
Thanks,
Renita