struct
DataSource www_leasingandcontracthire_com_2
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'pub_lights.dbo.getCAPimage'.
ErrorCode 42S02
Message Error Executing Database Query.
NativeErrorCode 208
RootCause
struct
ErrorCode 208
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'pub_lights.dbo.getCAPimage'.
SQLState 42S02
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'pub_lights.dbo.getCAPimage'. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source) at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source) at macromedia.jdbc.base.BaseStatement.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212) at coldfusion.sql.Executive.executeQuery(Executive.java:775) at coldfusion.sql.Executive.executeQuery(Executive.java:685) at coldfusion.sql.Executive.executeQuery(Executive.java:646) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:695) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:496) at cfCAP2ecfc315423533$funcGETCARDATA._factor2(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:777) at cfCAP2ecfc315423533$funcGETCARDATA._factor9(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:761) at cfCAP2ecfc315423533$funcGETCARDATA.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:666) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfvehicles2ecfc1574524756$funcGETVEHICLES.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\lch\vehicles.cfc:409) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfdeals2ecfc1625302316$funcGETDEALS.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\nld\deals.cfc:333) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916) at cfspecial2dleasing2doffers2ecfm968702468.runPage(W:\WebRoot\CMS\_site_data\newcarleasingcompany.com\site\special-leasing-offers.cfm:32) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:234) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:180) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:215) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 777
RAW_TRACE at cfCAP2ecfc315423533$funcGETCARDATA._factor2(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:777)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_CAP
LINE 761
RAW_TRACE at cfCAP2ecfc315423533$funcGETCARDATA._factor9(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:761)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_CAP
LINE 666
RAW_TRACE at cfCAP2ecfc315423533$funcGETCARDATA.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:666)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 409
RAW_TRACE at cfvehicles2ecfc1574524756$funcGETVEHICLES.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\lch\vehicles.cfc:409)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\lch\vehicles.cfc
TYPE CFML
5
struct
COLUMN 0
ID CFINVOKE
LINE 333
RAW_TRACE at cfdeals2ecfc1625302316$funcGETDEALS.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\nld\deals.cfc:333)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\nld\deals.cfc
TYPE CFML
6
struct
COLUMN 0
ID CFINVOKE
LINE 32
RAW_TRACE at cfspecial2dleasing2doffers2ecfm968702468.runPage(W:\WebRoot\CMS\_site_data\newcarleasingcompany.com\site\special-leasing-offers.cfm:32)
TEMPLATE W:\WebRoot\CMS\_site_data\newcarleasingcompany.com\site\special-leasing-offers.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 234
RAW_TRACE at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:234)
TEMPLATE W:\WebRoot\CMS\Application_normal.cfc
TYPE CFML
Type java.sql.SQLException
SQLState 42S02
Sql /* Based on derivitive ID - best */ select top 1 vehicledata.cder_capcode, cder_id, cder_name, cmod_code, cmod_name, cran_code, cran_name, cman_name, cman_code, cmod_bodystyle, bs_description, cdt_description, cfd_description, cft_description, ct_description, cder_doors, cvs_description, cvs_id, pub_lights.dbo.getCAPimage.ima_imageid FROM vehicledata LEFT OUTER JOIN pub_lights.dbo.getCAPimage ON abs(vehicledata.cder_ID) = pub_lights.dbo.getCAPimage.id WHERE (vehicledata.cder_id = -15181) and commercial = 1 ORDER BY ima_imageid DESC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfCAP2ecfc315423533$funcGETCARDATA._factor2(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:777) at cfCAP2ecfc315423533$funcGETCARDATA._factor9(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:761) at cfCAP2ecfc315423533$funcGETCARDATA.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:666) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfvehicles2ecfc1574524756$funcGETVEHICLES.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\lch\vehicles.cfc:409) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at cfdeals2ecfc1625302316$funcGETDEALS.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\nld\deals.cfc:333) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916) at cfspecial2dleasing2doffers2ecfm968702468.runPage(W:\WebRoot\CMS\_site_data\newcarleasingcompany.com\site\special-leasing-offers.cfm:32) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:234) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:180) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:215) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown Source) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 777
RAW_TRACE at cfCAP2ecfc315423533$funcGETCARDATA._factor2(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:777)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_CAP
LINE 761
RAW_TRACE at cfCAP2ecfc315423533$funcGETCARDATA._factor9(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:761)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_CAP
LINE 666
RAW_TRACE at cfCAP2ecfc315423533$funcGETCARDATA.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc:666)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\CAP.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 409
RAW_TRACE at cfvehicles2ecfc1574524756$funcGETVEHICLES.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\lch\vehicles.cfc:409)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\lch\vehicles.cfc
TYPE CFML
5
struct
COLUMN 0
ID CFINVOKE
LINE 333
RAW_TRACE at cfdeals2ecfc1625302316$funcGETDEALS.runFunction(W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\nld\deals.cfc:333)
TEMPLATE W:\WebRoot\CMS\contentmanagement\customtags\cfc\cars\nld\deals.cfc
TYPE CFML
6
struct
COLUMN 0
ID CFINVOKE
LINE 32
RAW_TRACE at cfspecial2dleasing2doffers2ecfm968702468.runPage(W:\WebRoot\CMS\_site_data\newcarleasingcompany.com\site\special-leasing-offers.cfm:32)
TEMPLATE W:\WebRoot\CMS\_site_data\newcarleasingcompany.com\site\special-leasing-offers.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 234
RAW_TRACE at cfApplication_normal2ecfc1504055348$funcONREQUEST.runFunction(W:\WebRoot\CMS\Application_normal.cfc:234)
TEMPLATE W:\WebRoot\CMS\Application_normal.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'pub_lights.dbo.getCAPimage'.
where [empty string]