topic ¿Problemas con las etiquetas de Alfresco (3.4)? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179418#M132548 <HTML><HEAD></HEAD><BODY><SPAN>Buenos días.</SPAN><BR /><BR /><SPAN>Tengo un problema con Alfresco que no se como solucionar. Os dejo aquí la traza del error:</SPAN><BR /><BR /><SPAN>org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:268)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.locks.ibatis.LockDAOImpl.getLockResource(LockDAOImpl.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:79)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:451)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:503)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:457)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:220)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.lockTagScope(UpdateTagScopesActionExecuter.java:545)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.executeImpl(UpdateTagScopesActionExecuter.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:538)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor572.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy30.executeAction(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesQuartzJob.execute(UpdateTagScopesQuartzJob.java:145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesQuartzJob.execute(UpdateTagScopesQuartzJob.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Error: executeQueryForObject returned too many results.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:270)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 34 more</SPAN><BR /><SPAN>09:52:46,464&nbsp; ERROR [quartz.core.JobRunShell] Job DEFAULT.taggingStartupJobDetail threw an unhandled Exception: </SPAN><BR /><SPAN>java.lang.RuntimeException: Unable to update the tag scopes.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.executeImpl(UpdateTagScopesActionExecuter.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:538)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor572.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy30.executeAction(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesQuartzJob.execute(UpdateTagScopesQuartzJob.java:145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesQuartzJob.execute(UpdateTagScopesQuartzJob.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</SPAN><BR /><SPAN>Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:268)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.locks.ibatis.LockDAOImpl.getLockResource(LockDAOImpl.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:79)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:451)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:503)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:457)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:220)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.lockTagScope(UpdateTagScopesActionExecuter.java:545)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.executeImpl(UpdateTagScopesActionExecuter.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 24 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Error: executeQueryForObject returned too many results.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:270)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 34 more</SPAN><BR /><SPAN>09:52:46,465&nbsp; ERROR [quartz.core.ErrorLogger] Job (DEFAULT.taggingStartupJobDetail threw an exception.</SPAN><BR /><SPAN>org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: java.lang.RuntimeException: Unable to update the tag scopes.]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:227)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</SPAN><BR /><SPAN>Caused by: java.lang.RuntimeException: Unable to update the tag scopes.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.executeImpl(UpdateTagScopesActionExecuter.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:538)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor572.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:146)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy30.executeAction(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesQuartzJob.execute(UpdateTagScopesQuartzJob.java:145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesQuartzJob.execute(UpdateTagScopesQuartzJob.java:92)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 1 more</SPAN><BR /><SPAN>Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many results.; nested exception is java.sql.SQLException: Error: executeQueryForObject returned too many results.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:268)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.locks.ibatis.LockDAOImpl.getLockResource(LockDAOImpl.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.locks.AbstractLockDAOImpl.getLock(AbstractLockDAOImpl.java:79)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl$4.execute(JobLockServiceImpl.java:451)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.doWithRetry(JobLockServiceImpl.java:503)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.getLockImpl(JobLockServiceImpl.java:457)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.lock.JobLockServiceImpl.getLock(JobLockServiceImpl.java:220)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.lockTagScope(UpdateTagScopesActionExecuter.java:545)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.UpdateTagScopesActionExecuter.executeImpl(UpdateTagScopesActionExecuter.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 24 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Error: executeQueryForObject returned too many results.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:124)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:270)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 34 more</SPAN><BR /><BR /><SPAN>Se trata de un sitio donde los usuarios no pueden visualizar correctamente a través de los portlets de share el sitio. Buscando he visto que había un documento y una carpeta que tenían en los metadatos asociados cada uno una etiqueta (distinta) que no aparecían en el listado de etiquetas del repositorio desde la consola de administración de share. Las he quitado editando los metadatos, pero el problema persiste.</SPAN><BR /><BR /><SPAN>¿Alguna idea de como solucionar esto? He realizado varias pruebas, pero por un lado no consigo reproducir el error y por otro no se como solucionarlo. </SPAN><BR /><SPAN>La versión de Alfresco es la 3.4</SPAN><BR /><BR /><SPAN>Gracias</SPAN></BODY></HTML> Mon, 26 Nov 2012 10:23:43 GMT sdominguez 2012-11-26T10:23:43Z ¿Problemas con las etiquetas de Alfresco (3.4)? https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179418#M132548 Buenos días.Tengo un problema con Alfresco que no se como solucionar. Os dejo aquí la traza del error<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error: executeQueryForObject returned too many re Mon, 26 Nov 2012 10:23:43 GMT https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179418#M132548 sdominguez 2012-11-26T10:23:43Z Re: ¿Problemas con las etiquetas de Alfresco (3.4)? https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179419#M132549 <HTML><HEAD></HEAD><BODY><SPAN>Buenas.</SPAN><BR /><BR /><SPAN>El problemas es a nivel de base de datos. Ojea este </SPAN><A href="https://forums.alfresco.com/en/viewtopic.php?f=4&amp;t=35952" rel="nofollow noopener noreferrer">link</A><SPAN>, ahí dan una solución.</SPAN><BR /><BR /><A href="http://www.google.es/#q=java.lang.RuntimeException:++site:forums.alfresco.com+Unable+to+update+the+tag+scope+%22alfresco%22&amp;hl=fr&amp;tbo=d&amp;filter=0&amp;bav=on.2,or.r_gc.r_pw.r_qf.&amp;fp=71239e288f790073&amp;bpcl=38897761&amp;biw=1920&amp;bih=949" rel="nofollow noopener noreferrer">Ojea los resultados que encontré</A><SPAN> en google en el caso de que no funcione esa solucioón&nbsp; :wink: </SPAN><BR /><BR /><SPAN>Comentanos por favor.</SPAN><BR /><BR /><SPAN>Un saludo.</SPAN></BODY></HTML> Thu, 29 Nov 2012 09:03:59 GMT https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179419#M132549 cristinamr 2012-11-29T09:03:59Z Re: ¿Problemas con las etiquetas de Alfresco (3.4)? https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179420#M132550 <HTML><HEAD></HEAD><BODY><SPAN>Al final se ha realizado una copia del sitio, exportando la estructura de carpetas y el problema se ha solucionado.</SPAN><BR /><BR /><SPAN>Gracias</SPAN></BODY></HTML> Tue, 04 Dec 2012 14:28:45 GMT https://connect.hyland.com/t5/alfresco-archive/problemas-con-las-etiquetas-de-alfresco-3-4/m-p/179420#M132550 sdominguez 2012-12-04T14:28:45Z