Focal Point
Report Caster - Burst value does not exist in the distribution file.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5611049132

June 10, 2007, 11:00 PM
newtofocus
Report Caster - Burst value does not exist in the distribution file.
When we burst a report using a distribution file we are finding that caster does not give any error message if the burst value is not in the distribution file. However it does give an error when the burst value is in the address book and there is nothing to distribute for this value in the report.

Is there any way to capture the burst value for which no entry in the distribution list(file) exists.


WF7.1.4 Prod/Test, MRE, self serve, DM
June 11, 2007, 06:38 AM
hammo1j
I think you can set a catch all using Burst value of *. Then you would email this to yourself and when you got email you would know there are values unaccounted for.

Could be wrong tho.

Another harder alternative would be to MATCH FILE the distribution list and the final report.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
June 11, 2007, 12:32 PM
Darin Lee
Have you checked on this? I don't believe there is a "catch all" value. The report has already been burst by sort value, then it is compared against the distribution list to determine destinations. Unless * were an actual burst value, it would not know to send all "unclaimed" burst sections to a specified recipient.
That being said, the way we work around this is to create a defined field on the BY field used for bursting, with a DECODE and an ELSE value of "Unknown." Then we burst on that field instead and send the "Unknown" to someone who can modify the distribution list for those values.
In many cases, we simply don't want to account for EVERY possible burst value so it makes sense that RC would want you to approach this in your own procedures, instead of within the product itself. I know it's still a pain, though.
FYI, my gripe is the opposite of yours. Sometimes all the burst values don't exist (due to volume, business activity or lack thereof, run time, etc.), so it logs a ton of error/warning messages and sends error reports, even though I could care less that a specific burst value has no report .


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat