SAP Knowledge Base Article - Preview

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


  • 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>/ 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 SP 41     



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


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


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 for Me (Login required).

Search for additional results

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