Bug #6677
Mis à jour par Anonyme il y a presque 9 ans
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:
<pre>
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
)
</pre>