BR PRODUCTION NOT OK!

Debugging Information

ColdFusion Server Enterprise	8,0,1,195765
Template	/skedge/br_production_check.cfm
Time Stamp	12-Nov-10 05:00 AM
Locale	English (US)
User Agent	CFSCHEDULE
Remote IP	127.0.0.1
Host Name	127.0.0.1

Execution Time

Total Time	Avg Time	Count	Template
891 ms	891 ms	1	C:\Boston Reed\Umbrella\skedge\br_production_check.cfm
0 ms	0 ms	1	C:\Boston Reed\Umbrella\skedge\Application.cfm
281 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1172 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

05:00:02.002 - Application Exception - in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm : line 130

	    Invalid connection specified.

05:00:02.002 - Application Exception - in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm : line 131

	    Invalid connection specified.

SQL Queries

Exists (Datasource=db02, Time=281ms, Records=1) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

		SELECT 1 FROM task_log WHERE task_name = 'BR Books'
		AND task_date >= trunc(sysdate)

Exists (Datasource=db02, Time=32ms, Records=1) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

		SELECT 1 FROM task_log WHERE task_name = 'BR QuickBooks'
		AND task_date >= trunc(sysdate)

Exists (Datasource=db02, Time=15ms, Records=1) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

		SELECT 1 FROM task_log WHERE task_name = 'BR Referral Rewards'
		AND task_date >= trunc(sysdate)

Exists (Datasource=db02, Time=32ms, Records=1) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

		SELECT 1 FROM task_log WHERE task_name = 'CDI Attendance Totals'
		AND task_date >= trunc(sysdate)

Exists (Datasource=db02, Time=15ms, Records=1) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

		SELECT 1 FROM task_log WHERE task_name = 'CDI TOPS Notification'
		AND task_date >= trunc(sysdate)

Exists (Datasource=db02, Time=31ms, Records=0) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

		SELECT 1 FROM task_log WHERE task_name = 'File Cleanup'
		AND task_date >= trunc(sysdate)

Insert (Datasource=inventory, Time=219ms, Records=1) in C:\Boston Reed\Umbrella\skedge\br_production_check.cfm @ 05:00:01.001

	INSERT INTO br_prod_check VALUES (sysdate,'0')

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=C:\Boston Reed\Umbrella\skedge\br_production_check.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=OFF
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=deflate;q=0, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=127.0.0.1
HTTP_REFERER=
HTTP_USER_AGENT=CFSCHEDULE
PATH_INFO=
PATH_TRANSLATED=C:\Boston Reed\Umbrella\skedge\br_production_check.cfm
QUERY_STRING=RequestTimeout=7200
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/skedge/br_production_check.cfm
SERVER_NAME=127.0.0.1
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Sun ONE Web Server/6.1
WEB_SERVER_API=

URL Parameters:
REQUESTTIMEOUT=7200

Debug Rendering Time: 94 ms