error details:
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT distinct(js.spec_id) FROM car_jobs j inner join car_job_specs js on j.job_id = js.job_id WHERE j.active_ind = 'Y' and j.employer_id = ''
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.5888
DriverName
stringMicrosoft JDBC Driver 9.4 for SQL Server
DriverVersion
string9.4.1.0
Datasource
stringmdlinx
DataSource
stringmdlinx
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringError converting data type nvarchar to numeric.
NativeErrorCode
number8114
queryError
stringSELECT distinct(js.spec_id) FROM car_jobs j inner join car_job_specs js on j.job_id = js.job_id WHERE j.active_ind = 'Y' and j.employer_id = ''
Sql
stringSELECT distinct(js.spec_id) FROM car_jobs j inner join car_job_specs js on j.job_id = js.job_id WHERE j.active_ind = 'Y' and j.employer_id = ''
SQLState
stringS0005
StackTrace
stringlucee.runtime.exp.DatabaseException: Error converting data type nvarchar to numeric. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5471) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1794) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1052) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:701) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at career.featured_employer_cfm405$cf$e54.call(/family-medicine/career/featured-employer.cfm:86) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string84: WHERE j.active_ind = &lt;cfqueryparam cfsqltype=&quot;cf_sql_varchar&quot; value=&quot;Y&quot; /&gt;<br> 85: and j.employer_id = &lt;cfqueryparam cfsqltype=&quot;cf_sql_varchar&quot; value=&quot;#qry_featured_employer.car_client_id#&quot; /&gt;<br> <b>86: &lt;/cfquery&gt;</b><br> 87: <br> 88: &lt;cfset the_featured_specs = valueList(featured_specs.spec_id) /&gt;<br>
codePrintPlain
string84: WHERE j.active_ind = <cfqueryparam cfsqltype="cf_sql_varchar" value="Y" /> 85: and j.employer_id = <cfqueryparam cfsqltype="cf_sql_varchar" value="#qry_featured_employer.car_client_id#" /> 86: </cfquery> 87: 88: <cfset the_featured_specs = valueList(featured_specs.spec_id) />
column
number0
id
string??
line
number86
Raw_Trace
stringcareer.featured_employer_cfm405$cf$e54.call(/family-medicine/career/featured-employer.cfm:86)
template
stringC:\career\oncology\career\featured-employer.cfm
type
stringcfml
type
stringdatabase
where
string


Session:
Session Scope (Memory)
Entries: 32
art_reload_cnt
number0
baseu
stringcareer.mdlinx.com
cfid
stringbe00af24-a0f6-4414-9271-f395180bb228
cftoken
string0
CROSS_SPEC_ID
string18
DOC_NAME
stringInternist
HOMELINK
string
lastvisit
Date Time (America/New_York)
{ts '2025-02-09 13:10:20'}
newuser
string
OLD_SITE_NAME
stringInternalMDLinx
path_info
string
points_monthly
string0
points_total
string0
professionTblVar
stringREF_PROFESSION
recruiter_ind
string0
REFERER
string
refSpecialtyTblVar
stringREF_SPECIALTY
refSpecTblVar
stringREF_SPEC
refSubspecTblVar
stringREF_SUBSPEC
sessionid
stringcareer11_be00af24-a0f6-4414-9271-f395180bb228_0
SITE_NAME
stringinternal-medicine
SITE_URL
stringcareer.mdlinx.com/internal-medicine
SITECAMEFROM
string
spec_id
number3
SPEC_NAME
stringInternal Medicine
subspec_id
string0
timecreated
Date Time (America/New_York)
{ts '2025-02-09 13:10:20'}
transl_country
stringUSA
urltoken
stringCFID=be00af24-a0f6-4414-9271-f395180bb228&CFTOKEN=0
user_id
string0
user_id_code
string
username
string


Form:
Scope
car_spec
number3
email
string
jobLocation
string
page_id
string0
password
string
sort_by
stringpost_date
state
string
Component (internal-medicine.Application)
Only the functions and data members that are accessible from your location are displayed
ExtendsApplicationProxy
HintSecondary application event handler.
this
public
APPLICATIONTIMEOUT
TimespancreateTimeSpan(1,0,0,0)
CUSTOMTAGPATHS
stringc:\career\customtags\,c:\webs\career.mdlinx.com\customtags\
DATASOURCES
Struct
mdlinx
Struct
BUNDLENAME
stringorg.lucee.mssql
BUNDLEVERSION
string9.4.1.jre8
CLASS
stringcom.microsoft.sqlserver.jdbc.SQLServerDriver
CONNECTIONLIMIT
number10
CONNECTIONSTRING
stringjdbc:sqlserver://10.201.1.70\DBPM1:0;DATABASENAME=mdlinx;sendStringParametersAsUnicode=true;SelectMethod=direct
LIVETIMEOUT
number15
PASSWORD
stringencrypted:0db569535ade1165d991fdc94b713237c429c30e9ba93ddf325ee5a74c70ed265d835ef5f2056281
USERNAME
stringPM_APPL_USER
VALIDATE
booleanfalse
enforceSSLRequirement
Public Function enforceSSLRequirement
source: C:\career\application.cfc
arguments
labelnamerequiredtypedefaulthint
return typevoid
HOST
stringcareer.mdlinx.com
MAPPINGS
Struct
/cfcs
stringc:\career-dev\cfcs\
/include
stringc:\career-dev\include\
MDLINX_flushArtCache
Public Function MDLINX_flushArtCache
source: C:\career\oncology\Application.cfc
arguments
labelnamerequiredtypedefaulthint
spec_idtruenumericnull
subspec_idfalsenumeric0
return typeboolean
NAME
stringcareer11
onApplicationEnd
Public Function onApplicationEnd
source: C:\career\application.cfc
arguments
labelnamerequiredtypedefaulthint
return typeany
onApplicationStart
Public Function onApplicationStart
source: C:\career\application.cfc
arguments
labelnamerequiredtypedefaulthint
return typeany
onError
Public Function onError
source: C:\career\application.cfc
arguments
labelnamerequiredtypedefaulthint
Excepttrueanynull
EventNametrueStringnull
return typeany
onRequestEnd
Public Function onRequestEnd
source: C:\career\application.cfc
arguments
labelnamerequiredtypedefaulthint
return typeany
onRequestStart
Public Function onRequestStart
source: C:\career\oncology\Application.cfc
Hanldes pre-page processing for each request.
arguments
labelnamerequiredtypedefaulthint
PagetruestringnullThe template requested by the user.
return typeboolean
onSessionEnd
Public Function onSessionEnd
source: C:\career\application.cfc
arguments
labelnamerequiredtypedefaulthint
return typeany
onSessionStart
Public Function onSessionStart
source: C:\career\application.cfc
Fires when the session is first created.
arguments
labelnamerequiredtypedefaulthint
return typevoid
SESSIONMANAGEMENT
booleantrue
SESSIONTIMEOUT
TimespancreateTimeSpan(1,0,0,0)
SETCLIENTCOOKIES
booleantrue
SETSUBDOMAINCOOKIES
booleantrue


cgi:
CGI Scope
Entries: 47
auth_password
string
auth_type
string
auth_user
string
cert_cookie
string
cert_flags
string
cert_issuer
string
cert_keysize
string256
cert_secretkeysize
string3072
cert_serialnumber
string
cert_server_issuer
stringC=US, O=Let's Encrypt, CN=R10
cert_server_subject
stringCN=career.mdlinx.com
cert_subject
string
cf_template_path
stringC:\career\oncology\career\featured-employer.cfm
content_length
string
content_type
string
context_path
string
gateway_interface
stringCGI/1.1
http_accept
stringtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding
stringbr,gzip
http_accept_language
stringen-US,en;q=0.5
http_connection
stringKeep-Alive
http_cookie
string
http_host
stringcareer.mdlinx.com
http_referer
string
http_user_agent
stringCCBot/2.0 (https://commoncrawl.org/faq/)
https
stringon
https_keysize
string256
https_secretkeysize
string
https_server_issuer
stringC=US, O=Let's Encrypt, CN=R10
https_server_subject
stringCN=career.mdlinx.com
local_addr
string10.201.1.140
local_host
stringSTL-PMLUCEE-01
path_info
string
path_translated
stringC:\career\oncology\career\featured-employer.cfm
query_string
stringfeatured_employer=medicus
remote_addr
string18.97.14.80
remote_host
string18.97.14.80
remote_user
string
request_method
stringGET
request_url
stringhttps://career.mdlinx.com/internal-medicine/career/featured-employer.cfm?featured_employer=medicus
script_name
string/internal-medicine/career/featured-employer.cfm
server_name
stringcareer.mdlinx.com
server_port
string443
server_port_secure
string1
server_protocol
stringHTTP/1.1
server_software
string
web_server_api
string