struct
Cause
struct
ErrorCode 2627
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551).
SQLState 23000
StackTrace java.sql.SQLIntegrityConstraintViolationException: [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551). at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.getMoreResults(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.getMoreResults(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.getMoreResults(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.getMoreResults(JRunStatement.java:282) at coldfusion.sql.Executive.getRowSets(Executive.java:789) at coldfusion.sql.Executive.executeCall(Executive.java:1035) at coldfusion.sql.Executive.executeCall(Executive.java:950) at coldfusion.sql.Executive.executeCall(Executive.java:901) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:461) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:290) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:239) at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor0(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:593) at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:584) 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:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:496) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:355) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor5(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:127) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor8(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:121) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor9(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1) at cfdisplay2dphotogallery2dglobal2ecfm134061337.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcpe2dcustomcf2ecfm1857702621.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm:187) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfelement2ecfm154628361$funcCALLELEMENT.runFunction(C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm:234) 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:2582) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2383) at cfrun2delement2ecfm875714665.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2delement2dcore2ecfm582044628._factor29(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:893) at cfct2drender2delement2dcore2ecfm582044628.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2delement2ecfm701820849.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2dnamed2delement2ecfm1419898266.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm:242) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:363) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftemplate2dunified2dbasepage2ecfm1340622559.runPage(C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfrender2dpage2dmeat2ecfm793918891.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm:252) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfrender2dpage2ecfm516040167.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm:36) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfmaster2drender2ecfm1370730143.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfuncached2dmaster2ecfm1621979370.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm:221) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcached2dpage2drender2ecfm1077887757.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm:226) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfmaster2ecfm1830181211._factor19(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:263) at cfmaster2ecfm1830181211._factor21(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:15) at cfmaster2ecfm1830181211.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfgallery2ehtm1773823556.runPage(C:\CMSContent\nri\sites\nps\media\photo\gallery.htm:78) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFSTOREDPROC
LINE 593
RAW_TRACE at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor0(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:593)
TEMPLATE C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_PHOTOGALLERYSERVICE
LINE 584
RAW_TRACE at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:584)
TEMPLATE C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 127
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor5(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:127)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 121
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor8(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:121)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 1
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor9(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 1
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 187
RAW_TRACE at cfcpe2dcustomcf2ecfm1857702621.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm:187)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 234
RAW_TRACE at cfelement2ecfm154628361$funcCALLELEMENT.runFunction(C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm:234)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm
TYPE CFML
9
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 35
RAW_TRACE at cfrun2delement2ecfm875714665.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm:35)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 893
RAW_TRACE at cfct2drender2delement2dcore2ecfm582044628._factor29(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:893)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_CT-RENDER-ELEMENT-CORE
LINE 1
RAW_TRACE at cfct2drender2delement2dcore2ecfm582044628.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:1)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm
TYPE CFML
12
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cfct2drender2delement2ecfm701820849.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm:2)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFINCLUDE
LINE 242
RAW_TRACE at cfct2drender2dnamed2delement2ecfm1419898266.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm:242)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm
TYPE CFML
14
struct
COLUMN 0
ID CFMODULE
LINE 35
RAW_TRACE at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:35)
TEMPLATE C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 363
RAW_TRACE at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:363)
TEMPLATE C:\CMSContent\common\commonspot\templates\template-basepage.cfm
TYPE CFML
16
struct
COLUMN 0
ID CFINCLUDE
LINE 9
RAW_TRACE at cftemplate2dunified2dbasepage2ecfm1340622559.runPage(C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm:9)
TEMPLATE C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm
TYPE CFML
17
struct
COLUMN 0
ID CFINCLUDE
LINE 252
RAW_TRACE at cfrender2dpage2dmeat2ecfm793918891.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm:252)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 36
RAW_TRACE at cfrender2dpage2ecfm516040167.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm:36)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm
TYPE CFML
19
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfmaster2drender2ecfm1370730143.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm:19)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 221
RAW_TRACE at cfuncached2dmaster2ecfm1621979370.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm:221)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 226
RAW_TRACE at cfcached2dpage2drender2ecfm1077887757.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm:226)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 263
RAW_TRACE at cfmaster2ecfm1830181211._factor19(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:263)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
23
struct
COLUMN 0
ID CF_MASTER
LINE 15
RAW_TRACE at cfmaster2ecfm1830181211._factor21(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:15)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
24
struct
COLUMN 0
ID CF_MASTER
LINE 1
RAW_TRACE at cfmaster2ecfm1830181211.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:1)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
25
struct
COLUMN 0
ID CFINCLUDE
LINE 78
RAW_TRACE at cfgallery2ehtm1773823556.runPage(C:\CMSContent\nri\sites\nps\media\photo\gallery.htm:78)
TEMPLATE C:\CMSContent\nri\sites\nps\media\photo\gallery.htm
TYPE CFML
Type java.sql.SQLIntegrityConstraintViolationException
DataSource commonspot-site-nps
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551).
ErrorCode 23000
Message Error Executing Database Query.
NativeErrorCode 2627
RootCause
struct
ErrorCode 2627
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551).
SQLState 23000
StackTrace java.sql.SQLIntegrityConstraintViolationException: [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551). at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.getMoreResults(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.getMoreResults(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.getMoreResults(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.getMoreResults(JRunStatement.java:282) at coldfusion.sql.Executive.getRowSets(Executive.java:789) at coldfusion.sql.Executive.executeCall(Executive.java:1035) at coldfusion.sql.Executive.executeCall(Executive.java:950) at coldfusion.sql.Executive.executeCall(Executive.java:901) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:461) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:290) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:239) at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor0(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:593) at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:584) 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:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:496) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:355) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor5(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:127) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor8(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:121) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor9(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1) at cfdisplay2dphotogallery2dglobal2ecfm134061337.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcpe2dcustomcf2ecfm1857702621.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm:187) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfelement2ecfm154628361$funcCALLELEMENT.runFunction(C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm:234) 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:2582) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2383) at cfrun2delement2ecfm875714665.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2delement2dcore2ecfm582044628._factor29(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:893) at cfct2drender2delement2dcore2ecfm582044628.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2delement2ecfm701820849.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2dnamed2delement2ecfm1419898266.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm:242) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:363) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftemplate2dunified2dbasepage2ecfm1340622559.runPage(C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfrender2dpage2dmeat2ecfm793918891.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm:252) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfrender2dpage2ecfm516040167.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm:36) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfmaster2drender2ecfm1370730143.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfuncached2dmaster2ecfm1621979370.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm:221) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcached2dpage2drender2ecfm1077887757.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm:226) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfmaster2ecfm1830181211._factor19(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:263) at cfmaster2ecfm1830181211._factor21(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:15) at cfmaster2ecfm1830181211.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfgallery2ehtm1773823556.runPage(C:\CMSContent\nri\sites\nps\media\photo\gallery.htm:78) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFSTOREDPROC
LINE 593
RAW_TRACE at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor0(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:593)
TEMPLATE C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_PHOTOGALLERYSERVICE
LINE 584
RAW_TRACE at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:584)
TEMPLATE C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 127
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor5(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:127)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 121
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor8(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:121)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 1
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor9(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 1
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 187
RAW_TRACE at cfcpe2dcustomcf2ecfm1857702621.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm:187)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 234
RAW_TRACE at cfelement2ecfm154628361$funcCALLELEMENT.runFunction(C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm:234)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm
TYPE CFML
9
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 35
RAW_TRACE at cfrun2delement2ecfm875714665.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm:35)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 893
RAW_TRACE at cfct2drender2delement2dcore2ecfm582044628._factor29(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:893)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_CT-RENDER-ELEMENT-CORE
LINE 1
RAW_TRACE at cfct2drender2delement2dcore2ecfm582044628.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:1)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm
TYPE CFML
12
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cfct2drender2delement2ecfm701820849.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm:2)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFINCLUDE
LINE 242
RAW_TRACE at cfct2drender2dnamed2delement2ecfm1419898266.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm:242)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm
TYPE CFML
14
struct
COLUMN 0
ID CFMODULE
LINE 35
RAW_TRACE at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:35)
TEMPLATE C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 363
RAW_TRACE at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:363)
TEMPLATE C:\CMSContent\common\commonspot\templates\template-basepage.cfm
TYPE CFML
16
struct
COLUMN 0
ID CFINCLUDE
LINE 9
RAW_TRACE at cftemplate2dunified2dbasepage2ecfm1340622559.runPage(C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm:9)
TEMPLATE C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm
TYPE CFML
17
struct
COLUMN 0
ID CFINCLUDE
LINE 252
RAW_TRACE at cfrender2dpage2dmeat2ecfm793918891.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm:252)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 36
RAW_TRACE at cfrender2dpage2ecfm516040167.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm:36)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm
TYPE CFML
19
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfmaster2drender2ecfm1370730143.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm:19)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 221
RAW_TRACE at cfuncached2dmaster2ecfm1621979370.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm:221)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 226
RAW_TRACE at cfcached2dpage2drender2ecfm1077887757.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm:226)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 263
RAW_TRACE at cfmaster2ecfm1830181211._factor19(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:263)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
23
struct
COLUMN 0
ID CF_MASTER
LINE 15
RAW_TRACE at cfmaster2ecfm1830181211._factor21(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:15)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
24
struct
COLUMN 0
ID CF_MASTER
LINE 1
RAW_TRACE at cfmaster2ecfm1830181211.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:1)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
25
struct
COLUMN 0
ID CFINCLUDE
LINE 78
RAW_TRACE at cfgallery2ehtm1773823556.runPage(C:\CMSContent\nri\sites\nps\media\photo\gallery.htm:78)
TEMPLATE C:\CMSContent\nri\sites\nps\media\photo\gallery.htm
TYPE CFML
Type java.sql.SQLIntegrityConstraintViolationException
SQLState 23000
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:249) at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor0(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:593) at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:584) 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:517) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:496) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:355) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor5(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:127) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor8(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:121) at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor9(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1) at cfdisplay2dphotogallery2dglobal2ecfm134061337.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcpe2dcustomcf2ecfm1857702621.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm:187) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfelement2ecfm154628361$funcCALLELEMENT.runFunction(C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm:234) 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:2582) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2383) at cfrun2delement2ecfm875714665.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2delement2dcore2ecfm582044628._factor29(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:893) at cfct2drender2delement2dcore2ecfm582044628.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2delement2ecfm701820849.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfct2drender2dnamed2delement2ecfm1419898266.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm:242) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:35) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:363) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftemplate2dunified2dbasepage2ecfm1340622559.runPage(C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfrender2dpage2dmeat2ecfm793918891.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm:252) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfrender2dpage2ecfm516040167.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm:36) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfmaster2drender2ecfm1370730143.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm:19) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfuncached2dmaster2ecfm1621979370.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm:221) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfcached2dpage2drender2ecfm1077887757.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm:226) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfmaster2ecfm1830181211._factor19(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:263) at cfmaster2ecfm1830181211._factor21(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:15) at cfmaster2ecfm1830181211.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfgallery2ehtm1773823556.runPage(C:\CMSContent\nri\sites\nps\media\photo\gallery.htm:78) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLIntegrityConstraintViolationException: [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551). at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.getMoreResults(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.getMoreResults(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.getMoreResults(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.getMoreResults(JRunStatement.java:282) at coldfusion.sql.Executive.getRowSets(Executive.java:789) at coldfusion.sql.Executive.executeCall(Executive.java:1035) at coldfusion.sql.Executive.executeCall(Executive.java:950) at coldfusion.sql.Executive.executeCall(Executive.java:901) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:461) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:290) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:239) ... 118 more
TagContext
array
1
struct
COLUMN 0
ID CFSTOREDPROC
LINE 593
RAW_TRACE at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS._factor0(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:593)
TEMPLATE C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_PHOTOGALLERYSERVICE
LINE 584
RAW_TRACE at cfPhotoGalleryService2ecfc1241162940$funcGETPHOTOSBYTAGIDS.runFunction(C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc:584)
TEMPLATE C:\CMSContent\common\components\nps\photogallery\PhotoGalleryService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 127
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor5(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:127)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 121
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor8(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:121)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 1
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337._factor9(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_DISPLAY-PHOTOGALLERY-GLOBAL
LINE 1
RAW_TRACE at cfdisplay2dphotogallery2dglobal2ecfm134061337.runPage(C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm:1)
TEMPLATE C:\CMSContent\common\commonspot\customcf\photogallery\display-photogallery-global.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFMODULE
LINE 187
RAW_TRACE at cfcpe2dcustomcf2ecfm1857702621.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm:187)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\controls\customcf\cpe-customcf.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 234
RAW_TRACE at cfelement2ecfm154628361$funcCALLELEMENT.runFunction(C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm:234)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\udf\element.cfm
TYPE CFML
9
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 35
RAW_TRACE at cfrun2delement2ecfm875714665.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm:35)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\run-element.cfm
TYPE CFML
10
struct
COLUMN 0
ID CFINCLUDE
LINE 893
RAW_TRACE at cfct2drender2delement2dcore2ecfm582044628._factor29(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:893)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm
TYPE CFML
11
struct
COLUMN 0
ID CF_CT-RENDER-ELEMENT-CORE
LINE 1
RAW_TRACE at cfct2drender2delement2dcore2ecfm582044628.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm:1)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element-core.cfm
TYPE CFML
12
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cfct2drender2delement2ecfm701820849.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm:2)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-element.cfm
TYPE CFML
13
struct
COLUMN 0
ID CFINCLUDE
LINE 242
RAW_TRACE at cfct2drender2dnamed2delement2ecfm1419898266.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm:242)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\ct-render-named-element.cfm
TYPE CFML
14
struct
COLUMN 0
ID CFMODULE
LINE 35
RAW_TRACE at cfagnostic2dtemplate2ecfm941150614.runPage(C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm:35)
TEMPLATE C:\CMSContent\common\commonspot\templates\includes\agnostic-template.cfm
TYPE CFML
15
struct
COLUMN 0
ID CFINCLUDE
LINE 363
RAW_TRACE at cftemplate2dbasepage2ecfm961847766.runPage(C:\CMSContent\common\commonspot\templates\template-basepage.cfm:363)
TEMPLATE C:\CMSContent\common\commonspot\templates\template-basepage.cfm
TYPE CFML
16
struct
COLUMN 0
ID CFINCLUDE
LINE 9
RAW_TRACE at cftemplate2dunified2dbasepage2ecfm1340622559.runPage(C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm:9)
TEMPLATE C:\CMSContent\nri\sites\nps\templates\template-unified-basepage.cfm
TYPE CFML
17
struct
COLUMN 0
ID CFINCLUDE
LINE 252
RAW_TRACE at cfrender2dpage2dmeat2ecfm793918891.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm:252)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\render-page-meat.cfm
TYPE CFML
18
struct
COLUMN 0
ID CFINCLUDE
LINE 36
RAW_TRACE at cfrender2dpage2ecfm516040167.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm:36)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\render-page.cfm
TYPE CFML
19
struct
COLUMN 0
ID CFINCLUDE
LINE 19
RAW_TRACE at cfmaster2drender2ecfm1370730143.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm:19)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master-render.cfm
TYPE CFML
20
struct
COLUMN 0
ID CFINCLUDE
LINE 221
RAW_TRACE at cfuncached2dmaster2ecfm1621979370.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm:221)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\uncached-master.cfm
TYPE CFML
21
struct
COLUMN 0
ID CFINCLUDE
LINE 226
RAW_TRACE at cfcached2dpage2drender2ecfm1077887757.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm:226)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\utilities\cached-page-render.cfm
TYPE CFML
22
struct
COLUMN 0
ID CFINCLUDE
LINE 263
RAW_TRACE at cfmaster2ecfm1830181211._factor19(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:263)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
23
struct
COLUMN 0
ID CF_MASTER
LINE 15
RAW_TRACE at cfmaster2ecfm1830181211._factor21(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:15)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
24
struct
COLUMN 0
ID CF_MASTER
LINE 1
RAW_TRACE at cfmaster2ecfm1830181211.runPage(C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm:1)
TEMPLATE C:\Apache2.2\htdocs\sites\nri\commonspot\master.cfm
TYPE CFML
25
struct
COLUMN 0
ID CFINCLUDE
LINE 78
RAW_TRACE at cfgallery2ehtm1773823556.runPage(C:\CMSContent\nri\sites\nps\media\photo\gallery.htm:78)
TEMPLATE C:\CMSContent\nri\sites\nps\media\photo\gallery.htm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__#tempPho__C565B12411AA861D'. Cannot insert duplicate key in object 'dbo.#tempPhoto'. The duplicate key value is (189551).
where (param 1) = [type='IN', class='java.lang.String', value='3430', sqltype='cf_sql_varchar'] , (param 2) = [type='IN', class='java.lang.Integer', value='40606', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='40611', sqltype='cf_sql_integer']