Project

General

Profile

Actions

Bug #6677

closed

Affichage des commentaires sur une publication

Added by Anonymous over 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Start date:
07/03/2015
Due date:
% Done:

100%

Estimated time:
Navigateur:
Tous
Votre version de Silverpeas:
5.15-SNAPSHOT
Système d'exploitation:
Votre base de données:
Toutes
Livraison en TEST:
Livraison en PROD:

Description

Sur la version 5.15-SNAPSHOT on a un problème d'affichage des commentaires d'une publication.
Petite précision l'erreur apparaît sur une GED dont la paramétrage des commentaires n'est pas activé.
On obtient l'erreur suivante avec la base de données Oracle:

03/07/15-11:58:22,789 - FATAL : comment.GET_COMMENT_FAILED | MODULE : comment.JDBCCommentDAO.getSocialInformationCommentsListOfMyContacts() | !!! Message comment.GET_COMMENT_FAILED NOT INITIALIZED !!! (EXCEPTION : com.silverpeas.comment.CommentRuntimeException: comment.GET_COMMENT_FAILED
    at com.silverpeas.comment.dao.jdbc.JDBCCommentDAO.getSocialInformationCommentsListOfMyContacts(JDBCCommentDAO.java:319)
    at com.silverpeas.comment.service.DefaultCommentService.getSocialInformationCommentsListOfMyContacts(DefaultCommentService.java:462)
    at org.silverpeas.components.quickinfo.socialNetwork.SocialCommentQuickInfos.getSocialInformationsListOfMyContacts(SocialCommentQuickInfos.java:106)
    at com.silverpeas.socialnetwork.provider.ProviderSwitch.getSocialInformationsListOfMyContacts(ProviderSwitch.java:404)
    at com.silverpeas.socialnetwork.provider.ProviderSwitch.getSocialInformationsListOfMyContacts(ProviderSwitch.java:393)
    at com.silverpeas.socialnetwork.provider.ProviderSwitch.getSocialInformationsListOfMyContacts(ProviderSwitch.java:379)
    at com.silverpeas.socialnetwork.provider.ProviderSwitch.getSocialInformationsListOfMyContacts(ProviderSwitch.java:451)
    at com.silverpeas.socialnetwork.myProfil.control.ProviderService.getSocialInformationsListOfMyContact(ProviderService.java:88)
    at com.silverpeas.socialnetwork.myProfil.control.SocialNetworkService.getSocialInformationOfMyContacts(SocialNetworkService.java:129)
    at com.silverpeas.socialnetwork.newsFeed.servlets.NewsFeedJSONServlet.getInformations(NewsFeedJSONServlet.java:166)
    at com.silverpeas.socialnetwork.newsFeed.servlets.NewsFeedJSONServlet.doGet(NewsFeedJSONServlet.java:122)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
    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:74)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.silverpeas.web.filter.MassiveWebSecurityFilter.doFilter(MassiveWebSecurityFilter.java:175)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.silverpeas.web.filter.InternetExplorerAntiCompatibilityFilter.doFilter(InternetExplorerAntiCompatibilityFilter.java:48)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.silverpeas.web.token.SessionSynchronizerTokenValidator.doFilter(SessionSynchronizerTokenValidator.java:103)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.silverpeas.web.filter.MessageFilter.doFilter(MessageFilter.java:74)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
    at org.silverpeas.web.filter.HttpServletRequestDecoration.doFilter(HttpServletRequestDecoration.java:47)
    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:107)
    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)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: expression absente

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
    at com.silverpeas.comment.dao.jdbc.JDBCCommentRequester.getSocialInformationComments(JDBCCommentRequester.java:541)
    at com.silverpeas.comment.dao.jdbc.JDBCCommentDAO.getSocialInformationCommentsListOfMyContacts(JDBCCommentDAO.java:316)
    ... 54 more
)

Actions #1

Updated by Anonymous over 6 years ago

  • Votre base de données changed from Toutes to Oracle
Actions #2

Updated by Anonymous over 6 years ago

  • Description updated (diff)
  • Priority changed from High to Normal
Actions #3

Updated by Nicolas Eysseric over 6 years ago

  • Target version set to Version 5.15
Actions #4

Updated by Nicolas Eysseric about 6 years ago

  • Status changed from New to Assigned
  • Assignee set to Yohann Chastagnier
Actions #5

Updated by Yohann Chastagnier about 6 years ago

  • Project changed from GED to Silverpeas Core
  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100
  • Votre base de données changed from Oracle to Toutes

https://github.com/Silverpeas/Silverpeas-Core/pull/631

En réalité le problème n'était lié ni uniquement à la base de données Oracle, ni spécifiquement aux publications.

Pour obtenir simplement ces erreurs techniques, le plus simple est de suivre cette démarche :
  • paramétrer un Silverpeas dans lequel aucune instance de composant n'est publique
  • se connecter avec un utilisateur qui n'a aucun droit sur aucune application
  • se diriger vers le profil de l'utilisateur, onglet Fils d'informations ou Mur
Actions #6

Updated by Miguel Moquillon about 6 years ago

  • Status changed from Resolved to Closed

Intégré dans la 5.15 et dans la 6.0

Actions

Also available in: Atom PDF