<div dir="ltr">Dear,<div><br></div><div>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?<br clear="all"><div><br></div><div>This is the error trace:</div><div><div>org.opencms.main.CmsRuntimeException: Error while filling the list "User Accounts".</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:909)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.list.A_CmsListDialog.refreshList(A_CmsListDialog.java:647)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.list.A_CmsListDialog.actionDialog(A_CmsListDialog.java:383)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:430)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:415)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.admin.accounts.users_005flist_jsp._jspService(users_005flist_jsp.java:67)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.flex.CmsFlexRequestDispatcher.forward(CmsFlexRequestDispatcher.java:111)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:522)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1193)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1715)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.flex.CmsFlexRequestDispatcher.forward(CmsFlexRequestDispatcher.java:111)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.util.CmsRequestUtil.forwardRequest(CmsRequestUtil.java:469)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.tools.CmsToolManager.jspForwardPage(CmsToolManager.java:475)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.administration.CmsAdminDialog.displayDialog(CmsAdminDialog.java:92)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.views.admin.admin_002dmain_jsp._jspService(admin_002dmain_jsp.java:66)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)</div><div><span class="" style="white-space:pre"> </span>at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:522)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1193)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1715)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)</div><div><span class="" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</div><div><span class="" style="white-space:pre"> </span>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)</div><div><span class="" style="white-space:pre"> </span>at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)</div><div><span class="" style="white-space:pre"> </span>at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)</div><div><span class="" style="white-space:pre"> </span>at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)</div><div><span class="" style="white-space:pre"> </span>at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</div><div><span class="" style="white-space:pre"> </span>at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</div><div><span class="" style="white-space:pre"> </span>at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</div><div><span class="" style="white-space:pre"> </span>at java.lang.Thread.run(Thread.java:745)</div><div>Caused by: org.opencms.db.CmsDbSqlException: Error searching for users </div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:109)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:334)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.CmsDbContext.report(CmsDbContext.java:286)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.CmsSecurityManager.searchUsers(CmsSecurityManager.java:5746)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.security.CmsOrgUnitManager.searchUsers(CmsOrgUnitManager.java:318)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.tools.accounts.CmsUsersList.getListItems(CmsUsersList.java:125)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:902)</div><div><span class="" style="white-space:pre"> </span>... 82 more</div><div>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement@78f0efb5. </div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.generic.CmsUserDriver.searchUsers(CmsUserDriver.java:1766)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.CmsDriverManager.searchUsers(CmsDriverManager.java:8627)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.CmsSecurityManager.searchUsers(CmsSecurityManager.java:5744)</div><div><span class="" style="white-space:pre"> </span>... 85 more</div><div>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.</div><div><span class="" style="white-space:pre"> </span>at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)</div><div><span class="" style="white-space:pre"> </span>at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)</div><div><span class="" style="white-space:pre"> </span>at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)</div><div><span class="" style="white-space:pre"> </span>at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)</div><div><span class="" style="white-space:pre"> </span>at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)</div><div><span class="" style="white-space:pre"> </span>at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)</div><div><span class="" style="white-space:pre"> </span>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)</div><div><span class="" style="white-space:pre"> </span>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)</div><div><span class="" style="white-space:pre"> </span>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)</div><div><span class="" style="white-space:pre"> </span>at org.opencms.db.generic.CmsUserDriver.searchUsers(CmsUserDriver.java:1760)</div><div><span class="" style="white-space:pre"> </span>... 87 more</div></div><div><br></div>-- <br><div class="gmail_signature">javi marín<br>flickr: <a href="http://www.flickr.com/photos/javimarin/" target="_blank">http://www.flickr.com/photos/javimarin/</a><br>twitter: <a href="http://twitter.com/javimarinpulido" target="_blank">http://twitter.com/javimarinpulido</a><br></div>
</div></div>