OOPS!!! We are so sorry, something here went wrong.

We are working on it right now. Please report it to customer care for quick resolution.



An error occurred: http://floraindia.net/floraindianew/category.cfm?r1=0&r2=500&noCat=1&CFID=13441523&CFTOKEN=98397271
Time: 6/24/17 7:12 PM

ERROR DUMP:

Error - struct
Browser CCBot/2.0 (http://commoncrawl.org/faq/)
DateTime {ts '2017-06-24 19:12:01'}
Diagnostics Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'. <br>The error occurred on line 46.
GeneratedContent [empty string]
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString r1=0&r2=500&noCat=1&CFID=13441523&CFTOKEN=98397271
RemoteAddress 23.20.130.128
RootCause
Error - struct
Cause
Error - struct
ErrorCode 229
Message [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'.
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46) at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:374) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) 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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 130
RAW_TRACE at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130)
TEMPLATE C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource testfloradsn1
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'.
ErrorCode 42000
Message Error Executing Database Query.
NativeErrorCode 229
RootCause
Error - struct
ErrorCode 229
Message [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'.
SQLState 42000
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46) at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:374) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) 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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 130
RAW_TRACE at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130)
TEMPLATE C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42000
Sql SELECT Name FROM subCategory WHERE category = 'Flowers'
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46) at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:374) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) 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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 46 more
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 130
RAW_TRACE at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130)
TEMPLATE C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'.
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46) at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:374) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) 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:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) 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$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT permission was denied on the object 'SubCategory', database 'testflora', schema 'dbo'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 46 more
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 46
RAW_TRACE at cfcategory2ecfm724357504._factor3(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:46)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CF_CATEGORY
LINE 1
RAW_TRACE at cfcategory2ecfm724357504.runPage(C:\home\floraindia.net\wwwroot\floraindianew\category.cfm:1)
TEMPLATE C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
TYPE CFML
3
Error - struct
COLUMN 0
ID CFINCLUDE
LINE 130
RAW_TRACE at cfApplication2ecfc91019168$funcONREQUEST.runFunction(C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc:130)
TEMPLATE C:\home\floraindia.net\wwwroot\floraIndiaNew\Application.cfc
TYPE CFML
Template /floraindianew/category.cfm
Type coldfusion.runtime.CfErrorWrapper

CGI DUMP:

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 C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
CONTENT_LENGTH [empty string]
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 x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE [empty string]
HTTP_CONNECTION [empty string]
HTTP_COOKIE [empty string]
HTTP_HOST floraindia.net
HTTP_REFERER [empty string]
HTTP_USER_AGENT CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO /floraindianew/category.cfm
PATH_TRANSLATED C:\home\floraindia.net\wwwroot\floraindianew\category.cfm
QUERY_STRING r1=0&r2=500&noCat=1&CFID=13441523&CFTOKEN=98397271
REMOTE_ADDR 23.20.130.128
REMOTE_HOST 23.20.130.128
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /floraindianew/category.cfm
SERVER_NAME floraindia.net
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.0
SERVER_SOFTWARE Microsoft-IIS/7.5
WEB_SERVER_API [empty string]

FORM DUMP:

Form - struct [empty]

URL DUMP:

URL - struct
CFID 13441523
CFTOKEN 98397271
noCat 1
r1 0
r2 500

SESSION DUMP:

URL - struct
sessionid 8430f3b3a0b7e90def646936262c313285e7
urltoken CFID=13441523&CFTOKEN=98397271&jsessionid=8430f3b3a0b7e90def646936262c313285e7