MDLinx logo

Job Alerts

Manage job alerts delivered to your email inbox.

error details:
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT art_id, headline, journal_name, publish_dt, url_keyword, canonical_site_name FROM ( SELECT a.art_id, a.headline, rj.journal_name, ssa.publish_dt, ssa.rank , NVL(a.canonical_site_name, 'internal-medicine') AS canonical_site_name , REGEXP_SUBSTR(REGEXP_REPLACE(LOWER(a.artword), '[^a-z0-9]+', '-'), '([a-z0-9]+-){0,5}([a-z0-9]+)') AS url_keyword FROM arts a, ref_target rt, ref_journal rj, subspec_assignment ssa, ref_spec rs WHERE a.target_id = rt.target_id AND rt.journal_id = rj.journal_id AND a.art_id = ssa.art_id AND ssa.spec_id = 3 AND ssa.subspec_id = 0 AND NVL(ssa.noshow, 'N') != 'Y' AND ssa.spec_id = rs.spec_id AND ( ssa.auth_ind = 'Y' OR rs.active_ind = 'N' ) AND TRUNC(ssa.publish_dt) <= TRUNC(rs.auth_pub_dt) ORDER BY ssa.publish_dt DESC, rank asc ) WHERE rownum <= 10
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
string'NVL' is not a recognized built-in function name.
NativeErrorCode
number195
queryError
stringSELECT art_id, headline, journal_name, publish_dt, url_keyword, canonical_site_name FROM ( SELECT a.art_id, a.headline, rj.journal_name, ssa.publish_dt, ssa.rank , NVL(a.canonical_site_name, 'internal-medicine') AS canonical_site_name , REGEXP_SUBSTR(REGEXP_REPLACE(LOWER(a.artword), '[^a-z0-9]+', '-'), '([a-z0-9]+-){0,5}([a-z0-9]+)') AS url_keyword FROM arts a, ref_target rt, ref_journal rj, subspec_assignment ssa, ref_spec rs WHERE a.target_id = rt.target_id AND rt.journal_id = rj.journal_id AND a.art_id = ssa.art_id AND ssa.spec_id = 3 AND ssa.subspec_id = 0 AND NVL(ssa.noshow, 'N') != 'Y' AND ssa.spec_id = rs.spec_id AND ( ssa.auth_ind = 'Y' OR rs.active_ind = 'N' ) AND TRUNC(ssa.publish_dt) <= TRUNC(rs.auth_pub_dt) ORDER BY ssa.publish_dt DESC, rank asc ) WHERE rownum <= 10
Sql
stringSELECT art_id, headline, journal_name, publish_dt, url_keyword, canonical_site_name FROM ( SELECT a.art_id, a.headline, rj.journal_name, ssa.publish_dt, ssa.rank , NVL(a.canonical_site_name, 'internal-medicine') AS canonical_site_name , REGEXP_SUBSTR(REGEXP_REPLACE(LOWER(a.artword), '[^a-z0-9]+', '-'), '([a-z0-9]+-){0,5}([a-z0-9]+)') AS url_keyword FROM arts a, ref_target rt, ref_journal rj, subspec_assignment ssa, ref_spec rs WHERE a.target_id = rt.target_id AND rt.journal_id = rj.journal_id AND a.art_id = ssa.art_id AND ssa.spec_id = 3 AND ssa.subspec_id = 0 AND NVL(ssa.noshow, 'N') != 'Y' AND ssa.spec_id = rs.spec_id AND ( ssa.auth_ind = 'Y' OR rs.active_ind = 'N' ) AND TRUNC(ssa.publish_dt) <= TRUNC(rs.auth_pub_dt) ORDER BY ssa.publish_dt DESC, rank asc ) WHERE rownum <= 10
SQLState
stringS0010
StackTrace
stringlucee.runtime.exp.DatabaseException: 'NVL' is not a recognized built-in function name. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1662) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:615) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:515) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296) 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 artswidget_cfc$cf$2nu.udfCall(/cfcs/ArtsWidget.cfc:132) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:696) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:584) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1931) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at oncology._arts_widget_cfm$cf$2nt.call(/oncology/_arts_widget.cfm:27) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at right_sidebar_cfm$cf$1sg.call(/right_sidebar.cfm:275) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:940) at lucee.runtime.tag.CFTag.doInclude(CFTag.java:319) at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:245) at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:179) at career.job_alerts_cfm180$cf$2nr.call(/internal-medicine/career/job-alerts.cfm:94) 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
string130: ORDER BY ssa.publish_dt DESC, #variables.sort#<br> 131: ) WHERE rownum &lt;= &lt;cfqueryparam cfsqltype=&quot;CF_SQL_INTEGER&quot; value=&quot;#variables.row_cnt#&quot; /&gt;<br> <b>132: &lt;/cfquery&gt;</b><br> 133: &lt;/cfif&gt;<br> 134: <br>
codePrintPlain
string130: ORDER BY ssa.publish_dt DESC, #variables.sort# 131: ) WHERE rownum <= <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#variables.row_cnt#" /> 132: </cfquery> 133: </cfif> 134:
column
number0
id
string??
line
number132
Raw_Trace
stringartswidget_cfc$cf$2nu.udfCall(/cfcs/ArtsWidget.cfc:132)
template
stringC:\career-dev\cfcs\ArtsWidget.cfc
type
stringcfml
2
Struct
codePrintHTML
string25: <br> 26: &lt;cfset arts_widget_obj = new cfcs.ArtsWidget(spec_id=the_spec_id, keyword=the_keyword, sort=the_sort, row_cnt=art_cnt*2, site_name=the_site_name) /&gt;<br> <b>27: &lt;cfset get_articles = arts_widget_obj.getArticlesQ() /&gt;</b><br> 28: &lt;/cfsilent&gt;<br> 29: <br>
codePrintPlain
string25: 26: <cfset arts_widget_obj = new cfcs.ArtsWidget(spec_id=the_spec_id, keyword=the_keyword, sort=the_sort, row_cnt=art_cnt*2, site_name=the_site_name) /> 27: <cfset get_articles = arts_widget_obj.getArticlesQ() /> 28: </cfsilent> 29:
column
number0
id
string??
line
number27
Raw_Trace
stringoncology._arts_widget_cfm$cf$2nt.call(/oncology/_arts_widget.cfm:27)
template
stringC:\career\oncology\_arts_widget.cfm
type
stringcfml
3
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number275
Raw_Trace
stringright_sidebar_cfm$cf$1sg.call(/right_sidebar.cfm:275)
template
string/right_sidebar.cfm
type
stringcfml
4
Struct
codePrintHTML
string92: &lt;/div&gt;<br> 93: &lt;/cfoutput&gt; <br> <b>94: &lt;cf_right_sidebar dfp_page_name=&quot;Career&quot; /&gt;</b><br> 95: &lt;/div&gt;<br> 96: &lt;div class=&quot;container content-wide&quot;&gt; <br>
codePrintPlain
string92: </div> 93: </cfoutput> 94: <cf_right_sidebar dfp_page_name="Career" /> 95: </div> 96: <div class="container content-wide">
column
number0
id
string??
line
number94
Raw_Trace
stringcareer.job_alerts_cfm180$cf$2nr.call(/internal-medicine/career/job-alerts.cfm:94)
template
stringC:\career\oncology\career\job-alerts.cfm
type
stringcfml
type
stringdatabase
where
string


Session:
Session Scope (Memory)
Entries: 49
access_point
string
access_point_check
string
art_reload_cnt
number0
AUTHOR_IND
number0
authorized
stringno
baseu
stringcareer.mdlinx.com
cfid
string3a1e3863-19be-4152-a89c-f41bff3b8fb1
cftoken
string0
checkforsurveys
string
CROSS_SPEC_ID
string18
DOC_NAME
stringInternist
HOMELINK
string
lastvisit
Date Time (America/New_York)
{ts '2024-12-04 20:01:47'}
MSGMODAL
number1
newuser
string
OLD_SITE_NAME
stringInternalMDLinx
path_info
string
points_monthly
string0
points_total
string0
privacy_check
string
professionTblVar
stringREF_PROFESSION
recruiter_ind
string0
REFERER
string
refSpecialtyTblVar
stringREF_SPECIALTY
refSpecTblVar
stringREF_SPEC
refSubspecTblVar
stringREF_SUBSPEC
sessionid
stringcareer11_3a1e3863-19be-4152-a89c-f41bff3b8fb1_0
SHOW_SHIELD_SQUARE
number1
SITE_NAME
stringinternal-medicine
SITE_URL
stringcareer.mdlinx.com/internal-medicine
SITECAMEFROM
string
spec_id
number3
SPEC_NAME
stringInternal Medicine
state_cd
string
subspec_id
string0
survey_avail
stringN
surveyschecked
stringN
target_ind
string0
target_name
string
the_smdoc_url
stringhttp://www.thesmartestdoc.com/
timecreated
Date Time (America/New_York)
{ts '2024-12-04 20:01:47'}
transl_country
stringUSA
u_spec
string
urltoken
stringCFID=3a1e3863-19be-4152-a89c-f41bff3b8fb1&CFTOKEN=0
user_id
string0
user_id_code
string
user_site_name
stringinternal-medicine
username
string
zip
string0


Form:
Scope
email
string
password
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\job-alerts.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\job-alerts.cfm
query_string
string
remote_addr
string18.97.14.91
remote_host
string18.97.14.91
remote_user
string
request_method
stringGET
request_url
stringhttps://career.mdlinx.com/internal-medicine/career/job-alerts.cfm
script_name
string/internal-medicine/career/job-alerts.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