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 07:17 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 (Unable to Acquire conversation lock after 90 seconds)

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

    First two/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

    Posted Jun 28, 2018 07:46 AM

    This is a duplicate discussion, Please go to  While we ran the Adhoc view and Report not getting the data displayed timeout error occured  to respond or see others comments.