Catch Entries: 15 |
additional | Struct (ordered) | SQL | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (235, 2,
1,
790,
608
) |
| DatabaseName | string | Microsoft SQL Server |
| DatabaseVersion | | DriverName | string | Microsoft JDBC Driver 6.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 (235, 2, 1). |
|
NativeErrorCode | |
queryError | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (235, 2,
1,
790,
608
) |
|
Sql | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (235, 2,
1,
790,
608
) |
|
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 (235, 2, 1).
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:393)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:327)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:282)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:227)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112)
at lucee.runtime.tag.Query._doEndTag(Query.java:686)
at lucee.runtime.tag.Query.doEndTag(Query.java:553)
at system.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf$9g4.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:147)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
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:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at __138.__138.nikusa_iact315.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../nikusa-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:21)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:126)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
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:52)
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:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
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$9g4.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:147) |
| template | string | /www/nikusa-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/nikusa-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.nikusa_iact315.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../nikusa-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:21) |
| template | string | /www/nikusa-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm |
| type | |
| 4 | Struct | codePrintHTML | string | 124: <!--- WF 95086 ---><br>
125: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679---><br>
<b>126: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#"></b><br>
127: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679---><br>
128: <cfsetting showdebugoutput="yes"><br>
|
| codePrintPlain | string | 124: <!--- WF 95086 --->
125: <cfinclude template="Actions/act_Header.cfm"><!---wf 92679--->
126: <cfinclude template="#DisplayShopPath("dsp_CategoryShop.cfm")#">
127: <cfinclude template="Actions/act_Footer.cfm"><!---wf 92679--->
128: <cfsetting showdebugoutput="yes">
|
| column | | id | | line | | Raw_Trace | string | __138.system.modules.shoppingcart.fbx_switch_cfm$cf.call(../system/modules/ShoppingCart/fbx_Switch.cfm:126) |
| template | string | /www/nikusa-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/nikusa-iact/wwwroot/ShoppingCart/index.cfm |
| type | |
|
|
type | |
where | |