Login

< CONTINUE SHOPPING

Added to Cart!

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (583, 1, 1, 155, 155 )
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.2116
DriverName
stringMicrosoft JDBC Driver 7.2 for SQL Server
DriverVersion
string7.2.2.0
Datasource
stringGLOBALLEE
DataSource
stringGLOBALLEE
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 (583, 1, 1).
NativeErrorCode
number2627
queryError
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (583, 1, 1, 155, 155 )
Sql
stringINSERT INTO PriceLevel_Table (ProductID, CountryID, PriceLevel, SalesPrice, Volume ) VALUES (583, 1, 1, 155, 155 )
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 (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
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/globallee-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/globallee-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.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
stringcfml
4
Struct
codePrintHTML
string138: &lt;!--- WF 95086 ---&gt;<br> 139: &lt;cfinclude template=&quot;Actions/act_Header.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> <b>140: &lt;cfinclude template=&quot;#DisplayShopPath(&quot;dsp_CategoryShop.cfm&quot;)#&quot;&gt;</b><br> 141: &lt;cfinclude template=&quot;Actions/act_Footer.cfm&quot;&gt;&lt;!---wf 92679---&gt;<br> 142: &lt;cfsetting showdebugoutput=&quot;yes&quot;&gt;<br>
codePrintPlain
string138: <!--- 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
number0
id
string??
line
number140
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
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/globallee-iact/wwwroot/ShoppingCart/index.cfm
type
stringcfml
type
stringdatabase
where
string