SunFish5 PDA Login  
User Name
Password
Forgot Your Password?
PC Login | PDA Login 

Debugging Information
ColdFusion Server Standard 10,0,0,283922
Template /sunfish5/ehrm/default.cfm
Time Stamp 22-Jul-26 10:48 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 172.16.251.124
Host Name 172.16.251.124

Execution Time

Total Time Avg Time Count Template
40 ms 40 ms 1 CFC[ C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc | onRequest(/sunfish5/ehrm/default.cfm) ] from C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc
39 ms 39 ms 1 top level C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.cfm
35 ms 9 ms 4 C:/ColdFusion10/cfusion/wwwroot/SunFish/customtags/sunfish36/DO_SF_V32_MULTILANGUAGE.cfm
20 ms 20 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5upload/ehrm/template/ehrmloginpda/template1/index.cfm
16 ms 16 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/customtags/sunfish36/DO_SF_V32_LOGIN.cfm
11 ms 11 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/initial.cfm
5 ms 5 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/Application.cfc
4 ms 4 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/customtags/sunfish36/DO_SF_V32_FORGOTPOPUP.cfm
4 ms 4 ms 1 CFC[ C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc | onRequestStart(/sunfish5/ehrm/default.cfm) ] from C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc
0 ms 0 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/include/libfunction.cfm
0 ms 0 ms 8 C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/include/appvars.cfm
0 ms 0 ms 1 C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/utility/_global.cfm
0 ms 0 ms 1 CFC[ C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc | onRequestEnd(/sunfish5/ehrm/default.cfm) ] from C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/ehrm/Application.cfc
12 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
56 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

Exceptions

10:48:12.012 - Database Exception - in C:/ColdFusion10/cfusion/wwwroot/SunFish/sunfish5/Application.cfc : line 223
	    Error Executing Database Query.

SQL Queries

(Datasource=dbSunfishMais_Live, Time=0ms, Records=0) in C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\Application.cfc @ 10:48:12.012
					SET CONCAT_NULL_YIELDS_NULL  OFF
qDB (Datasource=dbSunfishMais_Live, Time=1ms, Records=1) in C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\Application.cfc @ 10:48:12.012
			select type_name_en SQLColumn from thrmmastertype where UPPER(type_code) = 'MSSQL'
qDateTimeFormat (Datasource=dbSunfishMais_Live, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\Application.cfc @ 10:48:12.012
				SELECT Date_Format, Time_Format FROM THRMSetting
qMultiLanguage (Datasource=dbSunfishMais_Live, Time=5ms, Records=2) in C:\ColdFusion10\cfusion\wwwroot\SunFish\customtags\sunfish36\DO_SF_V32_MULTILANGUAGE.cfm @ 10:48:12.012
	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('NOACTIVETEMPLATE','SESSIONEXPIRED')
qAppTemplate (Datasource=dbSunfishMais_Live, Time=1ms, Records=1) in C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.cfm @ 10:48:12.012
	SELECT TAppTemplate.*, TAppTemplateActive.AppTemplateActive_Name, TAppTemplateActive.AppTemplateActive_File,
			TApplication.App_ID, TApplication.App_Name
	FROM TApplication,TAppTemplateActive,TAppTemplate
	WHERE 
	TApplication.App_ID=TAppTemplateActive.App_ID
	AND TAppTemplateActive.AppTemplateActive_ID=TAppTemplate.AppTemplateActive_ID
	AND TAppTemplateActive.AppTemplateActive_Name = 
	
	'ehrmloginpda'
	
		AND TAppTemplate.AppTemplate_Status=1
	
	ORDER BY UPPER(TApplication.App_Name), UPPER(TAppTemplateActive.AppTemplateActive_Name), UPPER(TAppTemplate.AppTemplate_Name)
qMultiLanguage (Datasource=dbSunfishMais_Live, Time=11ms, Records=5) in C:\ColdFusion10\cfusion\wwwroot\SunFish\customtags\sunfish36\DO_SF_V32_MULTILANGUAGE.cfm @ 10:48:12.012
	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('LANGUAGE','ACTIVEREQUEST','APPRAISALNEEDRR','APPRAISALNEEDCN','OFFICE')
qMultiLanguage (Datasource=dbSunfishMais_Live, Time=15ms, Records=8) in C:\ColdFusion10\cfusion\wwwroot\SunFish\customtags\sunfish36\DO_SF_V32_MULTILANGUAGE.cfm @ 10:48:12.012
	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('USERNAME','PASSWORD','INPUTVALIDUSERNAME','INPUTVALIDPASSWORD','CLICKHERETOLOGIN','LOGIN','LOGOUT','LOGOUTMESSAGE')
qSetting (Datasource=dbSunfishMais_Live, Time=0ms, Records=1) in C:\ColdFusion10\cfusion\wwwroot\SunFish\customtags\sunfish36\DO_SF_V32_LOGIN.cfm @ 10:48:12.012
	SELECT	UseEntryForm,DISPLAY_ATT_LOGON
	FROM	THRMSetting
qMultiLanguage (Datasource=dbSunfishMais_Live, Time=3ms, Records=1) in C:\ColdFusion10\cfusion\wwwroot\SunFish\customtags\sunfish36\DO_SF_V32_MULTILANGUAGE.cfm @ 10:48:12.012
	SELECT TLanguageText.*
	FROM TLanguageText	
	WHERE 
		UPPER(TLanguageText.Text_ID) IN ('FORGOTYOURPASSWORD')

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:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.cfm
CONTENT_LENGTH=0
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=br,gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D74303693%26CFTOKEN%23%3Df0ac5ad3971d3a1f%2D4D3BF639%2DE6CA%2D58C6%2DDBB96ED9C3D6BD5E%23lastvisit%3D%7Bts%20%272026%2D07%2D22%2010%3A48%3A10%27%7D%23timecreated%3D%7Bts%20%272026%2D07%2D22%2010%3A48%3A09%27%7D%23hitcount%3D3%23cftoken%3Df0ac5ad3971d3a1f%2D4D3BF639%2DE6CA%2D58C6%2DDBB96ED9C3D6BD5E%23cfid%3D74303693%23; CFID=74303694; CFTOKEN=48886171567e7cb0-4D3C05F0-A5E8-9F54-DB177035D678F4AA; LANG_ID=1; MODE=pda
HTTP_HOST=hr.mais.gov.my
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PATH_INFO=
PATH_TRANSLATED=C:\ColdFusion10\cfusion\wwwroot\SunFish\sunfish5\ehrm\default.cfm
QUERY_STRING=changemode=pda&refresh=%7Bts+%272026-07-22+09%3A50%3A39%27%7D
REMOTE_ADDR=172.16.251.124
REMOTE_HOST=172.16.251.124
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sunfish5/ehrm/default.cfm
SERVER_NAME=hr.mais.gov.my
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=

Client Variables:
cfid=74303693
cftoken=f0ac5ad3971d3a1f-4D3BF639-E6CA-58C6-DBB96ED9C3D6BD5E
hitcount=3
lastvisit={ts '2026-07-22 10:48:10'}
timecreated={ts '2026-07-22 10:48:09'}
urltoken=CFID=74303694&CFTOKEN=48886171567e7cb0-4D3C05F0-A5E8-9F54-DB177035D678F4AA

Cookie Variables:
CFGLOBALS=urltoken=CFID#=74303693&CFTOKEN#=f0ac5ad3971d3a1f-4D3BF639-E6CA-58C6-DBB96ED9C3D6BD5E#lastvisit={ts '2026-07-22 10:48:10'}#timecreated={ts '2026-07-22 10:48:09'}#hitcount=3#cftoken=f0ac5ad3971d3a1f-4D3BF639-E6CA-58C6-DBB96ED9C3D6BD5E#cfid=74303693#
CFID=74303694
CFTOKEN=48886171567e7cb0-4D3C05F0-A5E8-9F54-DB177035D678F4AA
LANG_ID=1
MODE=pda

Session Variables:
cfid=74303694
cftoken=48886171567e7cb0-4D3C05F0-A5E8-9F54-DB177035D678F4AA
sessionid=SUNFISH_HR53_CF10_HR_MAIS_GOV_MY_LIVE20120724_74303694_48886171567e7cb0-4D3C05F0-A5E8-9F54-DB177035D678F4AA
urltoken=CFID=74303694&CFTOKEN=48886171567e7cb0-4D3C05F0-A5E8-9F54-DB177035D678F4AA

URL Parameters:
changemode=pda
refresh={ts '2026-07-22 09:50:39'}
Debug Rendering Time: 173 ms