-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
4.4 RC1
During entity config , if setting id as user order column :
Following error is encountered :
Date : 20/01 12:10:05.667 Thread : Thread[AmetysRuntimeScheduler_Worker-5,5,main] Niveau : ERROR Catégorie : org.ametys.core.schedule.AmetysJob$org.ametys.plugins.contentio.synchronize.SynchronizeCollectionSchedulable Message : An exception occured during the execution of the Schedulable 'org.ametys.plugins.contentio.synchronize.SynchronizeCollectionSchedulable' Emplacement : org.ametys.core.schedule.AmetysJob.execute(AmetysJob.java:156) Pile d'appels : org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'id' in order clause is ambiguous ### The error may exist in /org/ametys/plugins/userdirectory/synchronize/sql-user-search.xml ### The error may involve UserDirectory.search-Inline ### The error occurred while setting parameters ### SQL: SELECT o.id, u.id , u.role FROM synchro_sql_users u, synchro_sql_orgunits o WHERE u.orgunitId = o.id ORDER BY id ### Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'id' in order clause is ambiguous at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.ametys.plugins.userdirectory.synchronize.SQLUserSearchDAO.searchUser(SQLUserSearchDAO.java:54) at org.ametys.plugins.userdirectory.synchronize.SQLSynchronizableUDOrgunitCollection._getOrgUnitUser(SQLSynchronizableUDOrgunitCollection.java:372) at org.ametys.plugins.userdirectory.synchronize.SQLSynchronizableUDOrgunitCollection._internalPopulate(SQLSynchronizableUDOrgunitCollection.java:271) at org.ametys.plugins.contentio.synchronize.AbstractSynchronizableContentsCollection.populate(AbstractSynchronizableContentsCollection.java:122) at org.ametys.plugins.contentio.synchronize.AbstractSimpleSynchronizableContentsCollection.populate(AbstractSimpleSynchronizableContentsCollection.java:79) at org.ametys.plugins.userdirectory.synchronize.SQLSynchronizableUDOrgunitCollection.populate(SQLSynchronizableUDOrgunitCollection.java:260) at org.ametys.plugins.contentio.synchronize.SynchronizeCollectionSchedulable.execute(SynchronizeCollectionSchedulable.java:51) at org.ametys.core.schedule.AmetysJob.execute(AmetysJob.java:151) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
