Question

ifs 9 sql report aborts at 30 minutes - is there a setting to change


Badge +3

The sql query report aborts in ifs 9 PROD environment at 30 minutes but runs in TEST environment about 1 hour and completes. Is there an IFS setting to change how long a report can run?


2 replies

Userlevel 7
Badge +31

Hi @jstanley,

Please run the IFS installer in reconfiguration mode and try increasing the “Statement execution timeout” value in “Connection Pool for PL/SQL Access” window. The default is set to 1800 seconds, which is 30 minutes. 

See the following documentation regarding this. Although this is from IFSAPP10 documentation, these parameters have not changed since IFSAPP9.

https://docs.ifs.com/techdocs/foundation1/020_installation/500_references/020_ifs_applications_installer/020_ui_reference_itd/035_ifs_home_itd/117_plsql_sess/default.htm

Hope this helps!

Badge +3

thank you! I will check it out

Reply