java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function usp_getPhotosByTagIDs has too many arguments specified.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeCall(Executive.java:1053)
at coldfusion.sql.Executive.executeCall(Executive.java:926)
at coldfusion.sql.Executive.executeCall(Executive.java:876)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528)
at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:340)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:288)
at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor4(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:679)
at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:670)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
at cfdisplay2dphotogallery2ecfm773095022.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery.cfm:88)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfcpe2dcustomcf2ecfm1411909140.runPage(C:\Apache24\htdocs\sites\cms\commonspot\controls\customcf\cpe-customcf.cfm:130)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfelement2ecfm169218116$funcCALLELEMENT.runFunction(C:\Apache24\htdocs\sites\cms\commonspot\udf\element.cfm:306)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2451)
at cfrun2delement2ecfm2029939848.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\run-element.cfm:35)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2delement2dcore2ecfm1167625977._factor31(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element-core.cfm:894)
at cfct2drender2delement2dcore2ecfm1167625977.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element-core.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2delement2ecfm1415528924.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2dnamed2delement2ecfm1221382551.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-named-element.cfm:242)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:41)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:189)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dbasepage2drd2ecfm306357217.runPage(C:\CMSContent\common\commonspot\templates\template-basepage-rd.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dunified2dbasepage2ecfm54800924.runPage(C:\CMSContent\cms\sites\nps\templates\template-unified-basepage.cfm:9)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfrender2dpage2dmeat2ecfm598673181.runPage(C:\Apache24\htdocs\sites\cms\commonspot\render-page-meat.cfm:269)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfrender2dpage2ecfm837390197.runPage(C:\Apache24\htdocs\sites\cms\commonspot\render-page.cfm:36)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfmaster2drender2ecfm1601511857.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master-render.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfuncached2dmaster2ecfm383711132.runPage(C:\Apache24\htdocs\sites\cms\commonspot\uncached-master.cfm:222)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfcached2dpage2drender2ecfm69909796.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\cached-page-render.cfm:245)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfmaster2ecfm1051852813._factor23(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:287)
at cfmaster2ecfm1051852813._factor25(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:14)
at cfmaster2ecfm1051852813.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfphotogallery2ehtm702926495.runPage(C:\CMSContent\cms\sites\nps\photosmultimedia\photogallery.htm:79)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
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)

Suppressed

array
[empty]

TagContext

array

1

struct

COLUMN

0

ID

CFSTOREDPROC

LINE

679

RAW_TRACE

at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor4(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:679)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function usp_getPhotosByTagIDs has too many arguments specified.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeCall(Executive.java:1053)
at coldfusion.sql.Executive.executeCall(Executive.java:926)
at coldfusion.sql.Executive.executeCall(Executive.java:876)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528)
at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:340)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:288)
at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor4(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:679)
at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:670)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
at cfdisplay2dphotogallery2ecfm773095022.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery.cfm:88)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfcpe2dcustomcf2ecfm1411909140.runPage(C:\Apache24\htdocs\sites\cms\commonspot\controls\customcf\cpe-customcf.cfm:130)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfelement2ecfm169218116$funcCALLELEMENT.runFunction(C:\Apache24\htdocs\sites\cms\commonspot\udf\element.cfm:306)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2451)
at cfrun2delement2ecfm2029939848.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\run-element.cfm:35)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2delement2dcore2ecfm1167625977._factor31(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element-core.cfm:894)
at cfct2drender2delement2dcore2ecfm1167625977.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element-core.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2delement2ecfm1415528924.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2dnamed2delement2ecfm1221382551.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-named-element.cfm:242)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:41)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:189)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dbasepage2drd2ecfm306357217.runPage(C:\CMSContent\common\commonspot\templates\template-basepage-rd.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dunified2dbasepage2ecfm54800924.runPage(C:\CMSContent\cms\sites\nps\templates\template-unified-basepage.cfm:9)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfrender2dpage2dmeat2ecfm598673181.runPage(C:\Apache24\htdocs\sites\cms\commonspot\render-page-meat.cfm:269)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfrender2dpage2ecfm837390197.runPage(C:\Apache24\htdocs\sites\cms\commonspot\render-page.cfm:36)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfmaster2drender2ecfm1601511857.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master-render.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfuncached2dmaster2ecfm383711132.runPage(C:\Apache24\htdocs\sites\cms\commonspot\uncached-master.cfm:222)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfcached2dpage2drender2ecfm69909796.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\cached-page-render.cfm:245)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfmaster2ecfm1051852813._factor23(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:287)
at cfmaster2ecfm1051852813._factor25(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:14)
at cfmaster2ecfm1051852813.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfphotogallery2ehtm702926495.runPage(C:\CMSContent\cms\sites\nps\photosmultimedia\photogallery.htm:79)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
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)

Suppressed

array
[empty]

TagContext

array

1

struct

COLUMN

0

ID

CFSTOREDPROC

LINE

679

RAW_TRACE

at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor4(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:679)

at cfmaster2ecfm1051852813._factor23(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:287)

TEMPLATE

C:\Apache24\htdocs\sites\cms\commonspot\master.cfm

TYPE

CFML

21

struct

COLUMN

0

ID

CF_MASTER

LINE

14

RAW_TRACE

at cfmaster2ecfm1051852813._factor25(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:14)

TEMPLATE

C:\Apache24\htdocs\sites\cms\commonspot\master.cfm

TYPE

CFML

22

struct

COLUMN

0

ID

CF_MASTER

LINE

1

RAW_TRACE

at cfmaster2ecfm1051852813.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:1)

TEMPLATE

C:\Apache24\htdocs\sites\cms\commonspot\master.cfm

TYPE

CFML

23

struct

COLUMN

0

ID

CFINCLUDE

LINE

79

RAW_TRACE

at cfphotogallery2ehtm702926495.runPage(C:\CMSContent\cms\sites\nps\photosmultimedia\photogallery.htm:79)

TEMPLATE

C:\CMSContent\cms\sites\nps\photosmultimedia\photogallery.htm

TYPE

CFML

Type

java.sql.SQLException

SQLState

HY000

Sql

{call usp_getPhotosByTagIDs( (param 1) , (param 2) , (param 3) )}

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:298)
at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor4(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:679)
at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:670)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
at cfdisplay2dphotogallery2ecfm773095022.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery.cfm:88)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfcpe2dcustomcf2ecfm1411909140.runPage(C:\Apache24\htdocs\sites\cms\commonspot\controls\customcf\cpe-customcf.cfm:130)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfelement2ecfm169218116$funcCALLELEMENT.runFunction(C:\Apache24\htdocs\sites\cms\commonspot\udf\element.cfm:306)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2451)
at cfrun2delement2ecfm2029939848.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\run-element.cfm:35)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2delement2dcore2ecfm1167625977._factor31(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element-core.cfm:894)
at cfct2drender2delement2dcore2ecfm1167625977.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element-core.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2delement2ecfm1415528924.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-element.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfct2drender2dnamed2delement2ecfm1221382551.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\ct-render-named-element.cfm:242)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:41)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:189)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dbasepage2drd2ecfm306357217.runPage(C:\CMSContent\common\commonspot\templates\template-basepage-rd.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cftemplate2dunified2dbasepage2ecfm54800924.runPage(C:\CMSContent\cms\sites\nps\templates\template-unified-basepage.cfm:9)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfrender2dpage2dmeat2ecfm598673181.runPage(C:\Apache24\htdocs\sites\cms\commonspot\render-page-meat.cfm:269)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfrender2dpage2ecfm837390197.runPage(C:\Apache24\htdocs\sites\cms\commonspot\render-page.cfm:36)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfmaster2drender2ecfm1601511857.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master-render.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfuncached2dmaster2ecfm383711132.runPage(C:\Apache24\htdocs\sites\cms\commonspot\uncached-master.cfm:222)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfcached2dpage2drender2ecfm69909796.runPage(C:\Apache24\htdocs\sites\cms\commonspot\utilities\cached-page-render.cfm:245)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfmaster2ecfm1051852813._factor23(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:287)
at cfmaster2ecfm1051852813._factor25(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:14)
at cfmaster2ecfm1051852813.runPage(C:\Apache24\htdocs\sites\cms\commonspot\master.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
at cfphotogallery2ehtm702926495.runPage(C:\CMSContent\cms\sites\nps\photosmultimedia\photogallery.htm:79)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
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)
Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function usp_getPhotosByTagIDs has too many arguments specified.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeCall(Executive.java:1053)
at coldfusion.sql.Executive.executeCall(Executive.java:926)
at coldfusion.sql.Executive.executeCall(Executive.java:876)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528)
at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:340)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:288)
... 128 more

Suppressed

array
[empty]

TagContext

array

1

struct

COLUMN

0

ID

CFSTOREDPROC

LINE

679

RAW_TRACE

at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor4(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:679)