Accept Cookies?
Provided by OpenGlobal E-commerce
The place for interesting news and communications – all revealed here

News & Events

Read our latest news and developments here and check out our busy events schedule.

INTEGRATED MAINTENANCE & INTEGRITY SOLUTIONS

News & Events

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'newsDate'.
 
The error occurred in D:/inetpub/wwwroot/icr/www/priv/inc/newsInnerSide.cfm: line 65
Called from D:/inetpub/wwwroot/icr/www/priv/views/news.cfm: line 89
Called from D:/inetpub/wwwroot/icr/www/pub/index.cfm: line 88
Called from D:/inetpub/wwwroot/icr/www/pub/index.cfm: line 11
Called from D:/inetpub/wwwroot/icr/www/pub/index.cfm: line 1
Called from D:/inetpub/wwwroot/icr/www/priv/inc/newsInnerSide.cfm: line 65
Called from D:/inetpub/wwwroot/icr/www/priv/views/news.cfm: line 89
Called from D:/inetpub/wwwroot/icr/www/pub/index.cfm: line 88
Called from D:/inetpub/wwwroot/icr/www/pub/index.cfm: line 11
Called from D:/inetpub/wwwroot/icr/www/pub/index.cfm: line 1
63 : 												AND IM_news.newsDate LIKE '%-0#i#-%'
64 : 											<cfelse>
65 : 												AND IM_news.newsDate LIKE '%-#i#-%'
66 : 											</cfif>
67 : 											AND getDate() >= IM_news.newsDate

SQLSTATE   42S22
DATASOURCE   invest-aberdeen-live
VENDORERRORCODE   207
SQL    SELECT IM_news.navID, IM_navigation.navTitle, IM_news.newsDate, IM_navigation.navLink FROM IM_news INNER JOIN IM_navigation ON IM_news.navID = IM_navigation.ID WHERE IM_news.newsDate LIKE '%2018%' AND IM_news.newsDate LIKE '%-03-%' AND getDate() >= IM_news.newsDate
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.221.75.68
Referrer  
Date/Time   15-Nov-18 01:16 PM
Stack Trace
at cfnewsInnerSide2ecfm1598964670.runPage(D:/inetpub/wwwroot/icr/www/priv/inc/newsInnerSide.cfm:65) at cfnews2ecfm1849148043.runPage(D:/inetpub/wwwroot/icr/www/priv/views/news.cfm:89) at cfindex2ecfm1129068187._factor9(D:/inetpub/wwwroot/icr/www/pub/index.cfm:88) at cfindex2ecfm1129068187._factor10(D:/inetpub/wwwroot/icr/www/pub/index.cfm:11) at cfindex2ecfm1129068187.runPage(D:/inetpub/wwwroot/icr/www/pub/index.cfm:1) at cfnewsInnerSide2ecfm1598964670.runPage(D:/inetpub/wwwroot/icr/www/priv/inc/newsInnerSide.cfm:65) at cfnews2ecfm1849148043.runPage(D:/inetpub/wwwroot/icr/www/priv/views/news.cfm:89) at cfindex2ecfm1129068187._factor9(D:/inetpub/wwwroot/icr/www/pub/index.cfm:88) at cfindex2ecfm1129068187._factor10(D:/inetpub/wwwroot/icr/www/pub/index.cfm:11) at cfindex2ecfm1129068187.runPage(D:/inetpub/wwwroot/icr/www/pub/index.cfm:1)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'newsDate'.
	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.ddr.c(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.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at com.intergral.fusionreactor.jdbc.jdbc42.StatementSurrogate2.execute(StatementSurrogate2.java:49)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	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:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfnewsInnerSide2ecfm1598964670.runPage(D:\inetpub\wwwroot\icr\www\priv\inc\newsInnerSide.cfm:65)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfnews2ecfm1849148043.runPage(D:\inetpub\wwwroot\icr\www\priv\views\news.cfm:89)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfindex2ecfm1129068187._factor9(D:\inetpub\wwwroot\icr\www\pub\index.cfm:88)
	at cfindex2ecfm1129068187._factor10(D:\inetpub\wwwroot\icr\www\pub\index.cfm:11)
	at cfindex2ecfm1129068187.runPage(D:\inetpub\wwwroot\icr\www\pub\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:430)
	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: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 sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79)
	at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	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:748)