We've previous accessed TimesTen 6.0 with perl scripts using the CPN DBD library without any issues. After upgrading to TimesTen 11.2, I'm getting the error below. The libraries are located in the location the error indicates. This is the last area where I'm having issues after upgrading to TT 11.2. Any suggestons?
executing: alltables SANTERA.SOFTWAREDELIVERY1%; quit;
DBI connect('driver=TimesTen;DSN=DynamicDBCS;TTC_SERVER=msclab52;UID=xxxxxx;PWD=xxxxx;AutoCreate=0','xxxxx',...) failed: [unixODBC][Driver Manager]Can't open lib '/opt/SANTone/msc/active/TimesTen/tt1121/lib/libttclient.so' : libttco.so: cannot open shared object file: No such file or directory (SQL-01000) at dbUpgradeUtilsOdbc.pm line 1130
ERROR: FAILED to open ODBC connection to DynamicDB on msclab52: [unixODBC][Driver Manager]Can't open lib '/opt/SANTone/msc/active/TimesTen/tt1121/lib/libttclient.so' : libttco.so: cannot open shared object file: No such file or directory (SQL-01000)
msclab52% ls -ltr /opt/SANTone/msc/active/TimesTen/tt1121/lib/libttclient.so
lrwxrwxrwx 1 root root 21 Jul 26 13:01 /opt/SANTone/msc/active/TimesTen/tt1121/lib/libttclient.so -> libttclient.so.gcc346*
msclab52% ls -ltr /opt/SANTone/msc/active/TimesTen/tt1121/lib/libttco.so
-rwxr-xr-x 1 root daemon 2160013 Jul 26 12:22 /opt/SANTone/msc/active/TimesTen/tt1121/lib/libttco.so*
Did you install the TT software properly on this machine (by using the installer script) or just copy it from another machine?
Is the environment under which the Perl script is running properly setup (by way of <tt_install_dir>/bin/ttenv.sh or similar)?
Does ttIsqlCS work okay and is it able to connect to the same DSN when run under the same environment?
Steps I performed:
1. Installed TT11.2 using setup script onto server51
2. Tarred up the installed directories and untarred the directories onto a development server.
3. Remove TT package from server51
3. Create a software package (tarball) containing both TT files and our application files.
4. Install our tarball back onto server51 from step one.
ttIsqlCS works in the same environment. I even added the environment variables created from ttenv.sh into the perl script itself without any luck.
That is not supported and there are many possibilities for things to go wrong (as you have found). Please re-install TimesTen properly and see if that resolves your problem. If you wish to 'embed' TimesTen with your application then you must deliver the full TimesTen installable package and run the official installer in 'silent' mode (see the Installation Guide for details on hwo to do that). Simply tarring/copying/untarring is not sufficient and will lead to problems in many cases.
Glad it is working now. I would like to emphasise that the method you are using to clone installations is not supported and will cause problems under some circumstances. I would strongly encourage you to adopt a supported method for silent installation. If you log an SR you will anyway be asked to reproduce the problem using a supported installation method so it is in your interests to do things properly.