Zbinden Mercerie

Modèles

LANGYARNS Modèles

Liste du matériel & Explications

Suppressed$[Ljava.lang.Throwable;@34f5667e:Sql$SELECT DISTINCT vwLANGArticleGroups.Saison_HW , vwLANGArticleGroups.Saison_FS , vwLANGArticleGroups.ArtNr , vwLANGArticleGroups.WGR_7 , vwLANGArticleGroups.SORT_PUBLICATION , CASE WHEN (Saison_HW = 2026) THEN 1 ELSE 0 END AS NEW FROM vwLANGArticleGroups INNER JOIN vwLANGModels ON vwLANGArticleGroups.ArtNr = vwLANGModels.AGR WHERE (vwLANGArticleGroups.Rubrik = N'30') AND ((Saison_FS IS NULL AND Saison_HW IS NULL) OR (Saison_HW = (param 1) ) OR ((Saison_FS <= (param 2) ) OR (Saison_HW < (param 3) ))) AND vwLANGArticleGroups.ArtNr IN(2093,2595,2596,2597,2598,2600,2593,2094,2092,9000,2085,2089,2071,205,2091,2081,2087,258,268,275,281,289,291,293,295,297,209,206,211,213,214,215,217,218,219,221,224,228,229,230,233,237,238,241,242,250,2001,2002,2003,2005,2006,2007,2009,2010,2011,2012,2013,2015,2017,2018,2019,2020,2021,2022,2023,2025,2027,2028,2029,2030,2031,2033,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2051,2052,2053,2054,2055,2056,2062,2058,2060,2061,2063,2069,2073,2065,2067,2075,2077,2079,2083,486,2057,2050,2024,2026,2034,2008,2014,2016,249,257,207,220,226,232,235,239,240,263,271,276,283,285,286,288,290,292,294,296,212,222,227,216,244,248,456,5029,5030,5033,5036,8001,8002,2506,2510,2513,2509,2504,2505,2507,2594,2592,2512,2514,2503,2511,2501,2502,2517,2516,2518,2521,2522,2508,2515,2520,2519,2523,2524,2525,2526,2527,2528,2529,2530,2531,2532,2533,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2555,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2066,2068,2090,2064,2059,2070,2074,2072,2076,2086,2080,2088,2082,2084,2078) ORDER BY NEW DESC, vwLANGArticleGroups.SORT_PUBLICATION DESC:SQLState$22018:queryError$[Macromedia][SQLServer JDBC Driver][SQLServer]Fehler beim Konvertieren des nvarchar-Werts "2500.0001" in den int-Datentyp.:RootCause$java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Fehler beim Konvertieren des nvarchar-Werts "2500.0001" in den int-Datentyp.:where$ (param 1) = [type='IN', class='java.lang.Long', value='2026', sqltype='cf_sql_bigint'] , (param 2) = [type='IN', class='java.lang.Long', value='2026', sqltype='cf_sql_bigint'] , (param 3) = [type='IN', class='java.lang.Long', value='2026', sqltype='cf_sql_bigint'] :StackTrace$coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfcfcFilter2ecfc680842171$funcQUERYPUBLICATIONS.runFunction(D:\web\pro\kundenshop\mastershop\dolphin\fw\cfc\langyarns\cfcFilter.cfc:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4142) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4105) at cfdolphin_template_list_models2ecfm677273207._factor1(D:\web\pro\kundenshop\mastershop\cfm\dolphin_template_list_models.cfm:188) at cfdolphin_template_list_models2ecfm677273207._factor6(D:\web\pro\kundenshop\mastershop\cfm\dolphin_template_list_models.cfm:184) at cfdolphin_template_list_models2ecfm677273207._factor8(D:\web\pro\kundenshop\mastershop\cfm\dolphin_template_list_models.cfm:41) at cfdolphin_template_list_models2ecfm677273207.runPage(D:\web\pro\kundenshop\mastershop\cfm\dolphin_template_list_models.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088) at cfdolphin_content2ecfm1070943951._factor44(D:\web\pro\kundenshop\mastershop\cfm\dolphin_content.cfm:1016) at cfdolphin_content2ecfm1070943951._factor45(D:\web\pro\kundenshop\mastershop\cfm\dolphin_content.cfm:67) at cfdolphin_content2ecfm1070943951._factor46(D:\web\pro\kundenshop\mastershop\cfm\dolphin_content.cfm:41) at cfdolphin_content2ecfm1070943951.runPage(D:\web\pro\kundenshop\mastershop\cfm\dolphin_content.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:330) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088) at cfmain2ecfm1709149114.runPage(D:\web\pro\kundenshop\mastershop\cfm\main.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088) at cfindex2ecfm818792070.runPage(D:\web\pro\kundenshop\ch\zbindenmercerie\www\index.cfm:226) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:446) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Fehler beim Konvertieren des nvarchar-Werts "2500.0001" in den int-Datentyp. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|:525) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1658) at coldfusion.sql.Executive.executeQuery(Executive.java:1384) at coldfusion.sql.Executive.executeQuery(Executive.java:1314) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) ... 80 more :Detail$[Macromedia][SQLServer JDBC Driver][SQLServer]Fehler beim Konvertieren des nvarchar-Werts "2500.0001" in den int-Datentyp.:NativeErrorCode$245:Message$Error Executing Database Query.:Cause$java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Fehler beim Konvertieren des nvarchar-Werts "2500.0001" in den int-Datentyp.:DataSource$ch_zbindenmercerie_pub:ErrorCode$22018:Type$Database