09 Nov 2011 11:01:46,618 ERROR [CmsExplorerTypeAccess.java: 227] Error reading groups of user Admin org.opencms.db.CmsDbSqlException: Error reading all roles for user "Admin" over resource "/de/bewerben-bei-smc/". 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.getRolesForResource(CmsSecurityManager.java:2533) at org.opencms.security.CmsRoleManager.getRolesForResource(CmsRoleManager.java:305) at org.opencms.workplace.explorer.CmsExplorerTypeAccess.getPermissions(CmsExplorerTypeAccess.java:224) at org.opencms.workplace.explorer.CmsExplorerTypeSettings.isEditable(CmsExplorerTypeSettings.java:507) at org.opencms.workplace.explorer.CmsExplorerContextMenuBuilder.contextMenu(CmsExplorerContextMenuBuilder.java:129) at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.views.explorer.contextmenu_jsp._jspService(contextmenu_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:188) at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:163) at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:612) at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:417) at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:167) at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:886) at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:517) at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1062) at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1598) at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153) at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:166) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.vi.esapi.filters.ValidationFilter.doFilter(ValidationFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.vi.opencms.OpenCmsCharsetFilter.doFilter(OpenCmsCharsetFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:306) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:322) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1732) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement@7f85e155. at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1190) at org.opencms.db.CmsDriverManager.getResourceOrgUnits(CmsDriverManager.java:4431) at org.opencms.db.CmsDriverManager.getRolesForResource(CmsDriverManager.java:4601) at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2531) ... 51 more Caused by: java.sql.SQLException: 'CONCAT' is not a recognized built-in function name. 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.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1185) ... 54 more