# AD Application aggregation error **URL:** \ **Category:** IIQ Discussion and Questions\ **Tags:** identityiq, provisioning\ **Created:** [December 6, 2023, 12:44pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238 "2023-12-06T12:44:03Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ayadav\_12](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@ayadav\_12](https://developer.sailpoint.com/discuss/u/ayadav_12)\ **Post date:** [December 6, 2023, 12:44pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/1 "2023-12-06T12:44:03Z")
### Which IIQ version are you inquiring about? Version 8.2 ### Share all details related to your problem, including any error messages you may have received. Hi, We are receiving error from ad application during aggregation the test connection is working fine but how we can fix this error. Below is the error Exception during aggregation of 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789 0123456789. Reason: org.hibernate.exception.DataException: could not execute statement ---
**Author:** ![kjakubiak](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kjakubiak/32/7052_2.png) [@kjakubiak](https://developer.sailpoint.com/discuss/u/kjakubiak)\ **Post date:** [December 6, 2023, 1:41pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/2 "2023-12-06T13:41:30Z")
Hi Amit, Anything more in logs? I suspect there might be a bit more data in the error - see in syslog in advanced analytics if there is no more details or in the sailpoint log files. This exception suggests problem with HBM which usualy might be anything 😃 ---
**Author:** ![vinnysail](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vinnysail/32/17001_2.png) [@vinnysail](https://developer.sailpoint.com/discuss/u/vinnysail)\ **Post date:** [December 6, 2023, 1:51pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/3 "2023-12-06T13:51:50Z")
Can you check if its failing for all users with same error or just for few users? Please try to run single account aggregation to see if that works. See if you can get xml for an account from iiq console using below conn appName get account nativeIdentity ---
**Author:** ![ayadav\_12](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@ayadav\_12](https://developer.sailpoint.com/discuss/u/ayadav_12)\ **Post date:** [December 7, 2023, 1:10pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/4 "2023-12-07T13:10:38Z")
Hi @kjakubiak , Below is the error i found in syslog. “sailpoint.tools.GeneralException: org.hibernate.exception.DataException: could not execute statement at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:553) at sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceManager.java:207) at sailpoint.server.InternalContext.commitTransaction(InternalContext.java:557) at sailpoint.api.Aggregator.finishLastIdentity(Aggregator.java:4684) at sailpoint.api.Aggregator.aggregateAccount(Aggregator.java:3551) at sailpoint.api.Aggregator.aggregateAccounts(Aggregator.java:3242) at sailpoint.api.Aggregator.primaryAccountAggregation(Aggregator.java:2822) at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2670) at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2571) at sailpoint.api.Aggregator.execute(Aggregator.java:2221) at sailpoint.request.AggregationRequestExecutor.execute(AggregationRequestExecutor.java:95) at sailpoint.request.RequestHandler.run(RequestHandler.java:163) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511) at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283) at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98) at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:538) … 11 more Caused by: org.hibernate.exception.DataException: could not execute statement at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3356) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3229) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3630) at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454) … 20 more Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column ‘display\_name’ at row 1 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:637) at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:418) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) … 29 more” ---
**Author:** ![kjakubiak](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kjakubiak/32/7052_2.png) [@kjakubiak](https://developer.sailpoint.com/discuss/u/kjakubiak)\ **Post date:** [December 7, 2023, 1:12pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/5 "2023-12-07T13:12:33Z")
Thanks That’s the root cause of the problem ![image](https://global.discourse-cdn.com/sailpoint/original/2X/d/d1c964bd8a4d2a70f61ed7612b42d15c0f62cc09.png) Value that is in display\_name is too long for the column. ---
**Author:** ![ayadav\_12](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@ayadav\_12](https://developer.sailpoint.com/discuss/u/ayadav_12)\ **Post date:** [December 7, 2023, 1:29pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/6 "2023-12-07T13:29:25Z")
@kjakubiak , Thanks for providing the exact issue. Can you also help me how can i find this user which is causing this issue. Regards Amit ---
**Author:** ![kjakubiak](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kjakubiak/32/7052_2.png) [@kjakubiak](https://developer.sailpoint.com/discuss/u/kjakubiak)\ **Post date:** [December 7, 2023, 1:38pm UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/7 "2023-12-07T13:38:06Z")
I would suggest to write simple customization rule to print to logs all the data you are receiving from the connector. That would show you when the processing fails. ---
**Author:** ![ayadav\_12](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@ayadav\_12](https://developer.sailpoint.com/discuss/u/ayadav_12)\ **Post date:** [December 18, 2023, 8:40am UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/8 "2023-12-18T08:40:48Z")
Thank you @kjakubiak , Can you please provide how should i write the rule and apply to get the logs. that would be very helpful. Regards Amit ---
**Author:** ![kjakubiak](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/kjakubiak/32/7052_2.png) [@kjakubiak](https://developer.sailpoint.com/discuss/u/kjakubiak)\ **Post date:** [December 18, 2023, 11:48am UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/9 "2023-12-18T11:48:44Z")
Hi Amit, That would be something like this ```auto log.error(object.toXml()); return object; ``` ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [February 16, 2024, 11:49am UTC](https://developer.sailpoint.com/discuss/t/ad-application-aggregation-error/22238/10 "2024-02-16T11:49:12Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.