[opencms-dev] Error OpenCms 9.5 MS SQL 2012 and query to get user list

[Alberto Gallardo]

Seems suspiciously similar to the already reported
https://github.com/alkacon/opencms-core/issues/295

Alberto

2015-02-10 8:34 GMT+01:00 Javi Marin <xavi.marin at gmail.com>:

> Dear,
>
> There are an error consulting the option Management > Users and Groups in
> OpenCms 9.5 and Microsoft SQL Server 2012. There are a fix to solve this
> error?
>
> This is the error trace:
> org.opencms.main.CmsRuntimeException: Error while filling the list "User
> Accounts".
> at
> org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:909)
> at
> org.opencms.workplace.list.A_CmsListDialog.refreshList(A_CmsListDialog.java:647)
> at
> org.opencms.workplace.list.A_CmsListDialog.actionDialog(A_CmsListDialog.java:383)
> at
> org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:430)
> at
> org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:415)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.admin.accounts.users_005flist_jsp._jspService(users_005flist_jsp.java:67)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.forward(CmsFlexRequestDispatcher.java:111)
> at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:522)
> at
> org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1193)
> at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1715)
> at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
> at
> org.opencms.flex.CmsFlexRequestDispatcher.forward(CmsFlexRequestDispatcher.java:111)
> at org.opencms.util.CmsRequestUtil.forwardRequest(CmsRequestUtil.java:469)
> at
> org.opencms.workplace.tools.CmsToolManager.jspForwardPage(CmsToolManager.java:475)
> at
> org.opencms.workplace.administration.CmsAdminDialog.displayDialog(CmsAdminDialog.java:92)
> at
> org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.views.admin.admin_002dmain_jsp._jspService(admin_002dmain_jsp.java:66)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
> at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:522)
> at
> org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1193)
> at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1715)
> at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.opencms.db.CmsDbSqlException: Error searching for users
> at
> org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:109)
> at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:334)
> at org.opencms.db.CmsDbContext.report(CmsDbContext.java:286)
> at
> org.opencms.db.CmsSecurityManager.searchUsers(CmsSecurityManager.java:5746)
> at
> org.opencms.security.CmsOrgUnitManager.searchUsers(CmsOrgUnitManager.java:318)
> at
> org.opencms.workplace.tools.accounts.CmsUsersList.getListItems(CmsUsersList.java:125)
> at
> org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:902)
> ... 82 more
> Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
> executing the following query:
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 78f0efb5.
> at
> org.opencms.db.generic.CmsUserDriver.searchUsers(CmsUserDriver.java:1766)
> at org.opencms.db.CmsDriverManager.searchUsers(CmsDriverManager.java:8627)
> at
> org.opencms.db.CmsSecurityManager.searchUsers(CmsSecurityManager.java:5744)
> ... 85 more
> Caused by: java.sql.SQLException: La cláusula ORDER BY no es válida en
> vistas, funciones insertadas, tablas derivadas, subconsultas ni expresiones
> de tabla común, salvo que se especifique también TOP, OFFSET o FOR XML.
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
> at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.opencms.db.generic.CmsUserDriver.searchUsers(CmsUserDriver.java:1760)
> ... 87 more
>
> --
> javi marín
> flickr: http://www.flickr.com/photos/javimarin/
> twitter: http://twitter.com/javimarinpulido
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20150210/eeadcd6f/attachment.htm>