Kbase P114850: There were no samples selected for this report when running Resource Alert Summary Report
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/02/2008 |
|
Status: Unverified
FACT(s) (Environment):
Fathom Management 2.X
Fathom Management 3.X
All Supported Operating Systems
SYMPTOM(s):
There were no samples selected for this report when running Resource Alert Summary Report
Resource Alert Summary Report returns no data when run from Fathom Management
resource, date, format selection always reports "No samples selected".
Modifying report template did not help
Querying Fathom trend database shows data are available
CAUSE:
The "No samples selected" is because src/alertgeneral.p does not increment Fathom-rec-count variable. Regardless how many samples were obtained by src/alertgeneral.p
we are always passing 0 into src/xml-alertgeneral.p.
CAUSE:
Bug# OE00130722
FIX:
This issue has been fixed in Fathom Management 3.1A02 and OpenEdge Management 10.1B
The source code is supplied in $FATHOM/src/fathom4gl-p.pl. To extract the sources from library, you will need to use Progress core executable 'prolib'. Open src/xml-alertgeneral.p and uncomment the sample counter in the following lines:
Fathom-rec-count = 0.
for each data_store:
fathom-rec-count = fathom-rec-count + 1.
END.
(before the line starting: IF Fathom-Rec-Count LT 1 THEN )
This will fix the problem, as the correct number of records in the data_store temp-table (samples) will be returned.
Note: either the src/xml-alertgeneral.p needs to be compliled, or the necessary include files need to be available in the PROPATH
COMPILE src/xml-alertgeneral.p SAVE INTO src/.
go to Fathom -> Reports -> Report Templates -> alertGeneral
in "Source of eligible resources", check "All resources in the trend database",
save the template and recreate the Resource Alert Summary Report.
The Fathom Trend database can also be queried with 4GL against the cf_Alert_detail for example:
prowin32 -db fathom -H localhost -S <port_number> -U guest -P guest
DEFINE VARIABLE iCount AS INTEGER NO-UNDO.
iCount = 0.
FOR EACH cf_Alert_detail
WHERE Alert_Date > 01/13/2008
NO-LOCK:
iCount = iCount + 1.
END.
MESSAGE STRING(iCount)
VIEW-AS ALERT-BOX INFO BUTTONS OK.