Which IIQ version are you inquiring about? 8.4P1 Please share any images or screenshots, if relevant. [image] [image] Share all details about your problem, including any error messages you may have received. Getting two errors when running account aggregation for LDAP application type: An erro…

Hi @Naidu_Reddi , the shared post did not share the exact steps they took to fix the issue. Could you elaborate?

Open the ‘my.ini’ file under the MySQL server installation directory. Search for the ‘max_allowed_packet’ parameter. If the file does not have it, add the parameter. Set the value as needed. To set the value to 0.5GB, enter the value as one of the following: max_allowed_packet=536870912 Restart the…

Hi @Naidu_Reddi , Then I would like to understand why without partitioning the account aggreagtion works?

Hi @Naidu_Reddi FYI, we are using AzureSQL, not MySQL

Hi @Naidu_Reddi , can I check how do I edit the value for AzureSQL?

Hi @shijingg , Could you please share the log from Catalina? We encountered an error that states, “org.hibernate.exception.SQLGrammarException: could not execute statement.” I notice a similar error occurs when the data length or format is unsupported for the account-level attribute size or data ty…

Hi @SivaLankapalli , but I would like to understand why does this only occur when the account aggregation task is partitioned?

Hi @shijingg , It would be helpful if you could share only the error log and provide a solution Have you created any account attributes? Are you using optimized aggregation in full aggregation? Thanks, @SivaLankapalli

LDAP application account aggregation error

IdentityIQ (IIQ) IIQ Discussion and Questions

Naidu_Reddi (Reddi Appalanaidu) April 17, 2025, 4:21am 2

Refer Could not extract ResultSet

Topic		Replies	Views
Account aggregation not working when Partition enabled IIQ Discussion and Questions identityiq	5	109	February 9, 2026
Unable to aggregate all accounts IIQ Discussion and Questions aggregation , identityiq , connectors	8	230	June 28, 2025
Errors in Unoptimized partitioned AD account aggregation IIQ Discussion and Questions aggregation , identityiq , active-directory	2	41	January 31, 2026
Azure AD aggregation issue - processReadRequest nullpointer exception IdentityIQ (IIQ)	3	2726	April 28, 2022
AD Application aggregation error IIQ Discussion and Questions identityiq , provisioning	9	741	February 16, 2024

LDAP application account aggregation error

Related topics