Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]La conversión del tipo de datos varchar en smalldatetime produjo un valor fuera de intervalo.
|
|
The error occurred in C:/autoenred/forward2bu06_.cfm: line 167
|
165 : <cfif findRecord.recordcount EQ 0>
166 : <cfquery datasource="autoenred">
167 : insert into AnunVecesVisto values(#anuncio.IDconcesionario#, #anuncio.IDProvincia#, '#anuncio.AnuncioNum#', 1, 0, 0, #Now()#)
168 : </cfquery>
169 : <cfelse>
|
|
VENDORERRORCODE |
242 |
SQLSTATE |
22007 |
SQL |
insert into AnunVecesVisto values(1, 0, '1153241', 1, 0, 0, {ts '2024-03-28 11:27:39'})
|
DATASOURCE |
autoenred |
|
Resources:
|
Browser |
claudebot |
Remote Address |
52.91.255.225 |
Referrer |
|
Date/Time |
28-Mar-24 11:27 AM |
|
Stack Trace
|
at cfforward2bu06_2ecfm443118908.runPage(C:/autoenred/forward2bu06_.cfm:167)
at cfforward2bu06_2ecfm443118908.runPage(C:/autoenred/forward2bu06_.cfm:167)
java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]La conversión del tipo de datos varchar en smalldatetime produjo un valor fuera de intervalo.
at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1442)
at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1056)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:685)
at cfforward2bu06_2ecfm443118908.runPage(C:\autoenred\forward2bu06_.cfm:167)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
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:204)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
|
|