Symptom
After creating ocs.cfg under $SYBASE_OCS/config directory to enable external configuration
insert .. location '' { select .. } job in IQ fails with following error
---
Could not execute statement.
Connectivity libraries cannot be found (check your dynamic library
search path). Selects from attached databases are not possible without
these libraries.
-- (hqmlib/hqm_cpm.cxx 154)
SQLCODE=-1003005, ODBC 3 State="HY000"
Line 1, column 1
---
Even though error complains about dynamic library search path, LD_LIBRARY_PATH is set and consists of open client directories
eg.
--
$ echo $LD_LIBRARY_PATH
/work2/sap/IQ16SP08PL30/IQ-16_0/lib64:/work2/sap/IQ16SP08PL30/OCS-15_0/lib:/work2/sap/IQ16SP08PL30/OCS-15_0/lib3p64:/work2/sap/IQ16SP08PL30/OCS-15_0/lib3p:
--
All open client dynamic libraries are present , not missing & with proper permissions.
eg.
--
$ pwd
/work2/sap/IQ16SP08PL30/OCS-15_0/lib
$ ls -l libsybc*.so
-rwxr-xr-x 1 sap sybase 750807 Jul 15 2014 libsybcomn.so
-rwxr-xr-x 1 sap sybase 870746 Jul 15 2014 libsybcomn64.so
-rwxr-xr-x 1 sap sybase 770039 Jul 15 2014 libsybcomn_r.so
-rwxr-xr-x 1 sap sybase 891318 Jul 15 2014 libsybcomn_r64.so
-rwxr-xr-x 1 sap sybase 84330 Jul 15 2014 libsybcs.so
-rwxr-xr-x 1 sap sybase 92162 Jul 15 2014 libsybcs64.so
-rwxr-xr-x 1 sap sybase 88670 Jul 15 2014 libsybcs_r.so
-rwxr-xr-x 1 sap sybase 97076 Jul 15 2014 libsybcs_r64.so
-rwxr-xr-x 1 sap sybase 612403 Jul 15 2014 libsybct.so
-rwxr-xr-x 1 sap sybase 737637 Jul 15 2014 libsybct64.so
-rwxr-xr-x 1 sap sybase 616557 Jul 15 2014 libsybct_r.so
-rwxr-xr-x 1 sap sybase 741103 Jul 15 2014 libsybct_r64.so
--
Process tracing tools like strace does not show any dynamic library opened.
eg.
-- Collect trace during problem occurence & see which open client dynamic library is getting loaded
$ strace -f -r -T -tt -s 128 -o strace.out -p 11785
$ grep OCS strace.out
11833 0.000072 open("/work2/sap/IQ16SP08PL30/OCS-15_0/config/ocs.cfg", O_RDONLY) = 28 <0.000024>
11833 0.000071 open("/work2/sap/IQ16SP08PL30/OCS-15_0/config/ocs.cfg", O_RDONLY) = 28 <0.000024>
--
Read more...
Environment
SAP IQ All Versions
Product
Keywords
insert location ocs.cfg hqm_cpm.cxx "Selects from attached databases are not possible" , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview