Sean Callahan
03/07/2023, 10:08 PMcfhttp over an https protocol.
What I can't seem to wrap my head around is that when I run these scripts in the browser using the resolved URL (not localhost, but that also works fine), all is right in the world. But when the scheduler runs them:
"Error","DefaultQuartzScheduler_Worker-1","03/07/23","13:55:27",,"Connection Failure: Status code unavailable "
coldfusion.tagext.net.HttpTag$HttpConnectionFailureException: Connection Failure: Status code unavailable
at coldfusion.tagext.net.HttpTag.connHelper(HttpTag.java:1311)
at coldfusion.tagext.net.HttpTag.runCall(HttpTag.java:1413)
at coldfusion.scheduling.CronTask.execute(CronTask.java:121)
at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
I already imported the production server's cert into the castore. Also the Root CA has been added to the castorebdw429s
03/07/2023, 10:16 PMbdw429s
03/07/2023, 10:16 PMStatus code unavailable error is just a secondary error which typically masks the "real" error.bdw429s
03/07/2023, 10:17 PMcfhttp call yourself, or is this an HTTP request being made directly by the scheduled task?bdw429s
03/07/2023, 10:18 PMbdw429s
03/07/2023, 10:18 PMSean Callahan
03/07/2023, 10:31 PM<!--- file contents of getTaxCodes.cfm --->
<cfquery name="getTaxCodes" datasource="#request.dsn#">
SELECT taxCode,
taxRate
FROM taxTable
WHERE taxClass = 'TX'
</cfquery>
<cfset taxCodeData = "">
<cfoutput query="getTaxCodes">
<cfset taxCodeData &= trim(getTaxCodes.taxCode)>
<cfset taxCodeData = ListAppend(taxCodeData, val(getTaxCodes.taxRate))>
<cfset taxCodeData &= "|">
</cfoutput>
<cfhttp method="post" url="<https://www.productionServer.com/processTaxCodes.cfm>" timeout="6000">
<cfhttpparam type="formfield" name="taxCodeData" value="#taxCodeData#">
</cfhttp>
This code was working just fine on our development server, but I'm porting all of these older scripts to this new VM so that I can update the development environment and production environment since the only thing that was holding them back was the need for this 32-bit connection.
Basically when I run the URL of <https://cf11Server.com/getTaxCodes.cfm> in a browser, all works just fine. But when the CRON tries to run the scheduled job of that same URL, that's when I receive the error.bdw429s
03/07/2023, 10:33 PMgetTaxCodes.cfm what is failing, or is the initial CRON connection to getTaxCodes.cfm what fails?bdw429s
03/07/2023, 10:34 PMcron or just the ColdFusion task scheduler?Sean Callahan
03/07/2023, 10:35 PMexceptions.log file.Sean Callahan
03/07/2023, 10:35 PMcfttp that is failing within the scheduled task, but only when it's being run as a scheduled task.bdw429s
03/07/2023, 10:36 PMSean Callahan
03/07/2023, 10:36 PMbdw429s
03/07/2023, 10:37 PM"Error","DefaultQuartzScheduler_Worker-1","03/07/23","13:55:27",,"Connection Failure: Status code unavailable "
coldfusion.tagext.net.HttpTag$HttpConnectionFailureException: Connection Failure: Status code unavailable
at coldfusion.tagext.net.HttpTag.connHelper(HttpTag.java:1311)
at coldfusion.tagext.net.HttpTag.runCall(HttpTag.java:1413)
at coldfusion.scheduling.CronTask.execute(CronTask.java:121)
at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
makes me think you're never even calling the original URLbdw429s
03/07/2023, 10:37 PMbdw429s
03/07/2023, 10:37 PMSean Callahan
03/07/2023, 10:37 PMSean Callahan
03/07/2023, 10:41 PM