Kbase P10360: SQL92 connections and Actuate ReportServer on AIX.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Actuate
IBM AIX
SYMPTOM(s):
Attempting to generate a report that uses the SQL-92 connection on the ReportServer.
Status No: 1 :
Basic Error: 1011
Module: db.bas
Line: 172
Database Error 20: The database interface DLLs or shared libraries could not be loaded.
CAUSE:
Actuate cannot locate the correct UNIX DLL/Library files on the UNIX Server; in particular, the Libesql92.so which is located in the PROGRESS/DLC/LIB directory. Actuate needs to use the Libacprg9.so file for SQL-92 connections. Unfortunately the file is not located in the $AcServer/lib directory on UNIX AIX Servers. This is why using Libesql9.so is a "workaround".
FIX:
1) Stop the Actuate ReportServer processes (sh shutdown_srvr.sh).
2) Amend the Reqserv5.sh file and add - $DLC/lib and $DLC/odbc/lib to the LIBPATH variable.
3) Re-start the Actuate ReportServer processes (sh start_srvr.sh).