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.doFilter(ApplicationFilterChain.java:207)	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	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 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at com.dotmarketing.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:61)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:300)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at com.dotmarketing.filters.TimeMachineFilter.doFilter(TimeMachineFilter.java:174)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at nl.isaac.dotcms.davosselfservice.filter.LogDeeplinkFilter.doFilter(LogDeeplinkFilter.java:66)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at nl.isaac.dotcms.davosselfservice.filter.KeepAliveFilter.doFilter(KeepAliveFilter.java:36)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at nl.isaac.dotcms.davosselfservice.filter.RoutingFilter.doFilter(RoutingFilter.java:77)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at nl.isaac.dotcms.davosselfservice.filter.SelfServiceSessionInitialisationFilter.doFilter(SelfServiceSessionInitialisationFilter.java:32)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at nl.isaac.dotcms.davosselfservice.filter.LoginFilter.doFilter(LoginFilter.java:107)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	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 nl.isaac.dotcms.davosselfservice.filter.DisableWebsiteFilter.doFilter(DisableWebsiteFilter.java:123)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at nl.isaac.dotcms.davosselfservice.filter.RequestStoringFilter.doFilter(RequestStoringFilter.java:28)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at com.dotmarketing.filters.ThreadNameFilter.doFilter(ThreadNameFilter.java:90)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	at com.dotmarketing.filters.CookiesFilter.doFilter(CookiesFilter.java:33)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)	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.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)	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 org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)	at java.lang.Thread.run(Thread.java:745)