struct
Cause
struct
ErrorCode 209
Message [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.v(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1081) at coldfusion.sql.Executive.executeCall(Executive.java:954) at coldfusion.sql.Executive.executeCall(Executive.java:904) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:338) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:286) at cfnoticias35Estatuto2ecfm1774519105.runPage(\\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm:93) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) 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:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 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:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFSTOREDPROC
LINE 93
RAW_TRACE at cfnoticias35Estatuto2ecfm1774519105.runPage(\\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm:93)
TEMPLATE \\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm
TYPE CFML
Type java.sql.SQLException
DataSource icalnews
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo.
Message Error Executing Database Query.
NativeErrorCode 209
RootCause
struct
ErrorCode 209
Message [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.v(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1081) at coldfusion.sql.Executive.executeCall(Executive.java:954) at coldfusion.sql.Executive.executeCall(Executive.java:904) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:338) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:286) at cfnoticias35Estatuto2ecfm1774519105.runPage(\\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm:93) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) 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:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 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:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFSTOREDPROC
LINE 93
RAW_TRACE at cfnoticias35Estatuto2ecfm1774519105.runPage(\\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm:93)
TEMPLATE \\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql {call sp_selectnextn( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) )}
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:296) at cfnoticias35Estatuto2ecfm1774519105.runPage(\\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm:93) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) 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:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 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:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.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.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.v(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeCall(Executive.java:1081) at coldfusion.sql.Executive.executeCall(Executive.java:954) at coldfusion.sql.Executive.executeCall(Executive.java:904) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:338) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:286) ... 39 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFSTOREDPROC
LINE 93
RAW_TRACE at cfnoticias35Estatuto2ecfm1774519105.runPage(\\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm:93)
TEMPLATE \\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]El nombre de columna 'fechagrabacion' es ambiguo.
where (param 1) = [type='IN', class='java.lang.String', value='hemeroteca LEFT JOIN ArchivoFotos ON hemeroteca.IdFoto = ArchivoFotos.IdFoto', sqltype='CF_SQL_VARCHAR'] , (param 2) = [type='IN', class='java.lang.String', value='hemeroteca.id, hemeroteca.titular, ArchivoFotos.IdFoto,ArchivoFotos.PieFoto, hemeroteca.subtitulo, hemeroteca.fecha, hemeroteca.Tprovincia, hemeroteca.Tseccion, hemeroteca.Tfirma,ArchivoFotos.Icono,hemeroteca.fechagrabacion, ArchivoFotos.imagen,ArchivoFotos.IMAGENPRN , ArchivoFotos.CarpetaIni, ArchivoFotos.CarpetaFin', sqltype='CF_SQL_VARCHAR'] , (param 3) = [type='IN', class='java.lang.String', value='id', sqltype='CF_SQL_VARCHAR'] , (param 4) = [type='IN', class='java.lang.String', value='1', sqltype='CF_SQL_VARCHAR'] , (param 5) = [type='IN', class='java.lang.String', value='30', sqltype='CF_SQL_VARCHAR'] , (param 6) = [type='IN', class='java.lang.String', value='titular<>'Titulares de prensa' and estilo<>5 and hemeroteca.servicioespecial='s' and hemeroteca.fecha > DATEADD(day, -60, getdate()) and TextoNews_Html is not null ', sqltype='CF_SQL_VARCHAR'] , (param 7) = [type='IN', class='java.lang.String', value='hemeroteca.fecha desc, fechagrabacion desc', sqltype='CF_SQL_VARCHAR']
struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE [empty string]
CERT_SECRETKEYSIZE [empty string]
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER [empty string]
CERT_SERVER_SUBJECT [empty string]
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH \\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm
CONTENT_LENGTH 0
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE [empty string]
HTTPS_SECRETKEYSIZE [empty string]
HTTPS_SERVER_ISSUER [empty string]
HTTPS_SERVER_SUBJECT [empty string]
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE [empty string]
HTTP_HOST www.icalnews.com
HTTP_REFERER [empty string]
HTTP_USER_AGENT CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO [empty string]
PATH_TRANSLATED \\Ceresftp\SITIOSWEB\CF_WEB_ICALNEWS\noticias35Estatuto.cfm
QUERY_STRING [empty string]
REMOTE_ADDR 34.236.216.93
REMOTE_HOST 34.236.216.93
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /noticias35Estatuto.cfm
SERVER_NAME www.icalnews.com
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/8.5
WEB_SERVER_API [empty string]
struct [empty]
struct [empty]
struct
ACCION [empty string]
COUNT 30
PAGINA 1