search cancel

Adhoc view is giving timeout error

book

Article ID: 243178

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

There is an Adhoc view which gives timeout error. The load balancer is set to timeout any HTTP request at 5 mins. It works fine for an admin user but not for an end user with restricted access.

Cause

The query that is produced by the Adhoc View runs for more than 5 mins on the database, for end users with restricted access.

Environment

  • Clarity PPM v15.9.2
  • Jaspersoft v7.8

Resolution

Reduce the amount of data fetched by the Adhoc View by using filters.