Error Accessing Oracle from Datastage

MukundShastri · Post by **MukundShastri** » Wed Aug 11, 2004 5:48 am

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

kduke · Post by **kduke** » Wed Aug 11, 2004 6:55 am

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.

chulett · Post by **chulett** » Wed Aug 11, 2004 6:55 am

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?

MukundShastri · Post by **MukundShastri** » Wed Aug 11, 2004 6:56 am

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

Ray, can I get your inputs please.

Thanks

Mukund

chulett · Post by **chulett** » Wed Aug 11, 2004 7:04 am

If you invoke the Djinn by name, he charges!

So, not interesting in answering my questions?

MukundShastri · Post by **MukundShastri** » Wed Aug 11, 2004 7:51 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 11, 2004 9:27 pm

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

Code: Select all

SELECT * FROM SYS.MESSAGE WHERE @ID = '081002';

richdhan · Post by **richdhan** » Thu Aug 12, 2004 12:00 am

Hi Ray,

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

Rgds
--Rich

ray.wurlod · Post by **ray.wurlod** » Thu Aug 12, 2004 1:54 am

Mumbai.

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

rsrikant · Post by **rsrikant** » Thu Aug 12, 2004 3:35 am

Oops!!!

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

Regards,
Srikanth

ray.wurlod · Post by **ray.wurlod** » Thu Aug 12, 2004 9:18 pm

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