Report Definition running for too long and stops responding.
I am having a Report Definition with a single class join. Records in both the data classes are around 20000. When i try to run the report, it runs for too long and stops responding. webpage throws some HTTP:504 error(Please refer the attached screenshot of the error). I assume this is due to huge data that needs to be fetched. But, i need an extract of this data. some one help me with this.
That error is very abstract and we really cannot get anything out of it.
Its just a gateway time out.
On the joins, please understand that removing the joins won't help, adding proper joins will help to filter unnecessary data. (in the context of inner join)
But I see that according to your requirement, there is just this 1 join condition that can help. Please see if there are any other columns on which we can add joins, or are we sure if we added all the filter criteria that is needed under the where clause ?
Can you please extract the SQL from the tracer and run it directly on the SQL client to see how long is it running ?
Can you please evaluate the PegaRules and Alerts log to see if there are any entries because of this query ?