Kbase P105893: Fathom database reports returning all zero values
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/10/2005 |
|
Status: Unverified
FACT(s) (Environment):
Fathom Management 3.0A
SYMPTOM(s):
Fathom database reports returning all zero values
Fathom Management installed on a cluster box
Database in question is a scripted database
Database in question resides on a cluster box
Fathom.lg file shows trending agent constantly connecting and disconnecting.
Scripted database's properties box in Fathom Management console shows three or more ip addresses
IP addresses are separated by comma and space
Increasing AdminServer logging level to 4 reveals errors from trending agent
* An SQL Exception occured during an insert into the trend database. SQLState: HY000 message: [JDBC Progress Driver]:Character string is too long (8184)
Running dbtool against fathom trend database finds no SQLWidth violation in the Cf_Resrc table
CAUSE:
The trending agent is attempting to insert an IP address longer than the SQLWidth defined for the Resrc_IP field. The default SQLWidth of this field is 30.
FIX:
Connect to the Fathom Trend Database via Data Dictionary and adjust the SQLWidth of REsrc_IP field in the Cf_Resrc table.