Lucee 5.0.0.254 Error (database)
Message
Detail	Incorrect syntax near '2021'.
SQL	{ call usp_cms_select_paging_amh(?,?,?,?,?,?,?,?,?) }
DatabaseName	Microsoft SQL Server
DatabaseVersion	13.00.2149
DriverName	jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
DriverVersion	1.2.8
Datasource	c147501-h217564_aw_site
Stacktrace	The Error Occurred in D:\Inetpub\wwwroot\AltmanWeil\dir_queries\qry_object_list.cfm: line 69 67: <!--- records total ---> 68: <cfprocresult name="#attributes.r_intTotalRecords#" resultset="2"> 69: </cfstoredproc> 70: <!--- <cfinclude template="../dir_actions/act_inline_error.cfm"> ---> 71: <cfcatch> called from D:\Inetpub\wwwroot\AltmanWeil\dir_merger\act_do_merger_list.cfm: line 46 44: r_qQueryName = "qMergerData" 45: r_blnSuccess = "blnSuccess" 46: r_errList = "errList"> 47: <!--- provide the sortable strings to use on the front end ---> 48: <cfif isDefined("attributes.dt") AND attributes.dt EQ "DESC"> called from D:\Inetpub\wwwroot\AltmanWeil\dir_merger\act_home.cfm: line 147 145: 146: <!--- Get data, this file is shared with the full-year listing ---> 147: <cfinclude template="act_do_merger_list.cfm"/> 148: 149: <!--- Build "Full Year" URL String ---> called from D:\Inetpub\wwwroot\AltmanWeil\parsed\parsed.m.home.cfm: line 34 32: <cfset xfa.strCaseStudyDetail = "a.case_study_detail/oid/"> 33: <!--- generated by fuseQ[15] verb: INCLUDE via m.viewHome ---> 34: <cftry><cfoutput><cfinclude template="..\dir_merger/act_home.cfm"></cfoutput><cfcatch type="missingInclude"><cfif Right(cfcatch.missingFilename, len("dir_merger/act_home.cfm") ) EQ "dir_merger/act_home.cfm"><cfthrow type="fusebox.missingFuse" message="missing Fuse" detail="You tried to include a fuse act_home in circuit m which does not exist."><cfelse><cfrethrow></cfif></cfcatch></cftry> 35: <!--- generated by fuseQ[16] verb: INCLUDE via m.viewHome ---> 36: <cftry><cfoutput><cfinclude template="..\dir_merger/dsp_home.cfm"></cfoutput><cfcatch type="missingInclude"><cfif Right(cfcatch.missingFilename, len("dir_merger/dsp_home.cfm") ) EQ "dir_merger/dsp_home.cfm"><cfthrow type="fusebox.missingFuse" message="missing Fuse" detail="You tried to include a fuse dsp_home in circuit m which does not exist."><cfelse><cfrethrow></cfif></cfcatch></cftry> called from D:\Inetpub\wwwroot\AltmanWeil\fusebox40.runtime.cfmx.cfm: line 203 201: <cfif myFusebox.parameters.execute> 202: <cftry> 203: <cfinclude template="#fb_.file2Parse#"> 204: <cfcatch type="missingInclude"> 205: <cfif right(cfcatch.missingFileName, Len(fb_.file2Parse)) EQ called from D:\Inetpub\wwwroot\AltmanWeil\index.cfm: line 47 45: </cftry> 46: <cfelse> 47: <cfinclude template="fusebox40.runtime.cfmx.cfm"> 48: </cfif>
Java Stacktrace	lucee.runtime.exp.DatabaseException: at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:649) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:764) at com.seefusion.PreparedStatementImpl.execute(PreparedStatementImpl.java:99) at lucee.runtime.tag.StoredProc.doEndTag(StoredProc.java:577) at dir_queries.qry_object_list_cfm$cf.call(D:\Inetpub\wwwroot\AltmanWeil\dir_queries\qry_object_list.cfm:69) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803) at lucee.runtime.tag.CFTag.doInclude(CFTag.java:324) at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:246) at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:178) at dir_merger.act_do_merger_list_cfm$cf.call(D:\Inetpub\wwwroot\AltmanWeil\dir_merger\act_do_merger_list.cfm:46) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:794) at dir_merger.act_home_cfm$cf.call(D:\Inetpub\wwwroot\AltmanWeil\dir_merger\act_home.cfm:147) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:794) at parsed.parsed_m_home_cfm736$cf.call(D:\Inetpub\wwwroot\AltmanWeil\parsed\parsed.m.home.cfm:34) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:794) at fusebox40_runtime_cfmx_cfm1288$cf.call(D:\Inetpub\wwwroot\AltmanWeil\fusebox40.runtime.cfmx.cfm:203) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:794) at index_cfm$cf.call(D:\Inetpub\wwwroot\AltmanWeil\index.cfm:47) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:62) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2250) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2242) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2210) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:848) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:103) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at com.seefusion.Filter.doFilter(Filter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Timestamp	12/7/21 3:27:11 AM EST