Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (28, 1,
1,
16,
16
) |
| | 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 (28, 1, 1). |
|
| NativeErrorCode | |
| queryError | | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (28, 1,
1,
16,
16
) |
|
| Sql | | string | INSERT INTO PriceLevel_Table
(ProductID, CountryID, PriceLevel, SalesPrice, Volume )
VALUES (28, 1,
1,
16,
16
) |
|
| 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 (28, 1, 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.call(/RootDir/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm:146)
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:94)
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.redaspen_iact405.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../redaspen-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:15)
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:140)
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:89)
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 | 144: <cfif IsDefined("REQUEST.SHOPPINGCART_TaxableType") and REQUEST.SHOPPINGCART_TaxableType eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_3[plvIndex]#"></cfif><br>
145: )<br>
<b>146: </cfquery></b><br>
147: </cfif><br>
148: <cfset plvIndex = plvIndex + 1><br>
|
| | codePrintPlain | | string | 144: <cfif IsDefined("REQUEST.SHOPPINGCART_TaxableType") and REQUEST.SHOPPINGCART_TaxableType eq 1>, <cfqueryparam cfsqltype="CF_SQL_DECIMAL" value="#PLVQuery.Price_3[plvIndex]#"></cfif>
145: )
146: </cfquery>
147: </cfif>
148: <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:146) |
| | template | | string | /www/redaspen-iact/system/modules/ShoppingCart/Modules/Categories/Actions/act_CheckUpdatePriceLevels.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 92: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#"><br>
93: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#"><br>
<b>94: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend---></b><br>
95: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#"><br>
96: </cfif><br>
|
| | codePrintPlain | | string | 92: <cfinclude template="#CallFile('act_CategoryLevels.cfm')#">
93: <cfinclude template="#CallFile('act_GetAllByCategory.cfm')#">
94: <cfinclude template="#CallFile('act_CheckUpdatePriceLevels.cfm')#"><!---this code will update the price levels for 100 products at a time from the backend--->
95: <cfinclude template="#CallFile('dsp_GetAllByCategory.cfm')#">
96: </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:94) |
| | template | | string | /www/redaspen-iact/system/modules/ShoppingCart/Modules/Categories/fbx_Switch.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 13: <cfset FuseSubAction="AllByCategory"><br>
14: <cfset FuseDirectory="Categories"><br>
<b>15: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"> </b><br>
16: </cfif><br>
17: <br>
|
| | codePrintPlain | | string | 13: <cfset FuseSubAction="AllByCategory">
14: <cfset FuseDirectory="Categories">
15: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#">
16: </cfif>
17:
|
| | column | | | id | | | line | | | Raw_Trace | | string | __138.__138.redaspen_iact405.system.modules.shoppingcart.skins.skin01.dsp_categoryshop_cfm$cf.call(../../redaspen-iact/system/modules/ShoppingCart/skins/skin01/dsp_CategoryShop.cfm:15) |
| | template | | string | /www/redaspen-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/redaspen-iact/system/modules/ShoppingCart/fbx_Switch.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 87: <br>
88: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---><br>
<b>89: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm"></b><br>
|
| | codePrintPlain | | string | 87:
88: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory--->
89: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | shoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:89) |
| | template | | string | /www/redaspen-iact/wwwroot/ShoppingCart/index.cfm |
| | type | |
|
|
| type | |
| where | |
