Skip to main content

Knowledge Document: Vertica Odbc Loader Package fails with error

  • March 31, 2025
  • 0 replies
  • 1 view

coest_opentext_com
Forum|alt.badge.img

Environment

Vertica Analytics Platform 12.0.4
 

Situation


Installing ODBC loader package fails. Error message is indicating there is a missing file or directory.

[dbadmin@EUSIGNVERTPRD01 odbc_loader_package]$ make install
# install ODBCLoader
Password:
vsql:ddl/install.sql:2: ROLLBACK 2175: An error occurred when loading library file on node v_ixdw_node0027, message:
Failure in UDx RPC call InvokeCheckLibrary(): Error calling setupExecContext() in User Defined Object [] at [/data/jenkins/workspace/RE-ReleaseBuilds/RE-Knuckleboom_2/server/vertica/OSS/UDxFence/vertica-udx-C++.cpp:241], error code: 0, message: Error happened in dlopen(): [libpcrecpp.so.0: cannot open shared object file: No such file or directory]
vsql:ddl/install.sql:3: ROLLBACK 3861: Library not found: ODBCLoaderLib
vsql:ddl/install.sql:4: ROLLBACK 3861: Library not found: ODBCLoaderLib
vsql:ddl/install.sql:7: ROLLBACK 2059: Source with specified name and parameters does not exist: ODBCSource
vsql:ddl/install.sql:8: ROLLBACK 2059: Parser with specified name and parameters does not exist: ODBCLoader

Find complete article here