AD Application aggregation error

ayadav_12 · December 6, 2023, 12:44pm

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

kjakubiak · December 6, 2023, 1:41pm

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

vinnysail · December 6, 2023, 1:51pm

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

ayadav_12 · December 7, 2023, 1:10pm

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”

kjakubiak · December 7, 2023, 1:12pm

Thanks
That’s the root cause of the problem

Value that is in display_name is too long for the column.

ayadav_12 · December 7, 2023, 1:29pm

@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

kjakubiak · December 7, 2023, 1:38pm

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.

ayadav_12 · December 18, 2023, 8:40am

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

kjakubiak · December 18, 2023, 11:48am

Hi Amit,
That would be something like this

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE Rule PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<Rule language="beanshell" name="ResourceObjectLogRule" type="ResourceObjectCustomization">
  <Source>
log.error(object.toXml());
return object;
  </Source>
</Rule>

system · February 16, 2024, 11:49am

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

Topic		Replies	Views
Getting error on Active Directory group aggregation after 8.4 upgrade IIQ Discussion and Questions aggregation , identityiq	9	645	May 6, 2024
AD Group aggregation Failure after SailPoint upgrade to 8.3 IIQ Discussion and Questions aggregation , identityiq	4	91	November 2, 2024
org.hibernate.exception.DataException: could not execute statement IIQ Discussion and Questions aggregation , identityiq	2	104	November 10, 2024
AD Aggregation Failed IIQ Discussion and Questions aggregation , identityiq	9	203	July 27, 2024
ActiveDirectory Aggregation Error IIQ Discussion and Questions aggregation , identityiq , entitlements	11	149	September 10, 2024

AD Application aggregation error

Which IIQ version are you inquiring about?

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

Related topics