Maximum refresh exceptions reached every 4-6 hours

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi SailPoint team,

Our “Refresh Identity Cube” runs every 15 minutes, but the past several days, it is cancelling automatically when the task runs. Upon further detail the following is supposedly causing the error:

Maximum refresh exceptions reached
org.hibernate.exception.SQLGrammarException: could not execute statement
Task was terminated by user request

I have removed several hundred task results and it starts running successfully again, but the issue comes right back every 4-6 hours.

Please assist.

2

What is stopping it is the number of exceptions being thrown during the refreshes, I would be looking at your logs to see what those exceptions are.

1 Like
3

As suggested in the earlier response, I recommend beginning by examining the logs to identify the cause of the task failure. It is possible that the refresh task is taking an extended period, potentially resulting in a timeout. Take a closer look at the options enabled in your Identity Refresh (IR) tasks. Additionally, consider whether the identity refresh is executed as part of any workflows. To gather more information, enable the logger for sailpoint.task.IdentityRefreshExecutor and carefully observe the logs for relevant insights.

4

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.