While aggregating data I am getting exception " could not extract ResultSet", I think that some responses or objects are just to big ?
In aggregation I am using Parent/ Child, Paging, and partitioning. I think possible solution can be lower page size and objects per partition. Also it can be related to connection, just connection taking too long and it was closed.
p.s one account can have >84.000 assignments.
Parent request for Accounts
Child request for account assignments by account id
current page size 40
current objects per partition 5
Hi @kskendelis
This could possibly because of the large dataset you are trying to process. Are all these 84000 assignments of the users being managed via SailPoint, if not try ways to reduce this count. It can have big impact on SailPoint performance.
1 Like
What I can do without reducing number of assignments? Additional changes to application? To MySQL? Maybe adding additional resources to server?
Enable the loggers try to find out what exactly is causing this issue?
Some changes to MySQL db seems fixed my problem :
#SET GLOBAL max_allowed_packet = 536870912;
No more errors:
2 Likes
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.