Explications présenter par LANGYARNS
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,2091,213,218,229,237,238,250,2001,2002,2003,2005,2008,2009,2010,2011,2013,2015,2016,2018,2019,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2062,2058,2060,2061,2063,2065,2067,2069,2071,2073,2075,2077,2079,2081,2083,2085,2087,2089,5029,456,5030,5033,5036,8001,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2522,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,2592,2594,2090,2088,2086,2084,2082,2080,2078,2076,2074,2072,2070,2068,2066,2064,2059)
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:1027)
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