SAP Knowledge Base Article - Preview

2719876 - "Fail to load esql library" error while Preparing IQ Database for Focused Run

Symptom

  • You are preparing your IQ database for SAP Focused Run.
  • This command works:

exe/saphostctrl -function SetDatabaseProperty -dbname SAPIQDB -dbtype siq -dbinstance SAPIQ_SERVER -dboption port=45678 -dboption iqhome=/usr/sap/sybase/server -dboption iqdir=IQ-16_0 -dboption dblocation=/usr/sap/sybase/data/db/SAPIQDB.db -dboption cfglocation=/usr/sap/sybase/data/db/SAPIQDB.cfg SIQENTRY=INSERT

  • However this one return errors:

execute exe/saphostctrl -function  SetDatabaseProperty -dbname SAPIQDB -dbtype siq -dboption user=DBA -dboption password=sql SIQUSERCREDENTIAL=INSERT
Error: Command execution failed. : Database software not installed (fault code: 127)
Operation ID: 5BA391FB7E3B0850E10080000A24075F
----- Log messages ----
Info: saphostcontrol: Executing SetDatabaseProperty
Error: sapdbctrl: Database software not installed
Error: saphostcontrol: SetDatabaseProperty failed (sapdbctrl exit code = 10)

  • You sourced the <IQ-HOME>/IQ.sh for sh, ksh, bash or <IQ-HOME>/IQ.csh for cs, and this command returns this:

/usr/sap/hostctrl/exe/saphostctrl -function ListDatabase
No databases found

  • Those messages are reported in the 

[PID 3407910] *** ERROR => Can't find installed IQ server [siqserver.cpp 2010]
[PID 3407910] *** ERROR => SAP IQ server dependent libraries must be in the search path [siqserver.cpp 2011]
[PID 3407910] *** ERROR => There are two options to resolve it [siqserver.cpp 2012]
[PID 3407910] *** ERROR => Option 1 - set SAP IQ environment manually before SAP Host Agent running [siqserver.cpp 2013]
[PID 3407910] *** ERROR => Option 2 - set iqhome and iqdir in the siqconfig.xml configuration file so that IQ runtime [siqserver.cpp 2014]
[PID 3407910] *** ERROR => can be set automatically [siqserver.cpp 2015]
[PID 3407910] *** ERROR => Fail to load esql library, check configuration in siqconfig.cfg [siqctrl.cpp 357]

  • SAP Host Agent version is =< 7.21 PL 39     

Read more...

Environment

  • SAP IQ 16.1
  • SAP Business Warehouse - All versions 
  • SAP Netweaver - All versions

Product

SAP Business Warehouse all versions ; SAP IQ 16.1 ; SAP NetWeaver all versions

Keywords

IQ, esql library, siqconfig, hostagent, SAP HostAgent, saphostctrl, focused run, saphostctrl, ListDatabase, "Database software not installed", "SetDatabaseProperty failed" , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.