[midPoint] 3.0 - Some initial issues
Deepak Natarajan
dnataraj at trilobytesystems.com
Wed Jun 4 09:38:53 CEST 2014
Hi Everyone -
We have deployed the official Midpoint 3.0 distribution on our test
servers, and everything seems to be fine (it's definitely more
performant!).
We have one critical issue so far :
Some of our users cannot be provisioned outward to AD because they have
"long" DN's. e.g
distinguishedName: CN=Axxx Elxxxxxx Nxxxxxx,OU=Område Nord -
Vikarkorps,OU=Område Nord - Administration-stab,OU=Område Nord,OU=Senior
- Drift,OU=Velfærdsforvaltningen,OU=Vejle Kommune,OU=APOS,DC=Vejle,DC=dk
...and even longer ones.
Pre 3.0 I avoided some of these errors with the following SQL (Thanks to
Viliam Repan) :
alter table m_shadow change column name_norm name_norm varchar(2000)
character set 'utf8' collate 'utf8_bin' null default null;
alter table m_shadow change column name_orig name_orig varchar(2000)
character set 'utf8' collate 'utf8_bin' null default null;
But it looksl like name_orig is present in other places. This is the
error we are looking at :
2014-06-04 02:02:37,321 [PROVISIONING] [midPointScheduler_Worker-10]
ERROR (com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl):
Couldn't add object. Runtime error: Data truncation: Data too long for
column 'name_orig' at row 1
com.evolveum.midpoint.util.exception.SystemException: Data truncation:
Data too long for column 'name_orig' at row 1
at
com.evolveum.midpoint.repo.sql.SqlBaseService.handleGeneralRuntimeException(SqlBaseService.java:306)
~[repo-sql-impl-3.0.jar:na]
at
com.evolveum.midpoint.repo.sql.SqlBaseService.handleGeneralException(SqlBaseService.java:287)
~[repo-sql-impl-3.0.jar:na]
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addObjectAttempt(SqlRepositoryServiceImpl.java:503)
~[repo-sql-impl-3.0.jar:na]
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addObject_aroundBody6(SqlRepositoryServiceImpl.java:442)
~[repo-sql-impl-3.0.jar:na]
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl$AjcClosure7.run(SqlRepositoryServiceImpl.java:1)
~[repo-sql-impl-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processRepositoryNdc(MidpointAspect.java:72)
[util-3.0.jar:na]
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addObject(SqlRepositoryServiceImpl.java:403)
~[repo-sql-impl-3.0.jar:na]
at
com.evolveum.midpoint.repo.cache.RepositoryCache.addObject_aroundBody2(RepositoryCache.java:186)
~[repo-cache-3.0.jar:na]
at
com.evolveum.midpoint.repo.cache.RepositoryCache$AjcClosure3.run(RepositoryCache.java:1)
~[repo-cache-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processRepositoryNdc(MidpointAspect.java:72)
[util-3.0.jar:na]
at
com.evolveum.midpoint.repo.cache.RepositoryCache.addObject(RepositoryCache.java:184)
~[repo-cache-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ShadowCacheProvisioner.afterAddOnResource(ShadowCacheProvisioner.java:68)
~[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ShadowCache.addShadow(ShadowCache.java:366)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.addObject_aroundBody2(ProvisioningServiceImpl.java:332)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl$AjcClosure3.run(ProvisioningServiceImpl.java:1)
[provisioning-impl-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processProvisioningNdc(MidpointAspect.java:82)
[util-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.addObject(ProvisioningServiceImpl.java:312)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.addProvisioningObject(ChangeExecutor.java:909)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeAddition(ChangeExecutor.java:699)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeDelta(ChangeExecutor.java:558)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.ChangeExecutor.executeChanges(ChangeExecutor.java:254)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.Clockwork.processSecondary(Clockwork.java:400)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.Clockwork.click(Clockwork.java:230) [model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.lens.Clockwork.run(Clockwork.java:156)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.sync.SynchronizationService.reactToChange(SynchronizationService.java:619)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.sync.SynchronizationService.notifyChange_aroundBody0(SynchronizationService.java:260)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.sync.SynchronizationService$AjcClosure1.run(SynchronizationService.java:1)
[model-impl-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processResourceObjectChangeListenerNdc(MidpointAspect.java:97)
[util-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.sync.SynchronizationService.notifyChange(SynchronizationService.java:162)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ChangeNotificationDispatcherImpl.notifyChange_aroundBody0(ChangeNotificationDispatcherImpl.java:153)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ChangeNotificationDispatcherImpl$AjcClosure1.run(ChangeNotificationDispatcherImpl.java:1)
[provisioning-impl-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processResourceObjectChangeListenerNdc(MidpointAspect.java:97)
[util-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ChangeNotificationDispatcherImpl.notifyChange(ChangeNotificationDispatcherImpl.java:135)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.sync.SynchronizeAccountResultHandler.handleObject(SynchronizeAccountResultHandler.java:172)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.util.AbstractSearchIterativeResultHandler.handle(AbstractSearchIterativeResultHandler.java:125)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl$5.handle(ProvisioningServiceImpl.java:1215)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ShadowCache$2.handle(ShadowCache.java:895)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ResourceObjectConverter$2.handle(ResourceObjectConverter.java:622)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl$2.handle(ConnectorInstanceIcfImpl.java:1821)
[provisioning-impl-3.0.jar:na]
at
org.identityconnectors.framework.impl.api.StreamHandlerUtil$ObjectStreamHandlerAdapter.handle(StreamHandlerUtil.java:89)
[connector-framework-internal-1.4.0.erc2.jar:na]
at
org.identityconnectors.framework.impl.api.BufferedResultsProxy.invoke(BufferedResultsProxy.java:255)
[connector-framework-internal-1.4.0.erc2.jar:na]
at
org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:94)
[connector-framework-internal-1.4.0.erc2.jar:na]
at com.sun.proxy.$Proxy151.search(Unknown Source) [na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.7.0_21]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.7.0_21]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.7.0_21]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.7.0_21]
at
org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:77)
[connector-framework-internal-1.4.0.erc2.jar:na]
at com.sun.proxy.$Proxy151.search(Unknown Source) [na:na]
at
org.identityconnectors.framework.impl.api.AbstractConnectorFacade.search(AbstractConnectorFacade.java:173)
[connector-framework-internal-1.4.0.erc2.jar:na]
at
com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl.search_aroundBody26(ConnectorInstanceIcfImpl.java:1857)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl$AjcClosure27.run(ConnectorInstanceIcfImpl.java:1)
[provisioning-impl-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processUcfNdc(MidpointAspect.java:92)
[util-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl.search(ConnectorInstanceIcfImpl.java:1768)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ResourceObjectConverter.searchResourceObjects(ResourceObjectConverter.java:627)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ShadowCache.searchObjectsIterativeInternal(ShadowCache.java:900)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ShadowCache.searchObjectsIterative(ShadowCache.java:763)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.searchObjectsIterative_aroundBody22(ProvisioningServiceImpl.java:1261)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl$AjcClosure23.run(ProvisioningServiceImpl.java:1)
[provisioning-impl-3.0.jar:na]
at
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSubsystem(MidpointAspect.java:1)
[util-3.0.jar:na]
at
com.evolveum.midpoint.util.aspect.MidpointAspect.processProvisioningNdc(MidpointAspect.java:82)
[util-3.0.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.searchObjectsIterative(ProvisioningServiceImpl.java:1073)
[provisioning-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.ModelObjectResolver.searchIterative(ModelObjectResolver.java:222)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.model.impl.util.AbstractSearchIterativeTaskHandler.run(AbstractSearchIterativeTaskHandler.java:155)
[model-impl-3.0.jar:na]
at
com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executeHandler(JobExecutor.java:473)
[task-quartz-impl-3.0.jar:na]
at
com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executeSingleTask(JobExecutor.java:286)
[task-quartz-impl-3.0.jar:na]
at
com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.execute(JobExecutor.java:165)
[task-quartz-impl-3.0.jar:na]
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
[quartz-2.1.3.jar:na]
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
[quartz-2.1.3.jar:na]
Caused by: org.hibernate.exception.DataException: Data truncation: Data
too long for column 'name_orig' at row 1
at
org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:71)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at com.sun.proxy.$Proxy83.executeUpdate(Unknown Source) ~[na:na]
at
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3028)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3469)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) ~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275) ~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1213)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:402)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.addObjectAttempt(SqlRepositoryServiceImpl.java:473)
~[repo-sql-impl-3.0.jar:na]
... 86 common frames omitted
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too
long for column 'name_orig' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235)
~[mysql-connector-java-5.1.28-bin.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
~[mysql-connector-java-5.1.28-bin.jar:na]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
~[mysql-connector-java-5.1.28-bin.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
~[mysql-connector-java-5.1.28-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
~[mysql-connector-java-5.1.28-bin.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
~[mysql-connector-java-5.1.28-bin.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441)
~[mysql-connector-java-5.1.28-bin.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2366)
~[mysql-connector-java-5.1.28-bin.jar:na]
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2350)
~[mysql-connector-java-5.1.28-bin.jar:na]
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
~[c3p0-0.9.1.jar:0.9.1]
at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.7.0_21]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.7.0_21]
at
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
... 102 common frames omitted
And one other minor point :
It looks like the Administrator user can be deleted now (if I recall
correctly, previous versions did not allow this). Usually during test
runs, I delete all users using the Admin GUI to start from a zero state.
Yesterday I deleted the Administrator user by mistake (no warning was
presented) and had to reset my repository.
Thanks in advance.
BR/
--
Deepak Natarajan
Trilobyte Systems ApS
More information about the midPoint
mailing list