Project

General

Profile

Actions

Bug #3329

closed

Impossible de notifier des utilisateurs depuis une publication

Added by Ludovic Bertin over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
High
Category:
Notifications
Start date:
05/23/2012
Due date:
% Done:

100%

Estimated time:
Spent time:
Navigateur:
Tous
Votre version de Silverpeas:
5.9
Système d'exploitation:
Votre base de données:
Oracle
Livraison en TEST:
Livraison en PROD:

Description

Sous Oracle et lorsque le nombre d'utilisateurs ayant accès à la publication dépasse 1000,
une popup d'erreur apparait à l'ouverture du panneau utilisateur lors de la sélection des destinataires de la notification.

L'erreur dans les traces est la suivante :

23/05/12-11:34:10,847 - ERROR : admin.EX_ERR_GET_USER_DETAILS | MODULE : admin.OrganizationController.getUsersMatchingCriteria | Erreur lors de l'obtention des details de plusieurs utilisateurs (criteria: 'com.stratelia.webactiv.beans.admin.SearchCriteria@48563f14, EXCEPTION : Erreur lors de l'obtention des différents groupes d'un utilisateur
nested (Deepest) : 
java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
    at com.stratelia.webactiv.beans.admin.dao.UserDAO.getUsersByCriteria(UserDAO.java:109)
    at com.stratelia.webactiv.beans.admin.UserManager.getUsersMatchingCriteria(UserManager.java:114)
    at com.stratelia.webactiv.beans.admin.Admin.searchUsers(Admin.java:6473)
    at com.stratelia.webactiv.beans.admin.OrganizationController.searchUsers(OrganizationController.java:484)
    at com.silverpeas.profile.web.UserProfileResource.getApplicationUsers(UserProfileResource.java:192)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
    at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)
    at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)
    at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)
    at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
    at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:699)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at com.silverpeas.whitePages.filters.ComponentRequestRouterFilter.doFilter(ComponentRequestRouterFilter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285)
    at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88)
    at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:159)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951)
    at java.lang.Thread.run(Thread.java:662)

Actions #1

Updated by Nicolas Eysseric over 9 years ago

  • Status changed from New to Assigned
  • Assignee set to Miguel Moquillon
  • Target version set to Version 5.10
Actions #2

Updated by Miguel Moquillon over 9 years ago

  • Status changed from Assigned to In progress...
Actions #3

Updated by Nicolas Eysseric over 9 years ago

  • Target version changed from Version 5.10 to Version 5.9.3
Actions #4

Updated by Miguel Moquillon over 9 years ago

  • Status changed from In progress... to Resolved
  • % Done changed from 0 to 100

Le problème vient d'une limitation d'Oracle sur la taille des listes dans les clauses in des requêtes SQL: elles ne peuvent contenir plus de 1000 éléments !

La correction adoptée a été de découper ses listes en plusieurs de moins de 1000 éléments. Elle a été validée aussi avec MS SQLServer et PostgreSQL qui n'ont pas la limitation surprenante d'Oracle.

Actions #5

Updated by Nicolas Eysseric over 9 years ago

  • Project changed from GED to Silverpeas Core
  • Category set to Notifications
Actions #6

Updated by Nicolas Eysseric over 9 years ago

  • Status changed from Resolved to Closed

OK. Validé et intégré.

Actions

Also available in: Atom PDF