Custom Report Preview Throwing Exception

[kylechau_gt (Pak Shing Chau)]

Which IIQ version are you inquiring about?

Version 8.2

Please share any images or screenshots, if relevant.

Share all details related to your problem, including any error messages you may have received.

I have a custom report based on the Identity Request Status Report. It throws a system exception as illustrated in the screenshot without any error message available in the syslog. The error occurs particularly when the connection hits 30 seconds. When I applied a monthly filter, the report functioned correctly for each month of 2023, but it failed when filtered by year. Additionally, the report execution worked fine otherwise.

This issue appears to be related to a connection timeout. I’ve attempted to adjust the timeout settings in Tomcat, but these changes were unsuccessful. Is there a way to extend the timeout duration to prevent this exception? Thanks in advance.

[ipobeidi (Ivan Obeidi)]

These are the possibilities:

• Theres is a error in the Code
• The Foreground processing timeout, which is normal when you have alot of data and you click preview

To see if there’s a code error OR a timeout issue, run it in the background.

best

[kylechau_gt (Pak Shing Chau)]

@ipobeidi Thank you Ivan for your reply. I believe in this case, it’s a timeout issue as the background execution worked fine and it ran for 3 minutes. Do you think it’s possible instruct the user to run with a shorter timeframe or run it in the background through a generic UI popup message?

[kjakubiak (Kamil Jakubiak)]

Hi Pak,
I believe the easiest solution would be to disable live preview - with this move you force user to use fully executed report which does not have timeout and which will display data once task is executed

[ipobeidi (Ivan Obeidi)]

Awesome Pak!

Glad that we could help you!
Just rememenber to mark as a solution on the topic

[kylechau_gt (Pak Shing Chau)]

@ipobeidi @kjakubiak Sure, thank you both so much for the advice.