BusinessObjects Board

List of Failed Reports in CMC

Hi Everyone,

I know the CMS database is cryptic or unclear but does anyone have a sql to list out all the failed reports or any view code which converts all cryptic information to some readable information?

Thanks in advance
Kum


kum007 (BOB member since 2007-06-08)

Hi,

If you are talking about scheduled reports then this utility may help:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Information stored within the CMS are readable using CMS sdk. You can also have a look to the instance manager.

In Query Builder, for scheduled reports, SI_SCHEDULE_STATUS=3 means a scheduled report has failed, and SI_SCHEDULE_INFO.SI_OUTCOME gives the further information about the error.


newgun :us: (BOB member since 2007-08-01)

Looking for something like this but i’m also looking for an email option. I want all list of failed reports in some excel spreasheet with detail description why they failed and want this file to be sent to an email address.

Thank you
Kum


kum007 (BOB member since 2007-06-08)

The only way to do that is to use SDK.


newgun :us: (BOB member since 2007-08-01)