DSXchange

We have set up a new server for datastage.
1] Installed the datastage server
2] Configured dsenv file with LD_LIBRARY_PATH for the ORACLE_HOME
3] Trying to access table metadata from datastage manager --table definations.
But getting following error while connecting to database:

Error calling subroutine: DSR_IMPPLG (Action=6); check DataStage is set up correctly in project INSIGHT
(The connection is broken (81002))

4] Point to note that from the os I am able to connect to the same database using sqlplus.

5] Please let mw know what can be done in this case. ??
Thanks

Mukund

You need to stop and start DataStage before dsenv changes take effect. I am not sure if that we fix your problem though. I do not remember that specific error message. I am sure Ray will.

What are you choosing for the Import? Make sure you pick "Plugin Metadata" and then picking "OCI8". Is that what is generating this error? If so, at which step does this error occur?

I have stopped and restarted the engine. But no luck...

Ray, can I get your inputs please.


Thanks

Mukund

If you invoke the Djinn by name, he charges!

So, not interesting in answering my questions?

Hi ,

The problem is resolved. It was a due to the project called 'INSIGHT' was
created but the directory in which it was created was PROJECTS directory.
No subdirectory called 'INSIGHT' in it.

Re-installed with default directiory paths. Working fine now.

Thanks a lot.

Time zones, guys! I'm working in India this week (GMT plus five and a half). Go figure.

I think I would have guessed at the incomplete project installation, and would have reminded everyone to

Hi Ray,

This is out of the box. Are you in Chennai by any chance.

Rgds
--Rich

Mumbai.

Pass through Chennai on the way to Singapore on Sunday morning, but they don't let us off the aircraft. (Air India)

Oops!!!

Rich and I thought we could meet you in person if you are in chennai and don't mind meeting people.

Regards,
Srikanth

Seem to remember having this discussion in March 2003! :D