Catch Entries: 15 |
additional | Struct (ordered) | SQL | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (583, 1,
1,
155,
155
) |
| DatabaseName | string | Microsoft SQL Server |
| DatabaseVersion | | DriverName | string | Microsoft JDBC Driver 7.2 for SQL Server |
| DriverVersion | | Datasource | |
|
DataSource | |
Detail | |
ErrorCode | |
Extended_Info | |
ExtendedInfo | |
Message | string | Violation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (583, 1, 1). |
|
NativeErrorCode | |
queryError | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (583, 1,
1,
155,
155
) |
|
Sql | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (583, 1,
1,
155,
155
) |
|
SQLState | |
StackTrace | string | lucee.runtime.exp.DatabaseException: Violation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (583, 1, 1).
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134)
at lucee.runtime.tag.Query._doEndTag(Query.java:699)
at lucee.runtime.tag.Query.doEndTag(Query.java:565)
at system.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:147)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1054)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:946)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:927)
at system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:90)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1054)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:946)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:927)
at __138.__138.globallee_iact450.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../globallee-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:21)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1054)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:946)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:927)
at __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:140)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1054)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:946)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:927)
at shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1054)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:946)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2490)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2476)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2447)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1198)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1144)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
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:750)
|
|
TagContext | Array | 1 | Struct | codePrintHTML | string | 145: <cfif IsDefined("REQUEST.UsePrice_4") and REQUEST.UsePrice_4 eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_4[plvIndex]#"></cfif><br>
146: )<br>
<b>147: </cfquery></b><br>
148: </cfif><br>
149: <cfset plvIndex = plvIndex + 1><br>
|
| codePrintPlain | string | 145: <cfif IsDefined("REQUEST.UsePrice_4") and REQUEST.UsePrice_4 eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_4[plvIndex]#"></cfif>
146: )
147: </cfquery>
148: </cfif>
149: <cfset plvIndex = plvIndex + 1>
|
| column | | id | | line | | Raw_Trace | string | system.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:147) |
| template | string | /www/globallee-iact/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 88: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#"><br>
89: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#"><br>
<b>90: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend---></b><br>
91: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#"><br>
92: </cfif><br>
|
| codePrintPlain | string | 88: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#">
89: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#">
90: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend--->
91: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#">
92: </cfif>
|
| column | | id | | line | | Raw_Trace | string | system.modules.shoppingcart.modules.categories.fbx_switch_cfm$cf.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm:90) |
| template | string | /www/globallee-iact/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm |
| type | |
| 3 | Struct | codePrintHTML | string | 19: <cfset FuseSubAction="AllByCategory"><br>
20: <cfset FuseDirectory="Categories"><br>
<b>21: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"></b><br>
22: </cfif><br>
23: <br>
|
| codePrintPlain | string | 19: <cfset FuseSubAction="AllByCategory">
20: <cfset FuseDirectory="Categories">
21: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#">
22: </cfif>
23:
|
| column | | id | | line | | Raw_Trace | string | __138.__138.globallee_iact450.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../globallee-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:21) |
| template | string | /www/globallee-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm |
| type | |
| 4 | Struct | codePrintHTML | string | 138: <!--- WF 95086 ---><br>
139: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679---><br>
<b>140: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#"></b><br>
141: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679---><br>
142: <cfsetting showdebugoutput="yes"><br>
|
| codePrintPlain | string | 138: <!--- WF 95086 --->
139: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679--->
140: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#">
141: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679--->
142: <cfsetting showdebugoutput="yes">
|
| column | | id | | line | | Raw_Trace | string | __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:140) |
| template | string | /www/globallee-iact/system/modules/ShoppingCart/fbx_Switch.cfm |
| type | |
| 5 | Struct | codePrintHTML | string | 96: <br>
97: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---><br>
<b>98: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm"></b><br>
|
| codePrintPlain | string | 96:
97: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory--->
98: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
|
| column | | id | | line | | Raw_Trace | string | shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98) |
| template | string | /www/globallee-iact/wwwroot/ShoppingCart/index.cfm |
| type | |
|
|
type | |
where | |