Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Timing Out Error

    Posted 08/03/20 12:17 PM
      |   view attached
    Good Afternoon, 

    I hope that you and yours are all doing well.  We are getting an encrypted time-out error as we attempt to run some of our reports.  Would you kindly explain how to fix this problem.  The error is attached.

    Warm Regards,
    Eli

    #CognosAnalyticswithWatson

    Attachment(s)

    pdf
    Cognos Timeout Error.pdf   65 KB 1 version


  • 2.  RE: Timing Out Error

    Posted 08/04/20 09:16 AM
    How long does the report run before encountering this error? What datasources are you using in the query/queries that you're using in the report?

    In my experience, timeouts can happen from the following below;
    1) Poor network connection quality between the report/query server, datasource connection and/or user.
    2) Long running-reports may require a look at the report and/or datasource queries and optimising them to run quicker either by re-designing the queries in the report or re-writing the datasource queries to rely on less aggregation during runtime and more on staged data.


    ------------------------------
    Mark Peterson
    ------------------------------



  • 3.  RE: Timing Out Error

    Posted 08/04/20 12:47 PM
    Edited by System Admin 01/20/23 04:16 PM
    Hi Elihu,

    I would recommend you open a ticket with IBM support.  Depending on what version you're on this could be a bug.  Even if not a bug they can help you figure out where the issue might be in your environment.


    Wayne

    ------------------------------
    Wayne Westlake
    ------------------------------



  • 4.  RE: Timing Out Error

    Posted 08/05/20 09:22 AM
    Hi Elihu,
    Is it some reports that always get this or various reports get this error at different times? The issue could be as simple as an overloaded system at specific times due to schedules being clumped together with longer running reports. So it may not be the reports showing the error but reports that came before it causing the issue.

    You may want to look through your audit database reports to see what is running at the time of the error.

    Mark has a good point with regards to longer running reports. There are a few good youtube videos that address this subject.
    IBM Cognos BI - Designing Reports for Performance - Part 1 (to  5)

    If you allow users to create reports directly in production without vetting them in a lower environment you do take a risk of having some performance issues.
    Cheers,
    Trevor

    ------------------------------
    TREVOR COMEAU
    ------------------------------



Related Content