ISG
ATHENA
RECORDS ACQUISITION TRACKING SYSTEM

ColdFusion Server 2018
Development Database

 


 
*
*
Please contact helpdesk@isgvalue.com if you have problems logging into RATS.
 


Debugging Information
ColdFusion Server Enterprise 2018,0,19,330149
Template /login.cfm
Time Stamp 17-Sep-24 05:16 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.10.12.7
Host Name 10.10.12.7


Execution Time

Total Time Avg Time Count Template
15 ms 15 ms 1 top level C:\web\cf\com.litsol.rats\code\login.cfm
3 ms 3 ms 1 CFC[ C:/web/cf/com.litsol.rats/code/Application.cfc | onRequestStart(/login.cfm) ] from C:/web/cf/com.litsol.rats/code/Application.cfc
0 ms 0 ms 1 C:/web/cf/com.litsol.rats/code/include/js/validateFormReqJS.html
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
19 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

lastLoginQry (Datasource=dev_rats, Time=12ms, Records=0) in C:\web\cf\com.litsol.rats\code\login.cfm @ 17:16:55.055
									SELECT TOP 1 UL.ULlogoutTime 
									FROM dbo.UserLog UL
									WHERE UL.ULipAddress = ?
										AND UL.ULloginTime > CAST(getDate() AS DATE)
									ORDER BY UL.ULid DESC
								
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 10.10.12.7


Stored Procedures

core.GetSystemSetupValuesBySystemSetupKeyList (Datasource=dev_rats, Time=3ms) in C:\web\cf\com.litsol.rats\code\Application.cfc @ 17:16:55.055

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  Environment    
    
resultsets
nameresultset
 local.qSystemSetupKey  1
eventcalendar.GetActiveEventCalendarData (Datasource=dev_rats, Time=3ms) in C:\web\cf\com.litsol.rats\code\login.cfm @ 17:16:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  RATS    
    
resultsets
nameresultset
 request.qActiveEventCalendar  1


Scope Variables

Application Variables:
applicationname=Test_RATS
awsbucketname=testfilmsrepo
awschunksizefactor=10
awsclientbuilder=Complex type
awsendpoint=https://s3.wasabisys.com
awsid=L34G832H61LAA55CQPMB
awsregion=us-east-1
awssecret=iDodpO3VoYsAVBu3AaakLsUiJ2ouybjRyzrBysAA
basicawscredentials=Complex type
credentials=Complex type
endpointconfiguration=Complex type
environment=Development
filemailurl=www.litsol.com/filemail
fileserverip=\\ISGFSRM\dev\
isgmailingaddress=275 Curry Hollow Road<br />Building 1<br />Suite 150<br />Pittsburgh, PA 15236
jqueryloc=/jquery-3.3.1/jquery-3.3.1.js
lsi_db=dev_lsi
name=Test_RATS
ocommon=Struct (1)
protocol=https:
rats_db=dev_rats
transfermanager=Complex type
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=CN=*.litsol.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\web\cf\com.litsol.rats\code\login.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=CN=*.litsol.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=
HTTP_HOST=testrats.litsol.com
HTTP_REFERER=
HTTP_URL=/login.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.10.11.72
PATH_INFO=
PATH_TRANSLATED=C:\web\cf\com.litsol.rats\code\login.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.12.7
REMOTE_HOST=10.10.12.7
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/login.cfm
SERVER_NAME=testrats.litsol.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=105740
CFTOKEN=9b6e87e4228bc60e-1274A743-C7AF-4F0A-4A5DBC29A7D5E98E
Form Fields:
errorMsg=
loginAttempts=
pwd=
rats_username=
secQuestionAttempts=
uname=
Request Parameters:
environment=Development
qactiveeventcalendar=Query (0)
samesite_value=
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
sessionid=93E4F27B4E51C20B77690C75B8D6E0FA.cfusion
urltoken=CFID=105740&CFTOKEN=9b6e87e4228bc60e-1274A743-C7AF-4F0A-4A5DBC29A7D5E98E&jsessionid=93E4F27B4E51C20B77690C75B8D6E0FA.cfusion
Debug Rendering Time: 1 ms