Mach-II Exception

Message

Error Executing Database Query.

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near ')'.

Extended Info

Tag Context

C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc (48)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc (63)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc (66)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc (56)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc (310)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc (273)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc (240)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc (92)

C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc (57)

C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc (103)

C:\Inetpub\wwwroot\globalreach\GR\Application.cfc (177)

Caught Exception

struct
DataSource globalreach
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near ')'.
ErrorCode HY000
Message Error Executing Database Query.
NativeErrorCode 170
RootCause
struct
ErrorCode 170
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near ')'. 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:753) at coldfusion.sql.Executive.executeQuery(Executive.java:675) at coldfusion.sql.Executive.executeQuery(Executive.java:636) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) at cfGRListener2ecfc908455328$funcGETLESSONS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc:48) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) 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:345) at cfEventInvoker2ecfc1136492400$funcINVOKELISTENER.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc:63) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfNotifyCommand2ecfc216767686$funcEXECUTE.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc:66) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfEventHandler2ecfc1678564503$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc:56) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfEventContext2ecfc1001181007$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:310) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfEventContext2ecfc1001181007$funcHANDLENEXTEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:273) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfEventContext2ecfc1001181007$funcPROCESSEVENTS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:240) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfRequestHandler2ecfc256514122$funcHANDLEEVENTREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:92) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfRequestHandler2ecfc256514122$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:57) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfmach2dii2ecfc68164252$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc:103) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfApplication2ecfc1368868918$funcONREQUESTSTART.runFunction(C:\Inetpub\wwwroot\globalreach\GR\Application.cfc:177) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:72) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:160) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210) 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.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.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 48
RAW_TRACE at cfGRListener2ecfc908455328$funcGETLESSONS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc:48)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc
TYPE CFML
2
struct
COLUMN 0
ID CFINVOKE
LINE 63
RAW_TRACE at cfEventInvoker2ecfc1136492400$funcINVOKELISTENER.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc:63)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 66
RAW_TRACE at cfNotifyCommand2ecfc216767686$funcEXECUTE.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc:66)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 56
RAW_TRACE at cfEventHandler2ecfc1678564503$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc:56)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 310
RAW_TRACE at cfEventContext2ecfc1001181007$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:310)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 273
RAW_TRACE at cfEventContext2ecfc1001181007$funcHANDLENEXTEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:273)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 240
RAW_TRACE at cfEventContext2ecfc1001181007$funcPROCESSEVENTS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:240)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 92
RAW_TRACE at cfRequestHandler2ecfc256514122$funcHANDLEEVENTREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:92)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc
TYPE CFML
9
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 57
RAW_TRACE at cfRequestHandler2ecfc256514122$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:57)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 103
RAW_TRACE at cfmach2dii2ecfc68164252$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc:103)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 177
RAW_TRACE at cfApplication2ecfc1368868918$funcONREQUESTSTART.runFunction(C:\Inetpub\wwwroot\globalreach\GR\Application.cfc:177)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\Application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT L.LessonID, L.CourseID, LL.Title, LL.Description, RL.Title AS RefTitle, RL.ResourceFileName, RL.ResourceURL, RL.ResourceTypeID, C.CategoryID as Category, RT.SmImage FROM Lesson L INNER JOIN MTMLessonLanguage LL ON L.LessonID = LL.LessonID LEFT OUTER JOIN MTMResourceLanguage RL ON RL.LessonID = LL.LessonID AND RL.LanguageID = 1 AND RL.Status = 'ACTI' INNER JOIN Course C ON L.CourseID = C.CourseID INNER JOIN ResourceType RT ON RT.ResourceTypeID = RL.ResourceTypeID WHERE (LL.LanguageID = 1) AND (L.CourseID = ) AND (LL.Status = 'ACTI') ORDER BY L.DisplayOrder, RL.SortOrder
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfGRListener2ecfc908455328$funcGETLESSONS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc:48) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) 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:345) at cfEventInvoker2ecfc1136492400$funcINVOKELISTENER.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc:63) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfNotifyCommand2ecfc216767686$funcEXECUTE.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc:66) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfEventHandler2ecfc1678564503$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc:56) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfEventContext2ecfc1001181007$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:310) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfEventContext2ecfc1001181007$funcHANDLENEXTEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:273) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfEventContext2ecfc1001181007$funcPROCESSEVENTS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:240) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfRequestHandler2ecfc256514122$funcHANDLEEVENTREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:92) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfRequestHandler2ecfc256514122$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:57) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfmach2dii2ecfc68164252$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc:103) 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:169) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807) at cfApplication2ecfc1368868918$funcONREQUESTSTART.runFunction(C:\Inetpub\wwwroot\globalreach\GR\Application.cfc:177) 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:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:72) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:160) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210) 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.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.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 48
RAW_TRACE at cfGRListener2ecfc908455328$funcGETLESSONS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc:48)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\model\GRListener.cfc
TYPE CFML
2
struct
COLUMN 0
ID CFINVOKE
LINE 63
RAW_TRACE at cfEventInvoker2ecfc1136492400$funcINVOKELISTENER.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc:63)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 66
RAW_TRACE at cfNotifyCommand2ecfc216767686$funcEXECUTE.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc:66)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 56
RAW_TRACE at cfEventHandler2ecfc1678564503$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc:56)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventHandler.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 310
RAW_TRACE at cfEventContext2ecfc1001181007$funcHANDLEEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:310)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 273
RAW_TRACE at cfEventContext2ecfc1001181007$funcHANDLENEXTEVENT.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:273)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 240
RAW_TRACE at cfEventContext2ecfc1001181007$funcPROCESSEVENTS.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc:240)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 92
RAW_TRACE at cfRequestHandler2ecfc256514122$funcHANDLEEVENTREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:92)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc
TYPE CFML
9
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 57
RAW_TRACE at cfRequestHandler2ecfc256514122$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc:57)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\framework\RequestHandler.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 103
RAW_TRACE at cfmach2dii2ecfc68164252$funcHANDLEREQUEST.runFunction(C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc:103)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\MachII\mach-ii.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 177
RAW_TRACE at cfApplication2ecfc1368868918$funcONREQUESTSTART.runFunction(C:\Inetpub\wwwroot\globalreach\GR\Application.cfc:177)
TEMPLATE C:\Inetpub\wwwroot\globalreach\GR\Application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near ')'.
where [empty string]