Plugin failed to load TPT API Library in Informatica

General
Teradata Employee

Plugin failed to load TPT API Library in Informatica

We are facing the following issue in configuring TPT API library with Informatica 9.6.1.

 

We are using a different user for informatica services instead of root.

 

Please check below output.

 

etluat:/home/infauat > echo $TWB_ROOT                                 

/opt/teradata/client/14.10/tbuild

 

etluat:/home/infauat > echo $LD_LIBRARY_PATH

/usr/odbc/lib:/usr/odbc/drivers

 

etluat:/home/infauat > echo $PATH

/opt/teradata/client/14.10/tbuild/bin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/gvsd/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/resmon/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/perf/bin:/opt/ignite/bin:/opt/propplus/bin:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/langtools/bin:/opt/wlm/bin:/opt/gwlm/bin:/opt/aCC/bin:/opt/caliper/bin:/opt/cadvise/bin:/opt/sentinel/bin:/opt/networker/bin:/usr/bin:.:/orabin/ora/app/oracle/product/1120/db/bin:/orabin/ora/app/oracle/product/1120/db/lib:/apps/9.6.1/ODBC6.1/bin

 

etluat:/home/infauat > echo $NLSPATH

/opt/teradata/client/14.10/odbc_32/msg/%N:/opt/teradata/client/14.10/tbuild/msg/%N

 

And if we try to query the same on root user, below is the output:

 

etluat:[/]# > echo $TWB_ROOT

sh: /opt/teradata/client/14.10/tbuild: Execute permission denied.

 

etluat:[/]# echo $LD_LIBRARY_PATH

/usr/odbc/lib:/usr/odbc/drivers

 

etluat:[/]# echo $PATH

/usr/sbin:/opt/teradata/client/14.10/tbuild/bin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/gvsd/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/resmon/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/firefox:/opt/gnome/bin:/opt/perf/bin:/opt/ignite/bin:/opt/propplus/bin:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/langtools/bin:/opt/wlm/bin:/opt/gwlm/bin:/opt/aCC/bin:/opt/caliper/bin:/opt/cadvise/bin:/opt/sentinel/bin:/opt/networker/bin:/sbin:/home/root:/opt/aCC/bin:/orabin/ora/app/oracle/product/1120/db/bin:/orabin/ora/app/oracle/product/1120/db/lib:/apps/9.1/ODBC6.1/bin

 

etluat:[/]# echo $NLSPATH

/opt/teradata/client/14.10/odbc_32/msg/%N:/opt/teradata/client/14.10/tbuild/msg/%N

 

I have also attached the output log of the session. Anyone who can help in resolving this issue?

 

Thanks

Tags (2)