Monitoring for failed broadcast jobs should occur daily.
- To access the broadcast logs use Tcode: RSRD_ADMIN and click on the ‘Log Display’ button.
- Enter in a date range from the date that the last monitoring occurred to today’s date and remove the User Name filter. Execute the program.
- Any log entries with a red marker next to them indicate a failed broadcast. A yellow marker indicates a warning message, either in relation to the users account or the workbook/query being executed. Action is usually only warranted for red/failed logs. Expand the log to see the broadcast setting, affected user (if the setting is authorized and there are recipients listed) and failure reason.
- All failed broadcasts are also added to table RSR_PREC_SETT with a date stamp for when they failed. Review the list of broadcasts that are collected in this table against the failure reasons listed in the above log looking for the following:
- Any broadcast settings that failed partially, meaning that it is a User Specific broadcast job that failed for only some of the recipients (See Appendix B for more information of User Specific Broadcasts). If this is the case, a temporary copy of the broadcast job should be created with only the failed users set as the recipient. (To open the individual broadcast setting within the portal environment, see Appendix A.) This temporary setting should be scheduled and the original broadcast setting should be removed from table RSR_PREC_SETT.
- Any broadcast settings that failed due to the ‘owner’ having an expired password. The owner of the broadcast job should be contacted and be advised to reset their BW password prior to the jobs being restarted.
- Any broadcasts that failed due to an error in how the workbook was developed. If the workbook was not created by the BI team, contact the workbook owner to have them resolve the issue. Remove the broadcast setting from the RSR_PREC_SETT table and do not restart until the workbook is repaired.Once the entries in table RSR_PREC_SETT have been reviewed and cleaned up, program RSR_PREC_SETTINGS_RESTART can be executed. This program will restart the broadcast jobs listed in table RSR_PREC_SETT. This program can be executed either with or without a date stamp. If no date stamp is entered, ALL jobs in the table will be restarted.
- Once the entries in table RSR_PREC_SETT have been reviewed and cleaned up, program RSR_PREC_SETTINGS_RESTART can be executed. This program will restart the broadcast jobs listed in table RSR_PREC_SETT. This program can be executed either with or without a date stamp. If no date stamp is entered, ALL jobs in the table will be restarted.