Catch
Entries: 15
additional
Struct (ordered)
SQL
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (409, 2, 1, 17, 13 )
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.2104
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringNIKUSA
DataSource
stringNIKUSA
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringViolation of PRIMARY KEY constraint 'PK_PriceLevel_Table'. Cannot insert duplicate key in object 'dbo.PriceLevel_Table'. The duplicate key value is (409, 2, 1).
NativeErrorCode
number2627
queryError
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (409, 2, 1, 17, 13 )
Sql
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (409, 2, 1, 17, 13 )
SQLState
string23000
StackTrace
stringlucee.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 (409, 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.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
string145: &lt;cfif IsDefined(&quot;REQUEST.UsePrice_4&quot;) and REQUEST.UsePrice_4 eq 1&gt;, &lt;cfqueryparam cfsqltype=&quot;CF_SQL_DECIMAL&quot; value=&quot;#PLVQuery.Price_4[plvIndex]#&quot;&gt;&lt;/cfif&gt;<br> 146: )<br> <b>147: &lt;/cfquery&gt;</b><br> 148: &lt;/cfif&gt;<br> 149: &lt;cfset plvIndex = plvIndex + 1&gt;<br>
codePrintPlain
string145: <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
number0
id
string??
line
number147
Raw_Trace
stringsystem.modules.shoppingcart.modules.categories.actions.act_checkupdatepricelevels_cfm$cf.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
stringcfml
2
Struct
codePrintHTML
string88: &lt;cfinclude template=&quot;#CallFile('act_CategoryLevels.cfm')#&quot;&gt;<br> 89: &lt;cfinclude template=&quot;#CallFile('act_GetAllByCategory.cfm')#&quot;&gt;<br> <b>90: &lt;cfinclude template=&quot;#CallFile('act_CheckUpdatePriceLevels.cfm')#&quot;&gt;&lt;!---this code will update the price levels for 100 products at a time from the backend---&gt;</b><br> 91: &lt;cfinclude template=&quot;#CallFile('dsp_GetAllByCategory.cfm')#&quot;&gt;<br> 92: &lt;/cfif&gt;<br>
codePrintPlain
string88: <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
number0
id
string??
line
number90
Raw_Trace
stringsystem.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
stringcfml
3
Struct
codePrintHTML
string19: &lt;cfset FuseSubAction=&quot;AllByCategory&quot;&gt;<br> 20: &lt;cfset FuseDirectory=&quot;Categories&quot;&gt;<br> <b>21: &lt;cfinclude template=&quot;#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#&quot;&gt;</b><br> 22: &lt;/cfif&gt;<br> 23: <br>
codePrintPlain
string19: <cfset FuseSubAction="AllByCategory"> 20: <cfset FuseDirectory="Categories"> 21: <cfinclude template="#CallFile('fbx_Switch.cfm','ShoppingCart.Modules.#FuseDirectory#')#"> 22: </cfif> 23:
column
number0
id
string??
line
number21
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
stringcfml
4
Struct
codePrintHTML
string124: &lt;!--- WF 95086 ---&gt;<br> 125: &lt;cfinclude template=&quot;Actions/act_Header.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> <b>126: &lt;cfinclude template=&quot;#DisplayShopPath(&quot;dsp_CategoryShop.cfm&quot;)#&quot;&gt;</b><br> 127: &lt;cfinclude template=&quot;Actions/act_Footer.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> 128: &lt;cfsetting showdebugoutput=&quot;yes&quot;&gt;<br>
codePrintPlain
string124: <!--- 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
number0
id
string??
line
number126
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
stringcfml
5
Struct
codePrintHTML
string96: <br> 97: &lt;CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir&gt;&lt;!---reset new directory---&gt;<br> <b>98: &lt;CFINCLUDE Template=&quot;../../system/modules/ShoppingCart/fbx_Switch.cfm&quot;&gt;</b><br>
codePrintPlain
string96: 97: <CFSET CLIENT.ShoppingCart_Dir=REQUEST.ShoppingCart_Dir><!---reset new directory---> 98: <CFINCLUDE Template="../../system/modules/ShoppingCart/fbx_Switch.cfm">
column
number0
id
string??
line
number98
Raw_Trace
stringshoppingcart.index_cfm$cf.call(/ShoppingCart/index.cfm:98)
template
string/www/nikusa-iact/wwwroot/ShoppingCart/index.cfm
type
stringcfml
type
stringdatabase
where
string