DSN,PLUGIN ISSUE

georgesebastian · Post by **georgesebastian** » Thu Feb 08, 2007 10:09 pm

Hi Every one,

We have installed DS 7.5.2 in HP unix at our Development Server.But we are facing a problem.

Our ODBC connection with Oracle is not working.
1st In the D.Manager while importing it was showing the error "NO DNS name found"
With the postings from Dsxchange,i gave an entry in the uvodbc.config file under my project directory.
Then i restarted the Dsengine ,then in manager the DSN "DEV_OPT1" became visible.
But when tried to import metadata using this DSN we got the error"cannot find the DSN".

When we tried importing metadata using plugin metadata,we got the error "unable to initialize plugin".
Then through another posting in Dsxchange,i got the solution to give lib32 in the oracle path in dsenv file.
I tried that too.Restarted the Dsengine,then got the same error "unable to initialize plugin".then i stopped the dsengine,But now i cannot start the dsengine error"cannot find the fiel UV"...even though it is there.
Really frustrating.but any way i want to solve this issue..
Do i need to reinstall DS
Please guide me,

Thanks
George Sebastian

ray.wurlod · Post by **ray.wurlod** » Thu Feb 08, 2007 11:45 pm

Data Source Names for ODBC are configured in a file called .odbc.ini for DataStage on UNIX. You also need an entry for the DSN in the uvodbc.config file in the project directory. You also need to be able to resolve the TNS name, unless you are using a wired ODBC driver.

georgesebastian · Post by **georgesebastian** » Fri Feb 09, 2007 12:33 am

ray.wurlod wrote:Data Source Names for ODBC are configured in a file called .odbc.ini for DataStage on UNIX. You also need an entry for the DSN in the uvodbc.config file in the project directory. You also need to be ...

hi,

i have already done this.
still facing the error.
can you please sent me a copy of .odbc.ini,dsenv,uvodbc.config files.
i doubt my files are correct or not

george

chulett · Post by **chulett** » Fri Feb 09, 2007 8:15 am

Which 'error' are you still facing? That you can't restart DataStage or you can't import metadata?

You've posted two different methods - ODBC and native OCI - that you are attempting and which are (somewhat) mutually exclusive. Meaning, if you have OCI working why bother setting up ODBC? Both can take some time to setup if you've never done it before, which you can see if you follow any of the postings here. Once you have, though, you'll see it's actually quite simple.

So, which path? ODBC or OCI? For the former, post whatever you added (or changed) in the uvodbc.config file in your Project directory and the .odbc.ini file in $DSHOME. For the latter, your dsenv file.

chulett · Post by **chulett** » Mon Feb 12, 2007 8:04 am

We are confused as well. Seems like you'll want to resolve the inability to connect first, then we can worry about the Oracle problem. Kinda hard to import much of anything if you can't even connect to the Server.

First, do an Exact search for 'internal error 39202' and see if any of the solutions that worked for others work for you. Also tell us if the file it can't find still exists and what the permissions are on it.

/opt/products/Ascential/DataStage/DSEngine/sample/ds.rc

Lastly, tell us which userid you are using when trying to start the engine and what steps you performed before the ones you listed.

Have you opened a case with your Support provider? That should be the first you do when you get in a bind like this - especially if you are new to the product.

georgesebastian · Post by **georgesebastian** » Tue Feb 13, 2007 4:02 am

Thanks for the replay Craig,

The file exists there and the permission is
$ ls -al uv
-rwxr-x--x 1 root dwcap 65536 Apr 13 2005 uv
the user we are using is having administrator rights

Thanks
George

georgesebastian · Post by **georgesebastian** » Tue Feb 13, 2007 5:00 am

Hi,

The permission of the file /opt/products/Ascential/DataStage/DSEngine/sample/ds.rc
is

$ ls -al ds.rc
-r-x------ 1 root dwcap 16865 Jan 16 09:10 ds.rc

we will change the permission of the file 'ds.rc' and tell you the update
Thanks'
george

chulett · Post by **chulett** » Tue Feb 13, 2007 8:05 am

Mine are 544 or -r-xr--r-- so it is readable by all.

georgesebastian · Post by **georgesebastian** » Tue Feb 13, 2007 9:08 am

We have changed the permission of ds.rc file to
$ ls -al ds.rc
-rwxrwxrwx 1 dsadm dwcap 16865 Jan 16 09:10 ds.rc
stopped the Dsengine with "uv -admin -stop"
dsengine is stoping but

$ uv -admin -stop
Unable to remove the following shared memory segment(s) during shutdown:
m 33798 0xadec7512 --rw-rw-rw- root dwcap 14411 14428
Stopping JobMonApp
JobMonApp has been shut down.
1 error(s) encountered during shutdown procedure.
DataStage Engine 7.5.1.2 instance "ade" may be in an inconsistent state.

Then started Dsengine after some time
$ uv -admin -start
Starting JobMonApp
JobMonApp has been started.
But while trying to login using datastage designer to the project
we are facing the same error
"failed to connec t to host internal error 39202"

Kindly guide us
George

ray.wurlod · Post by **ray.wurlod** » Tue Feb 13, 2007 1:49 pm

Can the Administrator client connect to the project?

Can you invoke dssh in a project on the server?

georgesebastian · Post by **georgesebastian** » Wed Feb 14, 2007 7:58 am

ray.wurlod wrote:Can the Administrator client connect to the project?

Can you invoke dssh in a project on the server? ...

Hi,

Administartor client also cannot connect same error.
Kindly would you tell me how can i invoke dssh in a project on server?
Thanks
george

chulett · Post by **chulett** » Wed Feb 14, 2007 8:04 am

Like so:

Code: Select all

cd $DSHOME
. ./dsenv
cd ../Projects/<project name>
$DSHOME/bin/dssh

Assuming a 'standard' installation location and your userid has $DSHOME set.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 14, 2007 2:23 pm

Permissions on $DSHOME/bin/uv are incorrect. Not only must this (and a number of other executables) be owned by root, they must have the setuid bit set. There is a script in the scripts directory for resetting the permissions, or you can involve your support provider. You should also track down whomever is responsible for changing the permissions and castigate them severely.

Code: Select all

$ ls -al uv 
-rwsr-xr-x 1 root dwcap 65536 Apr 13 2005 uv

georgesebastian · Post by **georgesebastian** » Sat Feb 17, 2007 2:57 am

Hi,

I have opened a case with IBM.
In progress,
Will update you everyday...
Thanks for all your help
George

georgesebastian · Post by **georgesebastian** » Sat Feb 17, 2007 6:53 am

We have registered a case with IBM,
These are the steps that we did,
thanks for all ur help
i will up date u all..

These are the commands that we tried on our dev server

# cd /opt/products/Ascential/DataStage/DSEngine

# netstat -a |grep dsrpc

tcp 0 0 *.dsrpc *.* LISTEN

# ps -ef|grep phantom

root 23389 23366 1 03:05:29 pts/1 0:00 grep phantom

# ps -ef|grep dsapi

root 23393 23366 1 03:06:17 pts/1 0:00 grep dsapi

# ps -ef|grep dscs

root 23395 23366 1 03:06:59 pts/1 0:00 grep dscs

# ipcs -mop|grep ade

m 33798 0xadec7512 --rw-rw-rw- root dwcap 0 14411 23275

# ipcrm -m 33798

# netstat -a|grep dsrpc

tcp 0 0 *.dsrpc *.* LISTEN

# . ./dsenv

sh: OME/java/jre/lib/PA_RISC2.0/hotspot:/opt/oracle_9.2.0/lib32:/opt/oracle_9.2.0/lib/:/opt/cobol/lib:/usr/dmexpress/lib: not found.

# ./bin/uvsh

/usr/lib/dld.sl: Can't find path for shared library: libgciudt6.sl

/usr/lib/dld.sl: No such file or directory

Abort(coredump)

# cd bin

# pwd

/opt/products/Ascential/DataStage/DSEngine/bin

# uv -admin -start

sh: uv: not found.

# ls -al uv

-rwxrwxrwx 1 dsadm dwcap 65536 Apr 13 2005 uv

Thanks & Regards

George .S.Thazhath