Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-40858

Site Info: entering Latin text for a tool name causes stack trace

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 12.3
    • Fix Version/s: None
    • Component/s: Worksite Setup
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      After selecting one of the sites, I click on edit link then selecting managetools then enter some latin text on the text box, after that click on finish button it throws the following bug error:

      org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: java.lang.reflect.InvocationTargetException at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:857) caused by: org.sakaiproject.tool.api.ToolException: java.lang.reflect.InvocationTargetException at org.sakaiproject.site.tool.SiteAction.toolModeDispatch(SiteAction.java:14689) caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke(null:-1) caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT lti_tools.id AS id, lti_tools.version AS version, lti_tools.SITE_ID AS SITE_ID, lti_tools.title AS title, lti_tools.allowtitle AS allowtitle, lti_tools.fa_icon AS fa_icon, lti_tools.pagetitle AS pagetitle, lti_tools.allowpagetitle AS allowpagetitle, lti_tools.description AS description, lti_tools.status AS status, lti_tools.visible AS visible, lti_tools.resource_handler AS resource_handler, lti_tools.deployment_id AS deployment_id, lti_tools.launch AS launch, lti_tools.allowlaunch AS allowlaunch, lti_tools.consumerkey AS consumerkey, lti_tools.allowconsumerkey AS allowconsumerkey, lti_tools.secret AS secret, lti_tools.allowsecret AS allowsecret, lti_tools.frameheight AS frameheight, lti_tools.toolorder AS toolorder, lti_tools.allowframeheight AS allowframeheight, lti_tools.siteinfoconfig AS siteinfoconfig, lti_tools.sendname AS sendname, lti_tools.sendemailaddr AS sendemailaddr, lti_tools.allowoutcomes AS allowoutcomes, lti_tools.allowroster AS allowroster, lti_tools.allowsettings AS allowsettings, lti_tools.pl_launch AS pl_launch, lti_tools.pl_linkselection AS pl_linkselection, lti_tools.pl_contenteditor AS pl_contenteditor, lti_tools.pl_importitem AS pl_importitem, lti_tools.pl_fileitem AS pl_fileitem, lti_tools.pl_assessmentselection AS pl_assessmentselection, lti_tools.newpage AS newpage, lti_tools.debug AS debug, lti_tools.custom AS custom, lti_tools.settings AS settings, lti_tools.parameter AS parameter, lti_tools.tool_proxy_binding AS tool_proxy_binding, lti_tools.allowcustom AS allowcustom, lti_tools.sha256 AS sha256, lti_tools.lti13 AS lti13, lti_tools.lti13_settings AS lti13_settings, lti_tools.xmlimport AS xmlimport, lti_tools.splash AS splash, lti_tools.created_at AS created_at, lti_tools.updated_at AS updated_at FROM lti_tools WHERE (lti_tools.SITE_ID = ? OR (lti_tools.SITE_ID IS NULL AND lti_tools.visible != 1 ) ) AND (lti_tools.pl_launch = 1 OR ( ( lti_tools.pl_linkselection IS NULL OR lti_tools.pl_linkselection = 0 ) and ( lti_tools.pl_fileitem IS NULL OR lti_tools.pl_fileitem = 0 ) and ( lti_tools.pl_importitem IS NULL OR lti_tools.pl_importitem = 0 ) and ( lti_tools.pl_contenteditor IS NULL OR lti_tools.pl_contenteditor = 0 ) and ( lti_tools.pl_assessmentselection IS NULL OR lti_tools.pl_assessmentselection = 0 ) ) ) ORDER BY lti_tools.id]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LTI_TOOLS in statement [SELECT lti_tools.id AS id, lti_tools.version AS version, lti_tools.SITE_ID AS SITE_ID, lti_tools.title AS title, lti_tools.allowtitle AS allowtitle, lti_tools.fa_icon AS fa_icon, lti_tools.pagetitle AS pagetitle, lti_tools.allowpagetitle AS allowpagetitle, lti_tools.description AS description, lti_tools.status AS status, lti_tools.visible AS visible, lti_tools.resource_handler AS resource_handler, lti_tools.deployment_id AS deployment_id, lti_tools.launch AS launch, lti_tools.allowlaunch AS allowlaunch, lti_tools.consumerkey AS consumerkey, lti_tools.allowconsumerkey AS allowconsumerkey, lti_tools.secret AS secret, lti_tools.allowsecret AS allowsecret, lti_tools.frameheight AS frameheight, lti_tools.toolorder AS toolorder, lti_tools.allowframeheight AS allowframeheight, lti_tools.siteinfoconfig AS siteinfoconfig, lti_tools.sendname AS sendname, lti_tools.sendemailaddr AS sendemailaddr, lti_tools.allowoutcomes AS allowoutcomes, lti_tools.allowroster AS allowroster, lti_tools.allowsettings AS allowsettings, lti_tools.pl_launch AS pl_launch, lti_tools.pl_linkselection AS pl_linkselection, lti_tools.pl_contenteditor AS pl_contenteditor, lti_tools.pl_importitem AS pl_importitem, lti_tools.pl_fileitem AS pl_fileitem, lti_tools.pl_assessmentselection AS pl_assessmentselection, lti_tools.newpage AS newpage, lti_tools.debug AS debug, lti_tools.custom AS custom, lti_tools.settings AS settings, lti_tools.parameter AS parameter, lti_tools.tool_proxy_binding AS tool_proxy_binding, lti_tools.allowcustom AS allowcustom, lti_tools.sha256 AS sha256, lti_tools.lti13 AS lti13, lti_tools.lti13_settings AS lti13_settings, lti_tools.xmlimport AS xmlimport, lti_tools.splash AS splash, lti_tools.created_at AS created_at, lti_tools.updated_at AS updated_at FROM lti_tools WHERE (lti_tools.SITE_ID = ? OR (lti_tools.SITE_ID IS NULL AND lti_tools.visible != 1 ) ) AND (lti_tools.pl_launch = 1 OR ( ( lti_tools.pl_linkselection IS NULL OR lti_tools.pl_linkselection = 0 ) and ( lti_tools.pl_fileitem IS NULL OR lti_tools.pl_fileitem = 0 ) and ( lti_tools.pl_importitem IS NULL OR lti_tools.pl_importitem = 0 ) and ( lti_tools.pl_contenteditor IS NULL OR lti_tools.pl_contenteditor = 0 ) and ( lti_tools.pl_assessmentselection IS NULL OR lti_tools.pl_assessmentselection = 0 ) ) ) ORDER BY lti_tools.id] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LTI_TOOLS in statement [SELECT lti_tools.id AS id, lti_tools.version AS version, lti_tools.SITE_ID AS SITE_ID, lti_tools.title AS title, lti_tools.allowtitle AS allowtitle, lti_tools.fa_icon AS fa_icon, lti_tools.pagetitle AS pagetitle, lti_tools.allowpagetitle AS allowpagetitle, lti_tools.description AS description, lti_tools.status AS status, lti_tools.visible AS visible, lti_tools.resource_handler AS resource_handler, lti_tools.deployment_id AS deployment_id, lti_tools.launch AS launch, lti_tools.allowlaunch AS allowlaunch, lti_tools.consumerkey AS consumerkey, lti_tools.allowconsumerkey AS allowconsumerkey, lti_tools.secret AS secret, lti_tools.allowsecret AS allowsecret, lti_tools.frameheight AS frameheight, lti_tools.toolorder AS toolorder, lti_tools.allowframeheight AS allowframeheight, lti_tools.siteinfoconfig AS siteinfoconfig, lti_tools.sendname AS sendname, lti_tools.sendemailaddr AS sendemailaddr, lti_tools.allowoutcomes AS allowoutcomes, lti_tools.allowroster AS allowroster, lti_tools.allowsettings AS allowsettings, lti_tools.pl_launch AS pl_launch, lti_tools.pl_linkselection AS pl_linkselection, lti_tools.pl_contenteditor AS pl_contenteditor, lti_tools.pl_importitem AS pl_importitem, lti_tools.pl_fileitem AS pl_fileitem, lti_tools.pl_assessmentselection AS pl_assessmentselection, lti_tools.newpage AS newpage, lti_tools.debug AS debug, lti_tools.custom AS custom, lti_tools.settings AS settings, lti_tools.parameter AS parameter, lti_tools.tool_proxy_binding AS tool_proxy_binding, lti_tools.allowcustom AS allowcustom, lti_tools.sha256 AS sha256, lti_tools.lti13 AS lti13, lti_tools.lti13_settings AS lti13_settings, lti_tools.xmlimport AS xmlimport, lti_tools.splash AS splash, lti_tools.created_at AS created_at, lti_tools.updated_at AS updated_at FROM lti_tools WHERE (lti_tools.SITE_ID = ? OR (lti_tools.SITE_ID IS NULL AND lti_tools.visible != 1 ) ) AND (lti_tools.pl_launch = 1 OR ( ( lti_tools.pl_linkselection IS NULL OR lti_tools.pl_linkselection = 0 ) and ( lti_tools.pl_fileitem IS NULL OR lti_tools.pl_fileitem = 0 ) and ( lti_tools.pl_importitem IS NULL OR lti_tools.pl_importitem = 0 ) and ( lti_tools.pl_contenteditor IS NULL OR lti_tools.pl_contenteditor = 0 ) and ( lti_tools.pl_assessmentselection IS NULL OR lti_tools.pl_assessmentselection = 0 ) ) ) ORDER BY lti_tools.id] at org.hsqldb.jdbc.JDBCUtil.sqlException(null:-1) caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: LTI_TOOLS at org.hsqldb.error.Error.error(null:-1) at org.hsqldb.error.Error.error(null:-1) at org.hsqldb.ParserDQL.readTableName(null:-1) at org.hsqldb.ParserDQL.readTableOrSubquery(null:-1) at org.hsqldb.ParserDQL.XreadTableReference(null:-1) at org.hsqldb.ParserDQL.XreadFromClause(null:-1) at org.hsqldb.ParserDQL.XreadTableExpression(null:-1) at org.hsqldb.ParserDQL.XreadQuerySpecification(null:-1) at org.hsqldb.ParserDQL.XreadSimpleTable(null:-1) at org.hsqldb.ParserDQL.XreadQueryPrimary(null:-1) at org.hsqldb.ParserDQL.XreadQueryTerm(null:-1) at org.hsqldb.ParserDQL.XreadQueryExpressionBody(null:-1) at org.hsqldb.ParserDQL.XreadQueryExpression(null:-1) at org.hsqldb.ParserDQL.compileCursorSpecification(null:-1) at org.hsqldb.ParserCommand.compilePart(null:-1) at org.hsqldb.ParserCommand.compileStatement(null:-1) at org.hsqldb.Session.compileStatement(null:-1) at org.hsqldb.StatementManager.compile(null:-1) at org.hsqldb.Session.execute(null:-1) at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(null:-1) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(null:-1) at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:312) at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java:-1) at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1530) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:782) at org.sakaiproject.lti.impl.DBLTIService.getResultSet(DBLTIService.java:1036) at org.sakaiproject.lti.impl.DBLTIService.getThingsDao(DBLTIService.java:796) at org.sakaiproject.lti.impl.DBLTIService.getToolsDao(DBLTIService.java:214) at org.sakaiproject.lti.impl.BaseLTIService.getTools(BaseLTIService.java:530) at org.sakaiproject.lti.impl.BaseLTIService.getToolsLaunch(BaseLTIService.java:535) at org.sakaiproject.site.tool.SiteAction.getLtiToolGroup(SiteAction.java:6498) at org.sakaiproject.site.tool.SiteAction.getTools(SiteAction.java:6205) at org.sakaiproject.site.tool.SiteAction.buildContextForTemplate(SiteAction.java:1750) at org.sakaiproject.site.tool.SiteAction.buildMainPanelContext(SiteAction.java:1331) at org.sakaiproject.site.tool.SiteAction.buildShortcutPanelContext(SiteAction.java:1256) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(null:-1) at java.lang.reflect.Method.invoke(null:-1) at org.sakaiproject.cheftool.VelocityPortletPaneledAction.toolModeDispatch(VelocityPortletPaneledAction.java:399) at org.sakaiproject.site.tool.SiteAction.toolModeDispatch(SiteAction.java:14689) at org.sakaiproject.cheftool.ToolServlet.doGet(ToolServlet.java:234) at org.sakaiproject.cheftool.VelocityPortletPaneledAction.doGet(VelocityPortletPaneledAction.java:1152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) at org.sakaiproject.vm.ComponentServlet.service(ComponentServlet.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:418) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:356) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316) at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:513) at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1488) at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:200) at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96) at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:857) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:467) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(null:-1) at java.util.concurrent.ThreadPoolExecutor$Worker.run(null:-1) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(null:-1) user: admin usage-session: 11382de6-fbdd-4a86-946c-e37779ec21e3 time: Oct 29, 2018 18:01:23
      

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                maintenanceteam Core Team
                Reporter:
                venky venkateswara reddy
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration