SAP Knowledge Base Article - Preview

2158964 - "Connectivity libraries cannot be found" on Insert Location - SAP IQ

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

SAP IQ all versions

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.