Vacancy Trends


Debugging Information
ColdFusion Server Enterprise 11,0,05,293506
Template /index.cfm
Time Stamp 14-Dec-17 08:16 AM
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

08:16:48.048 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
08:16:48.048 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
08:16:48.048 - 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=3ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 08:16:48.048
		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 @ 08:16:48.048
		SELECT REGEXPATTERN,REGEXDESCRIPTION
		FROM PASSWORDREGEXPATTERN
		WHERE PASSWORDREGEXPATTERN_ID = 21
		
getSessionID (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 08:16:48.048
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/wwwroot/Application.cfc @ 08:16:48.048
			INSERT INTO customerRequestLog(
				SESSIONID,
				REQUESTTIME,
				TEMPLATE,
				URL,
				FORM
			)
			VALUES(
				?,
				?,
				?,
				?,
				?
			)
			
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = A9ECF870916A6222B7663673114654AD.axis1
Parameter #2(cf_sql_timestamp) = 2017-12-14 08:16:48.672
Parameter #3(cf_sql_varchar) = /index.cfm
Parameter #4(cf_sql_varchar) = {"sector":"Ret","event":"widget.nationalTrends.data","utm_campaign":"nationalTrends","utm_source":"","utm_medium":"widget"}
Parameter #5(cf_sql_varchar) = {}

sectors (Datasource=pQuarterlyMinus, Time=0ms, Records=7, Cached Query) in /websiteReisReports/modelglueapp/controller/reisreports/reisreports.cfc @ 08:16:48.048
			SELECT *
			FROM SECTOR
			WHERE
				SECTOR <> 'Ind'
				AND
				SECTOR <> 'Hot'
				AND
				SECTOR <> 'Gen'
				AND
				SECTOR <> 'All'
				AND
				SECTOR <> 'Snr'
				AND
				SECTOR <> 'Sth'
				AND
				SECTOR <> 'Aff'
				AND
				SECTOR <> 'Spc'
			ORDER BY SORTORDER	
		


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.nationalTrends.data&sector=Ret&utm_source=&utm_medium=widget&utm_campaign=nationalTrends
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=53AA1E52-FA77-0FC0-D925CDCF0E50FC96
Session Variables:
getpropertyreport=Complex type
getuser=Complex type
haspropertyreport=Complex type
propertyreport=
sessionid=A9ECF870916A6222B7663673114654AD.axis1
setpropertyreport=Complex type
setuser=Complex type
urltoken=CFID=1275355&CFTOKEN=6093c09b6df4f805-53AA1DE7-036F-47BB-94727A71882096E1&jsessionid=A9ECF870916A6222B7663673114654AD.axis1
user=Struct (99)
URL Parameters:
event=widget.nationalTrends.data
sector=Ret
utm_campaign=nationalTrends
utm_medium=widget
utm_source=
Debug Rendering Time: 3 ms