Page 1 of 1
Error -ODBC license file (IVVM.LIC or DDVM.LIC) not found
Posted: Mon Jun 11, 2007 4:52 am
by parameswar
Hi,
Datastage server is in UNIX machine. Oracle Database is also in unix machine but different one. I configured .odbc.ini, uvodbc.config and dsenv files. I am trying to import ODBC table definition in datastage manager. After providing all inputs - DSN, user name & password when clicking OK button I am getting following error :
"Error - ODBC license file (IVVM.LIC or DDVM.LIC) not found in branded_odbc Directory".
Please sugget what is wrong or is there any other file I have to configure?
Thanks,
Parameswar
Posted: Mon Jun 11, 2007 5:27 am
by ray.wurlod
First task is to check the branded_odbc directory on the server to determine whether the license files are actually there. The branded_odbc directory is usually a sibling of the DataStage engine directories (DSEngine and PXEngine).
Posted: Mon Jun 11, 2007 5:55 am
by parameswar
ray.wurlod wrote:First task is to check the branded_odbc directory on the server to determine whether the license files are actually there. The branded_odbc directory is usually a sibling of the DataStage engine dire ...
Hi Ray,
IVVM.LIC file is there in branded_odbc Directory. But this directory is in ../DataStage, nither in ../PXEngine nor ...DSEngine directory.
Thanks,
Parameswar
Posted: Mon Jun 11, 2007 6:25 am
by chulett
Which is fine and right where it belongs. Are the permissions correct such that your user can read them?
Posted: Mon Jun 11, 2007 7:06 am
by parameswar
chulett wrote:Which is fine and right where it belongs. Are the permissions correct such that your user can read them? ...
Permission is as : -rwxr-xr-x
Posted: Mon Jun 11, 2007 3:44 pm
by ray.wurlod
Does LD_LIBRARY_PATH include branded_odbc/lib ?
Posted: Tue Jun 12, 2007 1:16 am
by parameswar
ray.wurlod wrote:Does LD_LIBRARY_PATH include branded_odbc/lib ? ...
Yes it is there in SHLIB_PATH as .../home/dsadm/Ascential/DataStage/branded_odbc/lib..
Onething I have noticed from odbcref.pdf manual that $APT_ORCHHOME/branded_odbc /lib to be include SHLIB_PATH. But in dsenv APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine add branded_odbc folder is not there in PXEngine directory.
Is there anything I am missing ?
Thanks,
Parameswar
Posted: Tue Jun 12, 2007 5:28 am
by ray.wurlod
Now I'm confused. All of the following must be in SHLIB_PATH, and before any database libraries:
$DSHOME/lib
$APT_ORCHHOME/lib
branded_odbc/lib
As far as I can determine, there is no branded_odbc within the $APT_ORCHHOME directory.
Posted: Tue Jun 12, 2007 9:17 am
by parameswar
ray.wurlod wrote:Now I'm confused. All of the following must be in SHLIB_PATH, and before any database libraries:
$DSHOME/lib
$APT_ORCHHOME/lib
branded_odbc/lib
As far as I can determine, there is no branded_od ...
Hi Ray,
Thanks for your response. Since I am not a premium member, I am unable to read your full answer.
Shall I copy branded_odbc directory from .../DataStage/ into .../PXEngine/ so that I can set the $APT_ORCHHOME/lib branded_odbc/lib path in dsenv file which is as per manual.
Thanks,
Parameswar
Posted: Tue Jun 12, 2007 3:14 pm
by ray.wurlod
No. That's not required. (That is, I don't have that in place, and it's working fine for me.)
Premium membership is only a few cents per day, is definitely worth it, and helps to pay for the bandwidth costs of DSXchange.
Posted: Fri Jun 15, 2007 4:08 pm
by Ranjana
Parameswar,
We got similar message while ODBC configurations. Go to .odbc.ini file and change the path from #Branded_ODBC_DIR# to corresponding ODBC install dir.
[ODBC]
IANAAppCodePage=4
InstallDir=#Branded_ODBC_DIR#
Trace=1
TraceDll=#Branded_ODBC_DIR#/lib/odbctrac.so
TraceFile=#Branded_ODBC_DIR#/odbctrace.out
UseCursorLib=0
This should fix the issue.
Posted: Sat Jun 16, 2007 2:27 am
by parameswar
Ranjana wrote:Parameswar,
We got similar message while ODBC configurations. Go to .odbc.ini file and change the path from #Branded_ODBC_DIR# to corresponding ODBC install dir.
[ODBC]
IANAAppCodePage=4
InstallDir=#Branded_ODBC_DIR#
Trace=1
TraceDll=#Branded_ODBC_DIR#/lib/odbctrac.so
TraceFile=#Branded_ODBC_DIR#/odbctrace.out
UseCursorLib=0
This should fix the issue.
Hi Ranjana,
Actually we have not installed any ODBC driver. We are using the default data direct ODBC driver that is coming with DataStage. Here is the current path setting in odbc.ini file.
[ODBC]
IANAAppCodePage=4
InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc
Trace=0
TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/odbctrac.sl
TraceFile=odbctrace.out
UseCursorLib=0
As per your suggestion, I am not getting odbctrace.out within branded_odbc directory . Also instead of odbctrac.so I am getting odbctrac.sl file within lib/ directory.
Is there anything I have to install for these file.
Thanks,
Parameswar
Posted: Sat Jun 16, 2007 6:59 am
by chulett
Some systems use .so files, some .sl so no worries there. And the 'trace.out' file will only be created when you have things working and turn trace on. Again, all fine.
Is the 'InstallDir' noted in your post correct?
Can you post the section of your dsenv file that shows how you are setting the PATH and SHLIB_PATH (or the equivalent for your system) environment variables? If unsure, just post the whole dang thing.
Wrapped in
Posted: Sat Jun 16, 2007 10:02 am
by parameswar
chulett wrote:Some systems use .so files, some .sl so no worries there. And the 'trace.out' file will only be created when you have things working and turn trace on. Again, all fine.
Is the 'InstallDir' noted in your post correct?
Can you post the section of your dsenv file that shows how you are setting the PATH and SHLIB_PATH (or the equivalent for your system) environment variables? If unsure, just post the whole dang thing.
Wrapped in Code: Select all
tags![/b][/quote]
Hi Chulett,
Here is all the config details.
**********dsenv***********
DSHOME=`cat /.dshome`
export DSHOME
ORACLE_HOME=/u00/app/oracle/product/10.2.0; export
ORACLE_HOME
DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export
DSHOME
APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine;
export APT_ORCHHOME
UDTHOME=/home/dsadm/Ascential/DataStage/ud41; export
UDTHOME
UDTBIN=/home/dsadm/Ascential/DataStage/ud41/bin; export
UDTBIN
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
ODBCINF=/home/dsadm/Ascential/DataStage/branded_odbc;
export ODBCINF
HOME=${HOME:-/}; export HOME
SHLIB_PATH=$SHLIB_PATH:$DSHOME/lib:$APT_ORCHHOME/lib:$APT_O
RCHHOME/osh_wrappers:$ODBCINF:$ODBCINF/lib:$ORACLE_HOME:$OR
ACLE_HO
ME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/ctx/lib:$ORACLE_HOME
/rdbms/lib32:$DSHOME/uvdlls:$DSHOME/java/jre/lib/PA_RISC2.0
:$DSHOM
E/java/jre/lib/PA_RISC2.0/hotspot:$DSHOME/java/jre/lib/PA_R
ISC/hotspot:/usr/lib:/usr/local/lib:/usr/bin:/usr/local/bin
:/usr/b
in/X11:/usr/contrib/bin/X11:/usr/lib/X11:/usr/contrib/lib/X
11:/opt/aCC/lib:/opt/aCC/bin; export SHLIB_PATH
LD_PRELOAD=$DSHOME/java/jre/lib/PA_RISC2.0/hotspot/libjvm.s
l; export LD_PRELOAD
PATH=$PATH:$DSHOME/bin:$APT_ORCHHOME/bin:$APT_ORCHHOME/osh_
wrappers:$ODBCINF:$ODBCINF/bin:$ORACLE_HOME/bin; export
PATH
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
************ .odbc.ini************************
[ODBC]
IANAAppCodePage=4
InstallDir=/home/dsadm/Ascential/DataStage/branded_odbc
Trace=1
TraceDll=/home/dsadm/Ascential/DataStage/branded_odbc/lib/o
dbctrac.sl
TraceFile=/home/dsadm/Ascential/DataStage/branded_odbc/odbc
trace.out
UseCursorLib=0
[bancs]
QEWSD=39247
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo
ra20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=UXJEDB04
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=staging
Password=staging
PortNumber=1521
ProcedureRetResults=0
SID=rpd1
UseCurrentSchema=1
[FRSTEST]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo
ra20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=FRSTEST
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=019781
Password=password323
PortNumber=1521
ProcedureRetResults=0
SID=FRSTEST
UseCurrentSchema=1
[OFDM]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo
ra20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=UXJEDB05
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=ofsd
Password=ofsd
PortNumber=1521
ProcedureRetResults=0
SID=OFDM
UseCurrentSchema=1
[CCRDEV]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo
ra20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=ERM
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=ccr_guest
Password=ccr_guest
PortNumber=1521
ProcedureRetResults=0
SID=ccrt
UseCurrentSchema=1
[DIMDEV]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo
ra20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=HPUS33
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=usa
Password=usa
PortNumber=1521
ProcedureRetResults=0
SID=dimdev
UseCurrentSchema=1
[DWDEV]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMo
ra20.sl
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=HPUS33
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=usa
Password=usa
PortNumber=1521
ProcedureRetResults=0
SID=dwdev
UseCurrentSchema=1
[AOL]
Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMm
sss20.sl
Description=DataDirect SQL Server Wire Protocol
Database=db
LogonID=sa
Password=password
Address=BSDSQL,1433
QuotedId=No
AnsiNPW=No
**************uvodbc.congig****************
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
<DIMDEV>
DBMSTYPE = ODBC
<IVRDevt>
DBMSTYPE = ODBC
<CCRDEV>
DBMSTYPE = ODBC
<eCorpDevt>
DBMSTYPE = ODBC
<OFDM>
DBMSTYPE = ODBC
<DWDEV>
DBMSTYPE = ODBC
<USA>
DBMSTYPE = ODBC
<DWHDEVT>
DBMSTYPE = ODBC
<LETSTEST>
DBMSTYPE = ODBC
<RPD1>
DBMSTYPE = ODBC
<FRSTEST>
DBMSTYPE = ODBC
<CCRT>
DBMSTYPE = ODBC
<BANCS>
DBMSTYPE = ODBC
<AOL>
DBMSTYPE = ODBC
I need your help to fix this issue. Actually I am new in this configuration area. Whenever you have time,please go through these.I will be obliged with your help.
Thanks,
Parameswar