--- title: Managing Failed Reports in Cognos description: The best way to address one of the biggest challenges in managing a Cognos environment - how to identify and deal with failed reports. image: https://www.envisn.com/hubfs/images/failed.jpg --- [![envisn](https://www.envisn.com/hs-fs/file-15282154-gif/images/logo.gif?width=120&name=logo.gif "envisn")](https://www.envisn.com) [![Request a Demo](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/973f9256-ef61-4ab8-ab2d-a004a90a18be) [![cognos security as youve never seen it - learn more about netvisn](https://no-cache.hubspot.com/cta/default/70307/3166c389-8135-4d84-9988-99dc8d523426.png)](http://cta-redirect.hubspot.com/cta/redirect/70307/3166c389-8135-4d84-9988-99dc8d523426) # Envisn's IBM Cognos Blog ## [Managing Failed Reports in Cognos](https://www.envisn.com/envisn-cognos-blog/managing-failed-reports-in-cognos) Posted by [The Envisn Team](https://www.envisn.com/envisn-cognos-blog/author/the-envisn-team) - [Tweet](https://twitter.com/share) *![failed report in cognos](https://www.envisn.com/hs-fs/hubfs/images/failed.jpg?width=200&name=failed.jpg "failed report in cognos")By Paul Hausser, [Envisn, Inc. ](https://www.envisn.com/)*One of the biggest challenges in managing a Cognos environment is how to identify and deal with failed reports. This blog is focused on the best way to address this problem. ### Failed Reports in Cognos 10 Using the Administration feature in Cognos 10 you are able to identify failed reports but the way this is done has some limitations that make it difficult to quickly manage and resolve these. Some of these issues include: - *There is no consistent location information provided on failed reports. * - *No ability to aggregate failed reports. For example, it might be good to do this by owner and/or location for faster problem resolution. * - *Owner detail is not available at the summary level (see **Figure 1**), and in some cases, at the detail level. * - *Cognos retention data not available such as number of days or schedules. * - *No ability to be able to see errors or problems over time by object. * - *It’s not possible to do any trend analysis of this data. * *![cognos failed report summary detail](https://www.envisn.com/hs-fs/hubfs/images/failed-fig1.jpg?width=777&name=failed-fig1.jpg "cognos failed report summary detail")* In a large environment where there are likely to be a number of failed objects it can be very tedious to have to sort through this detail data and aggregate it manually. What’s needed is some flexibility around being able to select the detail information you need and then be able to aggregate it the way you need it for getting these reports fixed. ### A Better Way? Envisn’s [NetVisn](https://www.envisn.com/netvisn) product is able to address many of these shortcomings and makes it possible to get all the key information at once. ***Figure 2*** shows how we can use the analytics capability within NetVisn to select the object types we want to look at and also the execution status. Here we’re selecting all object types and failed status. We can also select how we want this data grouped (location) and what additional data we want included with it such as owner execution date, owner, etc. This will enable us to get this to the owner of each object so it can be fixed. ![fix failures in cognos using netvisn analytics](https://www.envisn.com/hubfs/images/failed-fig2.jpg "fix failures in cognos using netvisn analytics") In ***Figure 3*** we see that results of our analysis that shows the detailed information for the report *Order Details by Page* which is scheduled to run on a weekly basis. This includes folder location, status, execution date/time, completion time and owner. It also includes an error message; in this case it appears to be an unresolved prompt. NetVisn also has the ability to do mass updates for reports that have problems with data lineage, missing objects or other issues so getting these fixed quickly. ![analysis results for failed report in cognos](https://www.envisn.com/hubfs/images/failed-fig3.jpg "analysis results for failed report in cognos") In ***Figure 4*** we see part of the NetVisn documentation for this report showing history for the past 10 weeks. Note that this shows that the report ran successfully for the past two weeks after it was fixed. ![failed report history in netvisn](https://www.envisn.com/hubfs/images/failed-fig4.jpg "failed report history in netvisn") The user also has the option to output to Excel so if you wanted to sort this information by report owner, for example, you could send this information directly to the responsible person for each object. ### Summary The most important thing for a Cognos administrator is to maximize up time performance of their environment and minimize the amount of time devoted to routine tasks they have to deal with on a daily basis. Having the right tools to do this quickly and easily is essential to being successful. [![see why envisn customers sat netvisn is essential for cognos bi](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/90ba4bde-4b41-4c1d-a6a5-03dc04736da3.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/90ba4bde-4b41-4c1d-a6a5-03dc04736da3) *© [Envisn, Inc.](https://www.envisn.com/envisn-products), All Rights Reserved.* Topics: [Cognos 10](https://www.envisn.com/envisn-cognos-blog/topic/cognos-10), [Cognos BI administration](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-administration), [Cognos Analytics](https://www.envisn.com/envisn-cognos-blog/topic/cognos-analytics) *Your feedback is very important to us - we’d love to hear your comments!* ### Subscribe to Envisn's IBM Cognos Blog ### Posts by Category - [Cognos Content Store (22)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-content-store) - [Cognos BI Best Practices (21)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-best-practices) - [Cognos Analytics (19)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-analytics) - [Cognos BI administration (19)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-bi-administration) - [Cognos Security (18)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-security) - [Cognos Tools (14)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-tools) - [Cognos Audit Data (11)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-data) - [Cognos Reporting (9)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-reporting) - [Cognos Auditing (8)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-auditing) - [Cognos 10 (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-10) - [Cognos Framework Manager (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-framework-manager) - [Cognos Metadata (7)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-metadata) - [BI Trends (6)](https://www.envisn.com/envisn-cognos-blog/topic/bi-trends) - [IBM Information on Demand (6)](https://www.envisn.com/envisn-cognos-blog/topic/ibm-information-on-demand) - [Cognos Audit Log (5)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-audit-log) - [cognos impact analysis (4)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-impact-analysis) - [Big Data (3)](https://www.envisn.com/envisn-cognos-blog/topic/big-data) - [Cognos Data Sources (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-sources) - [Cognos Documentation (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-documentation) - [Cognos Scheduling (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-scheduling) - [Product Information (3)](https://www.envisn.com/envisn-cognos-blog/topic/product-information) - [cognos data lineage (3)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-lineage) - [Archiving Cognos Content (2)](https://www.envisn.com/envisn-cognos-blog/topic/archiving-cognos-content) - [Cognos FM Model (2)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-fm-model) - [Cognos migration (2)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-migration) - [Announcements (1)](https://www.envisn.com/envisn-cognos-blog/topic/announcements) - [Cognos Change Management (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-change-management) - [Cognos Data Provenance (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-data-provenance) - [Cognos Hotfiles (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-hotfiles) - [Cognos Powerplay (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-powerplay) - [Cognos Triggers (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-triggers) - [Consolidating Cognos Environments (1)](https://www.envisn.com/envisn-cognos-blog/topic/consolidating-cognos-environments) - [Impromptu (1)](https://www.envisn.com/envisn-cognos-blog/topic/impromptu) - [Merging Content Stores (1)](https://www.envisn.com/envisn-cognos-blog/topic/merging-content-stores) - [Remote Cognos Management (1)](https://www.envisn.com/envisn-cognos-blog/topic/remote-cognos-management) - [cognos deployments (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-deployments) - [cognos fm model documentation (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-fm-model-documentation) - [cognos workspace (1)](https://www.envisn.com/envisn-cognos-blog/topic/cognos-workspace) - [netvisn (1)](https://www.envisn.com/envisn-cognos-blog/topic/netvisn) [see all](https://www.envisn.com/envisn-cognos-blog/managing-failed-reports-in-cognos#) ### Posts by Popularity [![All of your Cognos content is automatically documented and always up to date in netvisn - learn more](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/269574df-4f0b-47e0-9735-15f12633192e.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/269574df-4f0b-47e0-9735-15f12633192e) [![Learn how Netvisn can solve your specific needs and challenges Sign Up for a Personalized Demo](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/70307/c764cb9d-e3c2-4a91-9564-d666f1f5c7e1.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/70307/c764cb9d-e3c2-4a91-9564-d666f1f5c7e1) ### [Cognos Tools from Envisn](https://www.envisn.com/envisn-products) [NetVisn](https://www.envisn.com/netvisn) [AutoVisn](https://www.envisn.com/autovisn-cogos-scheduler) [UniVisn](https://www.envisn.com/univisn-cognos-performance-management) [DocuVisn](https://www.envisn.com/docuvisn-cognos-documentation) ### [Cognos Resources](https://www.envisn.com/resources) [Envisn’s IBM Cognos Blog](https://www.envisn.com/envisn-cognos-blog) [Custom Query Library](https://www.envisn.com/custom-query-library) [Tutorial Videos](https://www.envisn.com/cognos-demo-videos) [Mastering Cognos Security](https://www.envisn.com/mastering-ibm-cognos-security) [Content Store Survival Guide](https://www.envisn.com/content-store-survival-guide) [Expert Guide to Cognos Audit Data](https://www.envisn.com/cognos-audit-data-expert-guide) ### [Contact Envisn](https://www.envisn.com/contact) [Request a Demo](https://www.envisn.com/request-a-demo) [Support](https://www.envisn.com/support) 512-991-3999 [info@envisn.com](mailto:info@envisn.com) ### Latest Cognos Posts | [![youtube](https://www.envisn.com/hs-fs/hubfs/youtube.png?width=30&name=youtube.png)](https://www.youtube.com/user/envisn) | [![linkedin](https://www.envisn.com/hs-fs/hubfs/linkedin.png?width=30&name=linkedin.png)](https://www.linkedin.com/company/envisn-inc./) | [![twitter](https://www.envisn.com/hs-fs/hubfs/twitter.png?width=30&name=twitter.png)](https://twitter.com/Envisn) | [![facebook](https://www.envisn.com/hs-fs/hubfs/facebook.png?width=30&name=facebook.png)](https://www.facebook.com/envisn/) | | --- | --- | --- | --- | [![Real Time Analytics](https://static.getclicky.com/media/links/badge.gif)](http://clicky.com/101126274) ![Clicky](https://in.getclicky.com/101126274ns.gif) 3000 Polar Lane, Suite 901, Cedar Park, TX 78613 USA *Serving North America, Europe, and the UK with plans to expand to other areas in the near future. **[Privacy, Copyright & Liability](https://www.envisn.com/privacy-copyright-liability)*