I'd like to learn how to set up Alerts... I referenced the BI Portal v8.2.2 PDF (https://webfocusinfocenter.informationbuilders.com/wfappent/pdfs2/wfbiportal.pdf) on how to do so, and I started by creating my Alert Test file in InfoAssist. The code for my Test file is as follows:

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE transmetric/vwrevdetail
SUM VWREVDETAIL.VWREVDETAIL.TOTALREV
BY VWREVDETAIL.VWREVDETAIL.PERIODENDING
ON TABLE HOLD
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
END

-RUN


When trying to run that, I get the following error message:

No output was returned
Possible causes:
- Output was directed to a destination such as a file or printer
Detail:
0 NUMBER OF RECORDS IN TABLE= 187 LINES= 187
ACCESS LIMITED BY PASSWORD

I have Analyst access rights and am able to open and run this file outside of Alerts.

This message has been edited. Last edited by: drewtollenaar,

Edit vwrevdetail.mas and see if your id has DBA access to read the data it describes.

Even with your limited access, it seems that the test file is working : it return 187 lines.
Except if you're not supposed to be limited, all seems good to continue defining your Alert.

The goal of the Test file is to return a true/false condition to then have the Alert report performed or not.
In your case the answer is "true" since it returned 187 lines.
But you don't have any conditions or rules applied which may be missing into your Test file.
Except if the "test" is to see if data exist in the source file otherwise you should include a condition that will make the result (-IF &LINES EQ 0) to true only when requested.

You need the -IF &LINES EQ 0 statement (and following steps) to have you Alert properly defined.
See section "Reference: Alert Assist Sample Code Created With InfoAssist+" (page 237...) from referenced document of your post.

Thank you, MartinY! Your response was helpful - it appears to be all set up!

quote:

Originally posted by drewtollenaar:
Thank you, MartinY! Your response was helpful - it appears to be all set up!

Please update your first post then add [SOLVED] at the beginning of the subject