Clarity

Expand all | Collapse all

While we ran the Adhoc view and Report not getting the data displayed timeout error occured

  • 1.  While we ran the Adhoc view and Report not getting the data displayed timeout error occured

    Posted Jun 28, 2018 06:33 AM

    Recently we Upgraded the database from 12.1.0.2.0 to 12.2.0.1.0 version. We are facing the issue after upgradation in Advanced Reporting.

    While we execute Adhoc view and Reports the page is loading but not getting the data after some time timeout error occurred.

    Our DBA Increased the memory allocation from 4GB to 6GB and changed some DB parameter as well.

    First two or three times adhoc views and report data getting displayed. Next time same issue has happened.

     

    Kindly advice on this..is there any specific DB parameter need to change?



  • 2.  Re: While we ran the Adhoc view and Report not getting the data displayed timeout error occured

    Broadcom Employee
    Posted Jun 28, 2018 06:55 AM

    Hello Muthukumaran,
     
    I think you opened the question in the wrong CA Community, this the CA Database Management for Db2 and IMS (for z/OS) Community, this question should be opened in the CA PPM Community.
     
    https://communities.ca.com/community/ca-ppm
     
    Thanks.



  • 3.  Re: While we ran the Adhoc view and Report not getting the data displayed timeout error occured

    Posted Jun 28, 2018 07:14 AM

    Thank You Josep...



  • 4.  Re: While we ran the Adhoc view and Report not getting the data displayed timeout error occured

    Broadcom Employee
    Posted Jun 28, 2018 07:29 AM

    Database memory of 6GB seems too low, however there could be some database tuning that can be done. Can you share the oracle init.ora