Office Apart. Retail
Albuquerque 17.1% 3.8% 13.4%
Denver 17.6% 5.4% 9.3%
San Francisco 9.8% 4.5% 3.0%
Q3 2017 Data


Debugging Information
ColdFusion Server Enterprise 11,0,05,293506
Template /index.cfm
Time Stamp 13-Dec-17 10:58 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.90.92.204
Host Name 54.90.92.204


Exceptions

22:58:59.059 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
22:58:59.059 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
22:58:59.059 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element widgetHead is undefined in a CFML structure referenced as part of an expression.
	    


SQL Queries

getSessionID (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 22:58:59.059
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
passwordData (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/reisReportsUser/ReisReportsUser.cfc @ 22:58:59.059
		SELECT REGEXPATTERN,REGEXDESCRIPTION
		FROM PASSWORDREGEXPATTERN
		WHERE PASSWORDREGEXPATTERN_ID = 21
		
getSessionID (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 22:58:59.059
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/wwwroot/Application.cfc @ 22:58:59.059
			INSERT INTO customerRequestLog(
				SESSIONID,
				REQUESTTIME,
				TEMPLATE,
				URL,
				FORM
			)
			VALUES(
				?,
				?,
				?,
				?,
				?
			)
			
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 92E9500DEEFCC5EF418E8A969E81D72E.axis1
Parameter #2(cf_sql_timestamp) = 2017-12-13 22:58:59.576
Parameter #3(cf_sql_varchar) = /index.cfm
Parameter #4(cf_sql_varchar) = {"utm_campaign":"vacancyRates","event":"widget.vacancyRates.data","utm_medium":"widget","msa":"aq,sf,de"}
Parameter #5(cf_sql_varchar) = {}

vacancyRatesData (Datasource=pMonthly, Time=31ms, Records=9) in /websiteReisReports/modelglueapp/controller/reisreports/widgets.cfc @ 22:58:59.059


		SELECT
			THESQUARE.MSA,
			TRIM(THESQUARE.NAME) NAME,
			REPORTIDSUFFIX,
			THESQUARE.SECTOR,
			THEDATA.vacpercent AS PERCENTAGE
		FROM
			(
			 SELECT
				MSA,
				NAME,
				SECTOR,
				REPORTIDSUFFIX
			FROM
				(
				SELECT MSA,NAME
				FROM MSA
				WHERE MSA IN (?,?,?)
				)
				CROSS JOIN
				(
				SELECT SECTOR,REPORTIDSUFFIX
				FROM SECTOR
				WHERE
					SECTOR IN ('Apt','Off','Ret')
				)
			) THESQUARE
			LEFT JOIN
			(

				select
			         mt.sector,
			         mt.metrocode,
			         mt.vacpercent,
			         mt.subsector
			    from
			         markettrends mt
			         inner join quarterinfo q on
			              q.year = mt.year and
			              q.quarter = mt.quarter and
			              mt.totalmonths is null
			    where
			    	mt.subsector in ( 'ABC', 'NC' )
			    	AND
			    	sc = 0

			) THEDATA
			ON
			(
				THESQUARE.MSA = THEDATA.METROCODE
				AND
				THESQUARE.SECTOR = THEDATA.SECTOR
			)
		ORDER BY NAME,REPORTIDSUFFIX
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AQ
Parameter #2(cf_sql_varchar) = SF
Parameter #3(cf_sql_varchar) = DE

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = NM

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = NM

qStateName (Datasource=, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = NM

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = NM

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CO

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CO

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CO

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CO

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CA

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CA

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CA

qStateName (Datasource=, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/cache/CacheService.cfc @ 22:58:59.059
		SELECT statename
		FROM US_STATES
		WHERE stateAbbrev = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = CA


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/websiteReisReports/wwwroot/reisreports2/index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
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=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.reisreports.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/websiteReisReports/wwwroot/reisreports2/index.cfm
QUERY_STRING=event=widget.vacancyRates.data&msa=aq,sf,de&utm_campaign=vacancyRates&utm_medium=widget
REMOTE_ADDR=54.90.92.204
REMOTE_HOST=54.90.92.204
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.reisreports.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_jk/1.2.40
WEB_SERVER_API=
Cookie Variables:
CLIENTID=3FB77213-981C-14B9-5B5540C3B0AB786D
Session Variables:
getpropertyreport=Complex type
getuser=Complex type
haspropertyreport=Complex type
propertyreport=
sessionid=92E9500DEEFCC5EF418E8A969E81D72E.axis1
setpropertyreport=Complex type
setuser=Complex type
urltoken=CFID=1275069&CFTOKEN=e0ed86a13d56f488-3FB771A4-FC29-CDD2-6896373220D8B333&jsessionid=92E9500DEEFCC5EF418E8A969E81D72E.axis1
user=Struct (99)
URL Parameters:
event=widget.vacancyRates.data
msa=aq,sf,de
utm_campaign=vacancyRates
utm_medium=widget
Debug Rendering Time: 4 ms