Peterson Institute publications
The Peterson Institute for International Economics is a private, nonprofit, nonpartisan
research institution devoted to the study of international economic policy. More › ›
RSS News Feed Search

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]SHUTDOWN is in progress.
 
The error occurred in C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm: line 159
Called from C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm: line 13
Called from C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm: line 1
Called from C:/inetpub/petersoninstitute/column_nav2.cfm: line 9
Called from C:/inetpub/petersoninstitute/header_new.cfm: line 402
Called from C:/inetpub/petersoninstitute/publications/papers/paper.cfm: line 44
Called from C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm: line 159
Called from C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm: line 13
Called from C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm: line 1
Called from C:/inetpub/petersoninstitute/column_nav2.cfm: line 9
Called from C:/inetpub/petersoninstitute/header_new.cfm: line 402
Called from C:/inetpub/petersoninstitute/publications/papers/paper.cfm: line 44
157 : 			<cfelseif form.filter_sort eq "3">
158 : 				ORDER BY ResearchTitle, ResearchDate DESC, PubNumber_Last DESC, PubNumber
159 : 			<cfelse>
160 : 				ORDER BY ResearchDate DESC, type, PubNumber_Last DESC, PubNumber, ResearchTitle
161 : 			</cfif>

VENDORERRORCODE   6005
SQLSTATE   HY000
SQL    SELECT * FROM ( SELECT DISTINCT TOP 5 CAST(re.researchID AS VARCHAR) AS researchid, 'research' AS type, '0' AS AudioVideo, re.ResearchTitle, re.Filename, re.ResearchMonth, re.ResearchDay, re.ResearchYear, pe.First_Name, pe.Last_Name, re.PubNumber, CAST(re.Comment AS varchar(8000)) AS Comment, re.ResearchDate, re.ResearchDate2, re.RevisedDate, re.RevisedMonth, re.RevisedDay, re.RevisedYear, re.ResearchMonth2, re.ResearchDay2, re.ResearchYear2, re.ResearchTypeID, rtl.ResearchType, CASE WHEN re.HTMLContent IS NULL AND re.Filename IS NULL THEN 'Neither' WHEN SUBSTRING(re.Filename, Len(re.Filename) - 2, 3) = 'pdf' THEN 'PDF' WHEN re.HTMLContent IS NOT NULL THEN 'HTM' END AS DisplayType, re.PubNumber_Last, COALESCE(nte.dateorder, re.datecreated, re.researchdate) AS datecreated, CAST(emailabstract AS varchar(8000)) AS emailabstract, re.datecreated AS dateorder FROM research re LEFT OUTER JOIN NewTabEssentials nte ON (nte.ReadingType NOT IN ('Book', 'Book Chapter', 'RealTime Economic Issues Watch','North Korea: Witness to Transformation','China Economic Watch', 'Event', 'News Release') AND re.ResearchID = nte.ReadingID) INNER JOIN ResearchTypesLookup rtl ON re.ResearchTypeID=rtl.ResearchTypeID LEFT OUTER JOIN researchauthors ra ON re.researchid=ra.researchid LEFT OUTER JOIN people pe ON ra.peopleid = pe.id WHERE ra.AuthorRank=1 ORDER BY DateCreated DESC ) AS derivedResearch UNION SELECT * FROM ( SELECT DISTINCT TOP 5 CAST(e.eventID AS VARCHAR) AS researchid, 'event' AS type, DATALENGTH(ISNULL(ev.AudioVideo,'')) AS AudioVideo, e.eventTitle, e.Filename, e.eventMonth, e.eventDay, e.eventYear, pe.First_Name, pe.Last_Name, NULL AS PubNumber, CAST(e.Comment AS varchar(8000)) AS Comment, e.EventDate AS ResearchDate, e.eventDate AS ResearchDate2, NULL AS RevisedDate, NULL AS RevisedMonth, NULL AS RevisedDay, NULL AS RevisedYear, e.eventMonth2 AS ResearchMonth2, e.eventDay2 AS ResearchDay2, e.eventYear2 AS ResearchYear2, e.eventTypeID AS ResearchTypeID, etl.eventType AS ResearchType, NULL AS DisplayType, NULL AS PubNumber_Last, COALESCE(nte.dateorder, e.datecreated) AS datecreated, CAST(emailabstract AS varchar(8000)) AS emailabstract, e.datecreated AS DateOrder FROM events e LEFT OUTER JOIN eventtypeslookup etl ON e.eventtypeid = etl.eventtypeid LEFT OUTER JOIN eventauthors ea ON e.eventid = ea.eventid AND (ea.authorrank IS NULL OR ea.authorrank=1) LEFT OUTER JOIN people pe ON ea.peopleid = pe.id LEFT OUTER JOIN eventaudiovideo ev ON e.eventid = ev.eventid LEFT OUTER JOIN NewTabEssentials nte ON (nte.readingtype = 'event' AND nte.readingid = e.eventid) ORDER BY DateCreated DESC ) AS derivedEvents UNION SELECT * FROM ( SELECT TOP 5 CAST(ID AS VARCHAR) AS researchid, 'news release' AS type, 0 AS AudioVideo, headline AS ResearchTitle, mainreleasepdf AS Filename, 0 AS ResearchMonth, 0 AS ResearchDay, 0 AS ResearchYear, '' AS First_Name, '' AS Last_Name, NULL AS PubNumber, CAST(body AS varchar(8000)) AS comment, releasedate AS ResearchDate, releasedate AS ResearchDate2, NULL AS RevisedDate, NULL AS RevisedMonth, NULL AS RevisedDay, NULL AS RevisedYear, 0 AS ResearchMonth2, 0 AS ResearchDay2, 0 AS ResearchYear2, newsreleasetypeid AS ResearchTypeID, 'news release' AS ResearchType, NULL AS DisplayType, NULL AS PubNumber_Last, COALESCE(nte.dateorder, n.datecreated) AS datecreated, NULL AS emailabstract, n.datecreated AS DateOrder FROM NewsReleases n LEFT OUTER JOIN NewTabEssentials nte on (nte.readingtype = 'news release' AND nte.readingid = n.id) WHERE ReleaseDate <= '23-Oct-14 12:00:00 AM' ORDER BY DateCreated DESC ) AS derivedReleases UNION SELECT * FROM ( SELECT DISTINCT TOP 5 CAST(ps.pubprodcode AS VARCHAR) AS researchid, 'book' AS type, '0' AS AudioVideo, Title AS ResearchTitle, NULL AS Filename, 0 AS ResearchMonth, 0 AS ResearchDay, 0 AS ResearchYear, ISNULL((SELECT TOP 1 first_name FROM people (NOLOCK) WHERE first_name+' '+last_name = pa.author OR (id = 455 AND CHARINDEX('Anders',pa.author) <> 0 AND CHARINDEX('slund',pa.author) <> 0)),'ZZZZZ') AS 'first_name', ISNULL((SELECT TOP 1 last_name FROM people (NOLOCK) WHERE first_name+' '+last_name = pa.author OR (id = 455 AND CHARINDEX('Anders',pa.author) <> 0 AND CHARINDEX('slund',pa.author) <> 0)),'ZZZZZ') AS 'last_name', authorstext AS PubNumber, NULL AS Comment, pubdate AS ResearchDate, pubdate AS ResearchDate2, pubdate AS RevisedDate, month(pubdate) AS RevisedMonth, 1 AS RevisedDay, year(pubdate) AS RevisedYear, 0 AS ResearchMonth2, 0 AS ResearchDay2, 0 AS ResearchYear2, 0 AS ResearchTypeID, 'book' AS ResearchType, NULL AS DisplayType, NULL AS PubNumber_Last, COALESCE(nte.dateorder, pubdate) AS datecreated, CASE WHEN patindex('%<!--begin DESC-->%',prodpagecontent) <> 0 AND patindex('%<!--end DESC-->%',prodpagecontent) <> 0 THEN substring(prodpagecontent, patindex('%<!--begin DESC-->%',prodpagecontent)+17, patindex('%<!--end DESC-->%',prodpagecontent) - patindex('%<!--begin DESC-->%',prodpagecontent) - 17) else '' END AS emailabstract, pubdate AS DateOrder FROM pubsforsearchonly ps LEFT OUTER JOIN pubsforsearchonlyauthors pa on ps.pubprodcode = pa.researchid --, pubtopics pt LEFT OUTER JOIN NewTabEssentials nte on (nte.readingtype = 'book' AND nte.readingid = ps.pubprodcode) ORDER BY DateCreated DESC ) AS derivedBooks ORDER BY ResearchDate DESC, type, PubNumber_Last DESC, PubNumber, ResearchTitle
DATASOURCE   PetersonInstitute
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   173.242.152.25
Referrer  
Date/Time   23-Oct-14 02:45 AM
Stack Trace
at cfwhatsnew_box_test22ecfm1028172817._factor8(C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm:159) at cfwhatsnew_box_test22ecfm1028172817._factor11(C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm:13) at cfwhatsnew_box_test22ecfm1028172817.runPage(C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm:1) at cfcolumn_nav22ecfm612340449.runPage(C:/inetpub/petersoninstitute/column_nav2.cfm:9) at cfheader_new2ecfm1526908478.runPage(C:/inetpub/petersoninstitute/header_new.cfm:402) at cfpaper2ecfm452012530.runPage(C:/inetpub/petersoninstitute/publications/papers/paper.cfm:44) at cfwhatsnew_box_test22ecfm1028172817._factor8(C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm:159) at cfwhatsnew_box_test22ecfm1028172817._factor11(C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm:13) at cfwhatsnew_box_test22ecfm1028172817.runPage(C:/inetpub/petersoninstitute/whatsnew_box_test2.cfm:1) at cfcolumn_nav22ecfm612340449.runPage(C:/inetpub/petersoninstitute/column_nav2.cfm:9) at cfheader_new2ecfm1526908478.runPage(C:/inetpub/petersoninstitute/header_new.cfm:402) at cfpaper2ecfm452012530.runPage(C:/inetpub/petersoninstitute/publications/papers/paper.cfm:44)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]SHUTDOWN is in progress.
	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 cfwhatsnew_box_test22ecfm1028172817._factor8(C:\inetpub\petersoninstitute\whatsnew_box_test2.cfm:159)
	at cfwhatsnew_box_test22ecfm1028172817._factor11(C:\inetpub\petersoninstitute\whatsnew_box_test2.cfm:13)
	at cfwhatsnew_box_test22ecfm1028172817.runPage(C:\inetpub\petersoninstitute\whatsnew_box_test2.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 cfcolumn_nav22ecfm612340449.runPage(C:\inetpub\petersoninstitute\column_nav2.cfm:9)
	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 cfheader_new2ecfm1526908478.runPage(C:\inetpub\petersoninstitute\header_new.cfm:402)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfpaper2ecfm452012530.runPage(C:\inetpub\petersoninstitute\publications\papers\paper.cfm:44)
	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:399)
	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 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)