Ad Hoc Report using out of the box Domain times out in GCP

Products

• Clarity PPM SaaS

Issue/Introduction

You have an Ad Hoc report that is timing out.  It is using an out of the box domain, for example Project Management

Environment

Release : 16.1.2, 16.1.3

Postgres / GCP

Cause

The query is timing out due to a large join/merge.

 

Resolution

Try to reduce the amount of data being returned by using a filter.

Alternatively, there may be parameters on the database that support can take a look at by opening a support case.