Kbase 21818: Actuate ReportServer on AIX and SQL92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/02/2002 |
|
SUMMARY:
This Solution Entry applies to Actuate ReportServer versions 4 or 5 on UNIX, especially IMB AIX.
You might experience the following error when 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.
EXPLANATION:
This is because 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".
SOLUTION:
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).
One other option might be to copy the libesql92.so, rename it to libacprg9.so and place it in $AcServer$/lib.