Element Entries Report not running

Summary

SQL query time exceeds the limit (500 sec). Stopped processing.

Content

Hi,

I'm trying to run this report using just 1 legal entity on between dates: 01/08/2019 to 30/09/2019

I'm getting the following error message:

SQL query time exceeds the limit (500 sec). Stopped processing.

oracle.xdo.memoryguard.XDOQueryTimeoutException: SQL query time exceeds the limit (500 sec). Stopped processing.

Does anyone have an idea what this means?

Thanks,

Andy

 

 

Version

19C

Code Snippet

/*
Report No      : REP_0021
Report Name    : Payroll Dashboard = Element Entry Changes
Developer             : Kaushik Prathikantam
Change History
Version   Date        Developer                            Comments
1.0       04/02/2018  Kaushik Prathikantam  Original Version 
*/

SELECT PEAI.EXT_IDENTIFIER_NUMBER  LEGACY_NUMBER,
       PAPF.PERSON_NUMBER,