Consultor Eletrônico

Status: Verified

SYMPTOM(s):

AdminServer dies

Error in Fathomtrend database log file

Fathom cannot reach the trend database at
jdbc:jdbcprogress:T:localhost:4455:fathomdb. Check the log file for more
information. (9892)

SQL Server process terminated. (8841)

FACT(s) (Environment):

Fathom 2.0A
Linux Intel
Compaq Tru64 UNIX

CAUSE:

Fathom uses $DLC/bin/java_env to communicate with the SQL Server through the
JDBC driver each time it writes data to the FathomTrendDatabase. Due to a
problem in the java_env script, the shared library path variable might not be
set correctly on platforms where Progress does not ship the JDK/JRE. This would
prevent Fathom from reaching the Trend database. Progress currently does not
ship the JDK/JRE on Compaq Tru 64 and Linux.

FIX:

The fix is documented in Fathom Release note RN# 20A1-00105:

Fathom uses $DLC/bin/java_env to communicate with the SQL Server through the
JDBC driver each time it writes data to the FathomTrendDatabase. Due to a
problem in the java_env script, the shared library path variable might not be
set correctly on platforms where Progress does not ship the JDK/JRE. This would
prevent Fathom from reaching the Trend database. Progress currently does not
ship the JDK/JRE on Compaq Tru 64 and Linux.

Before starting the AdminServer on these platforms, perform the following steps:

1. Make a backup copy of the $DLC/bin/java_env file.

2. Open $DLC/bin/java_env in a text editor.

3. Move to the section of the java_env file specific to your operating system.

4. Change the line JREHOME=$JDKHOME to:

if [-d $JDKHOME/jre]
then
JREHOME=$JDKHOME/jre
else
JREHOME=$JDKHOME
fi

5. On Linux, change the LD_LIBRARY_PATH setting to:

LD_LIBRARY_PATH=$JREHOME/lib/$ARCH:$JREHOME/lib/$ARCH/$ {THREADS_FLAG
threads:$JREHOME/bin:$JREHOME/lib/$ARCH/$VMTYPE: $LD_LIBRARY_PATH

Without this change you will see a Fathom alert similar to the following:

Fathom cannot reach the trend database at
jdbc:jdbcprogress:T:localhost:4455:fathomdb. Check the log file for more
information. (9892)

In the fathom.lg file, you will see this message:

18:23:32 BROKER 0: SQL Server process terminated. (8841)

If this continues for several hours, it can cause the AdminServer to crash.