Vertex token request failed

Agency ID: #session.AgencyID#

Employee ID: #employeeId#

Patient ID: #patientId#

File ID: #fileId#

Dup File Name: #dupFileName#

S3 URL: #s3Url#

Token Status: #tokenStatusCode#

Token URL: #tokenURL#

Token Request Body:

#encodeForHTML(tokenRequestBody)#

Token Type: #accessTokenType#

Token Response:

#encodeForHTML(tokenResponseBody)#
 UPDATE #Request.prefix_db_agency#.vertex_jobs SET job_status = , error_message = , result_json = , raw_response = , Last_Checked = NOW() WHERE ID = UPDATE #Request.prefix_db_agency#.vertex_jobs SET task_id = , job_status = , poll_url = , submitted_at = , raw_response = , status_response = , result_json = , error_message = , Last_Checked = NOW() WHERE ID = UPDATE #Request.prefix_db_agency#.vertex_jobs SET task_id = , job_status = , raw_response = , status_response = , result_json = , error_message = , Last_Checked = NOW() WHERE ID = function getPlaceholderValue(value) { if (isDefined("arguments.value") && len(trim(arguments.value)) > 0) { return trim(arguments.value); } else { return "PLACEHOLDER"; } }

Medication Sync Failed in call_vertex_api.cfm

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #session.AgencyID#

Patient ID: #patientIdVal#

Employee ID: #employeeIdVal#

File ID: #fileId#

Dup File Name: #dupFileName#

Exception Details:

Error Type: #htmlEditFormat(cfcatch.type)#

Error Message: #htmlEditFormat(cfcatch.message)#

Error Detail: #htmlEditFormat(left(cfcatch.detail, 1000))#

Stack Trace:

#htmlEditFormat(left(cfcatch.stackTrace, 2000))#

Error Location:

File: #htmlEditFormat(cfcatch.TagContext[1].template)#

Line: #cfcatch.TagContext[1].line#

Request Variables Set:

request.med_sync_patient_id: #request.med_sync_patient_id#NOT SET

request.med_sync_employee_id: #request.med_sync_employee_id#NOT SET

Vertex API Response:

Vertex API Status: #httpStatus#

S3 URL: #s3Url#

Vertex Response Body:

#htmlEditFormat(left(responseBody, 2000))#

Note: This error occurred when trying to include sync_ai_medications.cfm. The Vertex API call was successful but medication sync failed. The main request will continue without medication sync.

Problems Sync Failed - Exception Error

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #session.AgencyID#

Patient ID: #patientIdVal#

Assessment ID: #resolvedAssessmentId#

Employee ID: #employeeIdVal#

Exception Details:

Error Type: #htmlEditFormat(cfcatch.type)#

Error Message: #htmlEditFormat(cfcatch.message)#

Error Detail: #htmlEditFormat(left(cfcatch.detail, 1000))#

Stack Trace:

#htmlEditFormat(left(cfcatch.stackTrace, 2000))#

File: #htmlEditFormat(cfcatch.TagContext[1].template)#

Line: #cfcatch.TagContext[1].line#

Request Variables Set:

request.problems_sync_patient_id: #request.problems_sync_patient_id#NOT SET

request.problems_sync_assmt_id: #request.problems_sync_assmt_id#NOT SET

request.problems_sync_employee_id: #request.problems_sync_employee_id#NOT SET

Note: This error occurred when trying to include sync_problems_action.cfm. The sync process failed but the main request will continue.

Problems Sync Blocked - Assessment ID Missing

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #session.AgencyID#

Patient ID: #patientIdVal#

Employee ID: #employeeIdVal#

Assessment ID Resolution:

Original Assessment ID from file: #assessmentId#

Resolved Assessment ID: #resolvedAssessmentId#

Resolved Assessment ID (numeric): #val(resolvedAssessmentId)#

Why Sync Was Blocked:

The sync_problems_action.cfm was NOT called because:

  • Condition 1: len(resolvedAssessmentId) = #len(resolvedAssessmentId)# ❌ FAILED✓ PASSED
  • Condition 2: val(resolvedAssessmentId) GT 0 = #val(resolvedAssessmentId) GT 0# ✓ PASSED❌ FAILED

Other Conditions Check:

isSuccess: #isSuccess# ✓ PASSED❌ FAILED

patientIdVal GT 0: #patientIdVal GT 0# ✓ PASSED❌ FAILED

Note: Problems sync requires a valid Assessment ID. Please ensure the file has an Assessment ID or that a valid assessment exists for this patient.

SELECT Notes FROM #table_files# WHERE id = AND AgencyId = AND Status = 0 LIMIT 1 UPDATE #table_files# SET Notes = WHERE id = AND AgencyId =

Vertex API call returned status #httpStatus#

🔒 SSL CERTIFICATE VERIFICATION ERROR DETECTED

The Vertex API service cannot verify the SSL certificate when calling back to #application.secure#

Root Cause: The Vertex API (Python service) is trying to make an HTTPS request to:
https://#websiteName#/components/API/bulk_import_ai.cfc?method=importPatientData

Error: CERTIFICATE_VERIFY_FAILED: unable to get local issuer certificate

Callback URL Used: https://#websiteName#/components/API/bulk_import_ai.cfc?method=importPatientData

Temporary Workaround (Application Configuration):

You can set Application.vertexCallbackURL in Application.cfm to use a different hostname with a valid SSL certificate. For example:

Note: This is a temporary workaround. The proper fix is to resolve the SSL certificate issue.

Required Actions (Infrastructure Team - Permanent Fix):
  1. Ensure the full SSL certificate chain is installed on #application.secure#
  2. Verify the certificate includes all intermediate certificates (not just the end-entity certificate)
  3. Check that the certificate authority (CA) is trusted by the Vertex API service (Python service at int-extractaiapi.myhomecarebiz.com)
  4. If using a self-signed or internal CA certificate, the Vertex API service may need to be configured to trust it
  5. Alternatively, the Vertex API service configuration may need to be updated to include the CA certificate bundle
  6. Test SSL certificate verification from the Vertex API server: openssl s_client -connect stagesecure.myhomecarebiz.com:443 -showcerts

Agency ID: #session.AgencyID#

Employee ID: #employeeId#

Patient ID: #patientId#

File ID: #fileId#

Dup File Name: #dupFileName#

S3 URL: #s3Url#

Token Status: #tokenStatusCode#

Token URL: #tokenURL#

Token Request Body:

#encodeForHTML(tokenRequestBody)#

Token Type: #accessTokenType#

Token Response:

#encodeForHTML(tokenResponseBody)#

Request Body:

#encodeForHTML(serializeJSON(payload))#

Response Body:

#encodeForHTML(responseBody)#
 UPDATE #Request.prefix_db_agency#.vertex_jobs SET task_id = , job_status = , raw_response = , status_response = , result_json = , error_message = , Last_Checked = NOW() WHERE ID = UPDATE #Request.prefix_db_agency#.vertex_jobs SET job_status = , error_message = , result_json = , raw_response = , status_response = , Last_Checked = NOW() WHERE ID =