Debugging Information
ColdFusion Server Enterprise 2016,0,17,325979
Template /directory/index.cfm
Time Stamp 29-Sep-21 09:00 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.225.240.12
Host Name 10.225.240.12


Execution Time

Total Time Avg Time Count Template
465 ms 465 ms 1 /opt/www/cfapps.flinders/directory/index.cfm
465 ms 465 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onRequest(/directory/index.cfm) ] from /opt/www/cfapps.flinders/directory/Application.cfc
464 ms 464 ms 1 /opt/www/cfapps.flinders/directory/wheels/index.cfm
464 ms 464 ms 1 CFC[ /opt/www/cfapps.flinders/directory/wheels/Dispatch.cfc | $request() ] from /opt/www/cfapps.flinders/directory/wheels/Dispatch.cfc
446 ms 446 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $processAction() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
361 ms 361 ms 1 CFC[ /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc | send() ] from /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc
40 ms 40 ms 1 /opt/www/cfapps.flinders/directory/views/layout.cfm
29 ms 15 ms 2 /opt/www/cfapps.flinders/directory/root.cfm
26 ms 26 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | findAll(returnas = objects, where = fan IS NOT NULL AND flinderspersonnotpublishsearch != 'TRUE' AND (jobstartdate IS NOT NULL AND jobstartdate <= TO_DATE('2021-09-29', 'YYYY-MM-DD')) AND (jobenddate IS NOT NULL AND jobenddate >= TO_DATE('2021-09-29', 'YYYY-MM-DD')) AND workertype IS NOT NULL AND appointmenttype IS NOT NULL AND ( appointmenttypesearch NOT IN ('CASUAL','CASUAL_AGREED_RATE','CASUAL_ONE_OFF','CONTRACTOR') OR (appointmenttypesearch IN ('CASUAL','CASUAL_AGREED_RATE','CASUAL_ONE_OFF','CONTRACTOR') AND telephonenumber IS NOT NULL) ) AND userid=262101, select = userid,staffnumber,telephonenumber1,fullname,ou,position1,locationtype,location1,room1,oustructlevel1,oustructlevel2,oustructlevel3,oustructlevel4,oustructlevel5,email,emailalias) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
16 ms 16 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $createControllerObject([complex value]) ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
13 ms 13 ms 1 /opt/www/cfapps.flinders/directory/wheels/controller.cfm
13 ms 13 ms 1 /opt/www/cfapps.flinders/directory/wheels/model.cfm
9 ms 9 ms 1 /opt/www/cfapps.flinders/directory/views/search/info.cfm
9 ms 9 ms 1 /opt/www/cfapps.flinders/directory/wheels/functions.cfm
9 ms 9 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/functions.cfm
6 ms 6 ms 1 CFC[ /opt/www/cfapps.flinders/directory/wheels/model/adapters/Oracle.cfc | $query(argumentCollection = [complex value]) ] from /opt/www/cfapps.flinders/directory/wheels/model/adapters/Oracle.cfc
5 ms 5 ms 1 /opt/www/cfapps.flinders/directory/wheels/controller/appfunctions.cfm
5 ms 5 ms 1 /opt/www/cfapps.flinders/directory/wheels/controller/functions.cfm
4 ms 4 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/functions.cfm
3 ms 3 ms 1 /opt/www/cfapps.flinders/directory/views/templates/_common.cfm
3 ms 2 ms 2 /opt/www/cfapps.flinders/directory/wheels/global/functions.cfm
2 ms 2 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onRequestStart(/directory/index.cfm) ] from /opt/www/cfapps.flinders/directory/Application.cfc
1 ms 1 ms 1 /opt/www/cfapps.flinders/directory/views/search/_info.cfm
1 ms 1 ms 1 /opt/www/cfapps.flinders/directory/wheels/global/appfunctions.cfm
1 ms 1 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onRequestEnd(/directory/index.cfm) ] from /opt/www/cfapps.flinders/directory/Application.cfc
1 ms 1 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onSessionStart() ] from /opt/www/cfapps.flinders/directory/Application.cfc
1 ms 1 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $initControllerObject(PATH = controllers, METHOD = $initControllerObject, params = [complex value], FILENAME = Search, name = Search) ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
1 ms 1 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $initModelObject(PATH = models, persisted = true, properties = [complex value], METHOD = $initModelObject, row = 1, FILENAME = Users, useFilterLists = NO, name = users, base = true) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/config/app.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/events/functions.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/events/onrequestend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/events/onrequeststart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/events/onsessionstart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/views/helpers.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/views/templates/_backup-global-nav.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/caching.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/filters.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/flash.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/initialization.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/layouts.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/miscellaneous.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/processing.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/provides.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/redirection.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/rendering.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/verifies.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onapplicationend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onapplicationstart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onerror.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onmissingtemplate.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onrequest.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onrequestend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onrequeststart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onsessionend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onsessionstart.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/global/cfml.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/global/internal.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/global/public.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/associations.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/calculations.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/callbacks.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/create.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/delete.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/errors.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/initialization.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/miscellaneous.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/nestedproperties.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/onmissingmethod.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/properties.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/read.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/serialize.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/sql.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/transactions.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/update.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/validations.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/plugins/injection.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/assets.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/dates.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/errors.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/forms.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsassociation.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsdate.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsdateobject.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsdateplain.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsobject.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsplain.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/links.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/miscellaneous.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/sanitize.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/text.cfm
0 ms 0 ms 1 CFC[ /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc | INIT() ] from /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc
0 ms 0 ms 1 CFC[ /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc | addParam(value = 042312, type = formfield, name = value) ] from /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc
0 ms 0 ms 1 CFC[ /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc | addParam(value = 2021-09-29, type = formfield, name = effectiveDate) ] from /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc
0 ms 0 ms 1 CFC[ /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc | addParam(value = employeeId, type = formfield, name = type) ] from /opt/coldfusion2016/cfusion/CustomTags/com/adobe/coldfusion/http.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $flashClear() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $getControllerClassData() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $performedRedirect() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | response() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $callback(afterFind, true) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $callback(afterInitialization, true) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $classData() ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
28 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
497 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

09:00:06.006 - Expression Exception - in /opt/www/cfapps.flinders/directory/wheels/controller/verifies.cfm : line 61
	    Element SESSIONMANAGEMENT is undefined in a Java object of type class coldfusion.runtime.StructBean.
	    
09:00:07.007 - javax.net.ssl.SSLException - in /opt/www/cfapps.flinders/directory/views/layout.cfm : line 5
	    Unsupported record version Unknown-0.0
	    


SQL Queries

query.name (Datasource=iam-prod, Time=4ms, Records=1) in /opt/www/cfapps.flinders/directory/wheels/model/adapters/Base.cfc @ 09:00:06.006
SELECT users.userid,users.staffnumber,(NVL(telephonenumber,'-')) AS telephonenumber1,(nvl2(title,title||' ','')||firstname||' '||lastname) AS fullname,(
            CASE
                WHEN
                    (
                        oustructlevel3 IS NOT NULL
                        AND oustructlevel2 IS NOT NULL
                        AND oustructlevel3 = oustructlevel2 
                        AND oustructlevel2 = oustructlevel1
                    )
                    OR 
                    (
                        oustructlevel3 IS NULL
                        AND oustructlevel2 IS NULL
                    )
                    THEN oustructlevel1
                WHEN
                    (
                        oustructlevel3 IS NOT NULL
                        AND oustructlevel2 IS NOT NULL
                        AND oustructlevel3 = oustructlevel2 
                        AND oustructlevel2 != oustructlevel1
                    )
                    OR oustructlevel3 IS NULL
                    THEN oustructlevel2
                WHEN
                    (
                        oustructlevel3 IS NOT NULL
                        AND oustructlevel2 IS NOT NULL
                        AND oustructlevel3 != oustructlevel2 
                        AND oustructlevel2 != oustructlevel1
                    )
                    THEN oustructlevel2 || ', ' || oustructlevel3
                ELSE '-'
            END
        ) AS ou,(nvl(position,'-')) AS position1,(
            CASE
                WHEN
                    location IS NULL and campus IS NOT NULL
                    then 'Campus'
                ELSE
                    'Building'
            END
        ) AS locationtype,(
            CASE
                WHEN
                    location IS NOT NULL
                    THEN location
                WHEN
                    location IS NULL and campus IS NOT NULL
                    then campus
                ELSE
                    '-'
            END
        ) AS location1,(
            CASE
                WHEN
                    location IS NOT NULL
                    THEN nvl(room,'-')
                WHEN
                    location IS NULL and campus IS NOT NULL
                    then '-'
                ELSE
                    '-'
            END
        ) AS room1,users.oustructlevel1,users.oustructlevel2,users.oustructlevel3,users.oustructlevel4,users.oustructlevel5,users.email,(
            CASE
                WHEN 
                    UPPER(appointmenttype) != 'CONTRACTOR'
                    THEN TRIM(LOWER(SUBSTR(email, 0, INSTR(email, '@')-1)))
                ELSE '-'
            END
        ) AS emailalias
FROM users
WHERE
users.FAN IS NOT
NULL

        AND 
(NVL2(flinderspersonnotpublish,UPPER(flinderspersonnotpublish),'FALSE')) !=
?

        AND (
users.JOBSTARTDATE IS NOT
NULL
 AND jobstartdate <= TO_DATE('2021-09-29', 'YYYY-MM-DD'))
        AND (
users.JOBENDDATE IS NOT
NULL
 AND jobenddate >= TO_DATE('2021-09-29', 'YYYY-MM-DD'))
        AND 
users.WORKERTYPE IS NOT
NULL

        AND 
users.APPOINTMENTTYPE IS NOT
NULL

        AND (
            
(UPPER(appointmenttype)) NOT IN
(?,?,?,?)

            OR (
(UPPER(appointmenttype)) IN
(?,?,?,?)
 AND 
users.TELEPHONENUMBER IS NOT
NULL
)
        )
         AND 
users.USERID =
?
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = TRUE
Parameter #2(CF_SQL_CHAR) = CASUAL
Parameter #3(CF_SQL_CHAR) = CASUAL_AGREED_RATE
Parameter #4(CF_SQL_CHAR) = CASUAL_ONE_OFF
Parameter #5(CF_SQL_CHAR) = CONTRACTOR
Parameter #6(CF_SQL_CHAR) = CASUAL
Parameter #7(CF_SQL_CHAR) = CASUAL_AGREED_RATE
Parameter #8(CF_SQL_CHAR) = CASUAL_ONE_OFF
Parameter #9(CF_SQL_CHAR) = CONTRACTOR
Parameter #10(cf_sql_integer) = 262101


Scope Variables

Application Variables:
applicationname=6F417EA936F2CF04E4238AF94687606E
wheels=Struct (104)
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=/opt/www/cfapps.flinders/directory/index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=on
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=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.flinders.edu.au
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.224.64.41
PATH_INFO=/search/info
PATH_TRANSLATED=/opt/www/cfapps.flinders/directory/index.cfm
QUERY_STRING=userid=262101
REMOTE_ADDR=10.225.240.12
REMOTE_HOST=10.225.240.12
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/index.cfm
SERVER_NAME=www.flinders.edu.au
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_jk/1.2.46
WEB_SERVER_API=
Cookie Variables:
CFID=17715576
CFTOKEN=50571e6f17d23dba-D370A314-D427-93B2-609BD4CA8082E25A
Request Parameters:
cgi=Struct (18)
samesite_value=
wheels=Struct (7)
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=17715576
cftoken=50571e6f17d23dba-D370A314-D427-93B2-609BD4CA8082E25A
flash=Struct (0)
sessionid=6F417EA936F2CF04E4238AF94687606E_17715576_50571e6f17d23dba-D370A314-D427-93B2-609BD4CA8082E25A
urltoken=CFID=17715576&CFTOKEN=50571e6f17d23dba-D370A314-D427-93B2-609BD4CA8082E25A
URL Parameters:
userid=262101
Debug Rendering Time: 9 ms