Publications

Browse Titles
 

Books and Reports from Carnegie

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]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
 
The error occurred in D:/Sites/20121206_carnegieEndowment/extensions/components/cms/PublicationDataProvider.cfc: line 2185
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 71
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 66
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 12
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 1
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 357
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 330
Called from D: line -1
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 315
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 1
Called from D:/Sites/20121206_carnegieEndowment/webpages/do.cfm: line 34
Called from D:/Sites/20121206_carnegieEndowment/extensions/components/cms/PublicationDataProvider.cfc: line 2185
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 71
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 66
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 12
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm: line 1
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 357
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 330
Called from D: line -1
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 315
Called from D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm: line 1
Called from D:/Sites/20121206_carnegieEndowment/webpages/do.cfm: line 34
2183 : 			<!--- EGM 04/25/2013: To understand the below CTE see: https://wiki.matrixgroup.net/index.php/T-Sql_Tips#Simple_Graph_traversal_using_the_amazing_WITH_clause_.28Common_Table_Expressions.29
2184 : 			--->
2185 : 			<cfquery name="getEnglishId" datasource="#variables.instance.DSN#">
2186 : 				DECLARE @articleId int				
2187 : 	

VENDORERRORCODE   319
SQLSTATE   HY000
SQL    DECLARE @articleId int SET @articleId = 1 WITH graphTraversal (contentId, fromId, hops) AS( SELECT DISTINCT (CASE WHEN content_id <> @articleId THEN CONVERT(int,content_id) ELSE CONVERT(int,content_utf_id) END ) as id, (CASE WHEN content_id <> @articleId THEN CONVERT(int,content_utf_id) ELSE CONVERT(int,content_id) END) as fromId, 1 as hops FROM admin_content_translations WHERE content_id = @articleId OR content_utf_id = @articleId UNION ALL SELECT (CASE WHEN tpp.content_id <> tx.contentId THEN CONVERT(int,content_id) ELSE CONVERT(int,content_utf_id) END ) as id, (CASE WHEN content_id <> tx.contentId THEN CONVERT(int,content_utf_id) ELSE CONVERT(int,content_id) END) as fromId, tx.hops + 1 AS hops FROM admin_content_translations AS tpp INNER JOIN graphTraversal AS tx ON (tpp.content_utf_id = tx.contentId AND tx.fromId <> tpp.content_id ) OR (tpp.content_id = tx.contentId AND tx.fromId <> tpp.content_utf_id ) ) SELECT DISTINCT contentId AS ID FROM graphTraversal WHERE contentid <> @articleId
DATASOURCE   carnegie_rw
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.81.123.216
Referrer  
Date/Time   23-Oct-14 03:10 PM
Stack Trace
at cfPublicationDataProvider2ecfc1435037660$funcGETALLTRANSLATIONS.runFunction(D:/Sites/20121206_carnegieEndowment/extensions/components/cms/PublicationDataProvider.cfc:2185) at cfdis_publicationsHome2ecfm1986289635._factor1(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:71) at cfdis_publicationsHome2ecfm1986289635._factor11(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:66) at cfdis_publicationsHome2ecfm1986289635._factor16(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:12) at cfdis_publicationsHome2ecfm1986289635.runPage(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:1) at cfindex2ecfm1491774721._factor53(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:357) at cfindex2ecfm1491774721._factor55(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:330) at cfindex2ecfm1491774721._factor6(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm) at cfindex2ecfm1491774721._factor56(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:315) at cfindex2ecfm1491774721.runPage(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:1) at cfdo2ecfm1546306028.runPage(D:/Sites/20121206_carnegieEndowment/webpages/do.cfm:34) at cfPublicationDataProvider2ecfc1435037660$funcGETALLTRANSLATIONS.runFunction(D:/Sites/20121206_carnegieEndowment/extensions/components/cms/PublicationDataProvider.cfc:2185) at cfdis_publicationsHome2ecfm1986289635._factor1(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:71) at cfdis_publicationsHome2ecfm1986289635._factor11(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:66) at cfdis_publicationsHome2ecfm1986289635._factor16(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:12) at cfdis_publicationsHome2ecfm1986289635.runPage(D:/Sites/20121206_carnegieEndowment/webpages/publications/dis_publicationsHome.cfm:1) at cfindex2ecfm1491774721._factor53(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:357) at cfindex2ecfm1491774721._factor55(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:330) at cfindex2ecfm1491774721._factor6(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm) at cfindex2ecfm1491774721._factor56(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:315) at cfindex2ecfm1491774721.runPage(D:/Sites/20121206_carnegieEndowment/webpages/publications/index.cfm:1) at cfdo2ecfm1546306028.runPage(D:/Sites/20121206_carnegieEndowment/webpages/do.cfm:34)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
	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:1364)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
	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 cfPublicationDataProvider2ecfc1435037660$funcGETALLTRANSLATIONS.runFunction(D:\Sites\20121206_carnegieEndowment\extensions\components\cms\PublicationDataProvider.cfc:2185)
	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.CfJspPage._invoke(CfJspPage.java:2360)
	at cfdis_publicationsHome2ecfm1986289635._factor1(D:\Sites\20121206_carnegieEndowment\webpages\publications\dis_publicationsHome.cfm:71)
	at cfdis_publicationsHome2ecfm1986289635._factor11(D:\Sites\20121206_carnegieEndowment\webpages\publications\dis_publicationsHome.cfm:66)
	at cfdis_publicationsHome2ecfm1986289635._factor16(D:\Sites\20121206_carnegieEndowment\webpages\publications\dis_publicationsHome.cfm:12)
	at cfdis_publicationsHome2ecfm1986289635.runPage(D:\Sites\20121206_carnegieEndowment\webpages\publications\dis_publicationsHome.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfindex2ecfm1491774721._factor53(D:\Sites\20121206_carnegieEndowment\webpages\publications\index.cfm:357)
	at cfindex2ecfm1491774721._factor55(D:\Sites\20121206_carnegieEndowment\webpages\publications\index.cfm:330)
	at cfindex2ecfm1491774721._factor6(D:\Sites\20121206_carnegieEndowment\webpages\publications\index.cfm)
	at cfindex2ecfm1491774721._factor56(D:\Sites\20121206_carnegieEndowment\webpages\publications\index.cfm:315)
	at cfindex2ecfm1491774721.runPage(D:\Sites\20121206_carnegieEndowment\webpages\publications\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfdo2ecfm1546306028.runPage(D:\Sites\20121206_carnegieEndowment\webpages\do.cfm:34)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:378)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	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 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$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)