com.dotmarketing.business.DotStateException: Invalid or pernicious sql parameter passed in : DropdownText

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Bart Plasmans, 1 year ago
Invalid or pernicious sql parameter passed in : DropdownText
via GitHub by brentgriffin
, 1 year ago
Invalid or pernicious sql parameter passed in : DropdownText
com.dotmarketing.business.DotStateException: Invalid or pernicious sql parameter passed in : DropdownText
at com.dotmarketing.common.util.SQLUtil.sanitizeParameter(SQLUtil.java:201)
at com.dotmarketing.portlets.structure.factories.StructureFactory.getStructureByVelocityVarName(StructureFactory.java:109)
at com.dotmarketing.cache.ContentTypeCacheImpl.getStructureByVelocityVarName(ContentTypeCacheImpl.java:135)
at com.dotmarketing.cache.FieldsCache.getFieldsByStructureVariableName(FieldsCache.java:82)
at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.translateQuerySortBy(ESContentFactoryImpl.java:1644)
at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.translateQuery(ESContentFactoryImpl.java:1600)
at com.dotcms.content.elasticsearch.business.ESContentFactoryImpl.indexSearch(ESContentFactoryImpl.java:1248)
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.searchIndex(ESContentletAPIImpl.java:665)
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.search(ESContentletAPIImpl.java:537)
at com.dotcms.content.elasticsearch.business.ESContentletAPIImpl.search(ESContentletAPIImpl.java:529)
at com.dotmarketing.portlets.contentlet.business.ContentletAPIInterceptor.search(ContentletAPIInterceptor.java:1561)
at com.dotmarketing.viewtools.content.util.ContentUtils.pull(ContentUtils.java:231)
at com.dotmarketing.viewtools.content.ContentTool.pull(ContentTool.java:164)
at com.dotmarketing.viewtools.content.ContentTool.pull(ContentTool.java:157)
at sun.reflect.GeneratedMethodAccessor364.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:372)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:361)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:178)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:285)
at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:572)
at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:321)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:211)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.Template.merge(Template.java:362)
at org.apache.velocity.Template.merge(Template.java:265)
at com.dotmarketing.viewtools.VelocityWebUtil.mergeTemplate(VelocityWebUtil.java:87)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:372)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:361)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:178)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:285)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:374)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:308)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:226)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:211)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.Template.merge(Template.java:362)
at org.apache.velocity.Template.merge(Template.java:265)
at com.dotmarketing.viewtools.VelocityWebUtil.mergeTemplate(VelocityWebUtil.java:87)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:372)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:361)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:178)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:285)
at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:572)
at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71)
at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:150)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.Template.merge(Template.java:362)
at org.apache.velocity.Template.merge(Template.java:265)
at com.dotmarketing.viewtools.VelocityWebUtil.mergeTemplate(VelocityWebUtil.java:87)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:372)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:361)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:178)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:285)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:374)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:308)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:226)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:211)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:308)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:226)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:211)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:423)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:211)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.Template.merge(Template.java:362)
at org.apache.velocity.Template.merge(Template.java:265)
at com.dotmarketing.viewtools.VelocityWebUtil.mergeTemplate(VelocityWebUtil.java:87)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:372)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:361)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:178)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:285)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:374)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:308)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:226)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:211)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.Template.merge(Template.java:362)
at org.apache.velocity.Template.merge(Template.java:265)
at com.dotmarketing.viewtools.VelocityWebUtil.mergeTemplate(VelocityWebUtil.java:87)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:372)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:361)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:178)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:285)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:374)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:330)
at org.apache.velocity.Template.merge(Template.java:362)
at org.apache.velocity.Template.merge(Template.java:265)
at com.dotmarketing.velocity.VelocityServlet.doLiveMode(VelocityServlet.java:523)
at com.dotmarketing.velocity.VelocityServlet.service(VelocityServlet.java:216)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.MiddlewareCleanupFilter.doFilter(MiddlewareCleanupFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:720)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:466)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:391)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:318)
at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:209)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at com.dotmarketing.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:300)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at com.dotmarketing.filters.TimeMachineFilter.doFilter(TimeMachineFilter.java:174)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.LogDeeplinkFilter.doFilter(LogDeeplinkFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.KeepAliveFilter.doFilter(KeepAliveFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.RoutingFilter.doFilter(RoutingFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.SelfServiceSessionInitialisationFilter.doFilter(SelfServiceSessionInitialisationFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.LoginFilter.doFilter(LoginFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.MiddlewareCleanupFilter.doFilter(MiddlewareCleanupFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.DisableWebsiteFilter.doFilter(DisableWebsiteFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at nl.isaac.dotcms.davosselfservice.filter.RequestStoringFilter.doFilter(RequestStoringFilter.java:28)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at com.dotmarketing.filters.ThreadNameFilter.doFilter(ThreadNameFilter.java:90)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at com.dotmarketing.filters.CookiesFilter.doFilter(CookiesFilter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:146)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:868)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.