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

• SAP IQ 16.1
• SAP Business Warehouse - All versions 
• 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