Bulk Import AI - Authentication Failed!

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

Reason: Invalid API Key

Agency ID: #arguments.agency_id#

Employee ID: #arguments.emp_id#

IP Address: #CGI.REMOTE_ADDR#

User Agent: #CGI.HTTP_USER_AGENT#

Provided Key (masked): #Left(arguments.appkey, 10)#***

Security Alert: Unauthorized access attempt detected.

This is an automated security notification from the Bulk Import AI API

Bulk Import AI - Authentication Error!

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

Agency ID: #arguments.agency_id#

Employee ID: #arguments.emp_id#

IP Address: #CGI.REMOTE_ADDR#

User Agent: #CGI.HTTP_USER_AGENT#

Error Details:

Error Type: #cfcatch.type#

Error Message: #cfcatch.message#

Error Detail: #cfcatch.detail#

File: #cfcatch.TagContext[1].template#

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

Stack Trace:

#cfcatch.stacktrace#

This is an automated error notification from the Bulk Import AI API

Bulk Import AI - Patient Data Imported Successfully!

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

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

Encryption IDs and AppKeys:

Field	Original (Encrypted)	Decrypted Value	Was Encrypted
Agency_ID	`#htmlEditFormat(arguments.originalAgencyID)#`	`#htmlEditFormat(arguments.decryptedAgencyID)#`	#iif(arguments.decryptedAgencyID NEQ arguments.originalAgencyID, DE('Yes'), DE('No'))#
Emp_ID	`#htmlEditFormat(arguments.originalEmpID)#`	`#htmlEditFormat(arguments.decryptedEmpID)#`	#iif(arguments.decryptedEmpID NEQ arguments.originalEmpID, DE('Yes'), DE('No'))#
Patient_ID	`#htmlEditFormat(arguments.originalPatientID)#`	`#htmlEditFormat(arguments.decryptedPatientID)#`	#iif(arguments.decryptedPatientID NEQ arguments.originalPatientID, DE('Yes'), DE('No'))#
Assessment_ID	`#htmlEditFormat(arguments.originalAssessmentID)#`	`#htmlEditFormat(arguments.decryptedAssessmentID)#`	#iif(arguments.decryptedAssessmentID NEQ arguments.originalAssessmentID, DE('Yes'), DE('No'))#
appkey	`#htmlEditFormat(arguments.originalAppKey)#`	`#htmlEditFormat(arguments.decryptedAppKey)#`	#iif(len(arguments.decryptedAppKey) GT 0 AND arguments.decryptedAppKey NEQ arguments.originalAppKey, DE('Yes'), DE('No'))#

Encryption Key Available: Yes (Length: #len(Application.enckey)#)

Encryption Key Available: No

Import Results:

Patient AI ID: #arguments.insertedPatientID# (#arguments.patientAction#)

Emergency Contact: #iif(arguments.contactInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedContactID#)

Payer/Subscriber: #iif(arguments.payerInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedPayerID#)

Admission Record: #iif(arguments.admitInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedAdmitID#)

Medications: #arguments.medicationCount# record(s) inserted

Problems/Diagnoses: #arguments.problemCount# record(s) inserted/updated

Extracted Data (JSON):

#htmlEditFormat(arguments.extractedJSONString)#

Partial Errors:

#err#

Debug Information:

Datasource: #Application.DataSrc#
Agency Database: #arguments.agency_db#
Transaction Status: Committed Successfully

This is an automated notification from the Bulk Import AI API

Bulk Import AI - Patient Data Import Failed!

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

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

Error Information:

Error Type: #errorType#

Error Message: #errorMessage#

Error Detail: #errorDetail#

Failed at Step: #htmlEditFormat(arguments.currentStep)#

File: #errorTagContext[1].template#

Line: #errorTagContext[1].line#

Step-by-Step Error Details:

#htmlEditFormat(stepErr)#

Encryption IDs and AppKeys:

Field	Original (Encrypted)	Decrypted Value	Was Encrypted
Agency_ID	`#htmlEditFormat(arguments.originalAgencyID)#`	`#htmlEditFormat(arguments.decryptedAgencyID)#`	#iif(arguments.decryptedAgencyID NEQ arguments.originalAgencyID, DE('Yes'), DE('No'))#
Emp_ID	`#htmlEditFormat(arguments.originalEmpID)#`	`#htmlEditFormat(arguments.decryptedEmpID)#`	#iif(arguments.decryptedEmpID NEQ arguments.originalEmpID, DE('Yes'), DE('No'))#
Patient_ID	`#htmlEditFormat(arguments.originalPatientID)#`	`#htmlEditFormat(arguments.decryptedPatientID)#`	#iif(arguments.decryptedPatientID NEQ arguments.originalPatientID, DE('Yes'), DE('No'))#
Assessment_ID	`#htmlEditFormat(arguments.originalAssessmentID)#`	`#htmlEditFormat(arguments.decryptedAssessmentID)#`	#iif(arguments.decryptedAssessmentID NEQ arguments.originalAssessmentID, DE('Yes'), DE('No'))#
appkey	`#htmlEditFormat(arguments.originalAppKey)#`	`#htmlEditFormat(arguments.decryptedAppKey)#`	#iif(len(arguments.decryptedAppKey) GT 0 AND arguments.decryptedAppKey NEQ arguments.originalAppKey, DE('Yes'), DE('No'))#

Encryption Key Available: Yes (Length: #len(Application.enckey)#)

Encryption Key Available: No

Partial Import Results (before error):

Patient AI ID: #arguments.insertedPatientID#
Medications: #arguments.medicationCount# record(s)
Problems/Diagnoses: #arguments.problemCount# record(s)

Previous Errors:

#err#

Extracted Data (JSON):

#htmlEditFormat(arguments.extractedJSONString)#

Stack Trace:

#htmlEditFormat(errorStacktrace)#

This is an automated error notification from the Bulk Import AI API

Whisper Assessment Import Completed Successfully

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

Job ID: #arguments.jobID#

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

Assessment Update Results

Assessment Reason: #htmlEditFormat(arguments.assessmentReason)#
Mapped F-columns Updated: #arguments.mappedAnswerCount#
Skipped Answers: #arrayLen(arguments.skippedAnswers)#
Transaction Status: Committed Successfully
Datasource: #Application.DataSrc#
Agency Database: #arguments.agency_db#

Skipped Answers

#htmlEditFormat(skippedAnswer)#

Warnings Captured During Import

#htmlEditFormat(stepErr)#

Extracted Data (JSON)

#htmlEditFormat(arguments.extractedJSONString)#

This is an automated notification from the Whisper Assessment Import API

No filled answers in payload.

" /> SELECT ques_id, answer_label, questions_label, CASE WHEN questions_2 <> '' THEN TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques_identifier_2), ''), NULLIF(TRIM(questions_2), ''))) ELSE TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques_identifier), ''), NULLIF(TRIM(questions), ''))) END AS question_description FROM #arguments.lookup_db#.assessment_questions_lookup WHERE assessment_reason = AND Deleted = Questions and Filled Answers' /> Assessment Reason: ' & htmlEditFormat(trim(arguments.assessmentReason)) & '

' /> ' /> ' /> QuestionAnswerImport Status' /> ' /> ' /> ' & htmlEditFormat(questionText) & '' /> ' & filledValue & '' /> ' & importStatus & '' /> ' /> ' /> ' /> TypeUpdatedInsertedSkippedNotes' /> Vitals (vital_* → pWoundsVitals)' & vitalUpdated & '' & vitalInserted & '' & vitalSkipped & '' /> ' /> Wounds (wound_* → pWoundsVitals)' & woundUpdated & '' & woundInserted & '' & woundSkipped & '' /> ' /> Questions table could not be built: " & htmlEditFormat(cfcatch.message) & "

" />

importAssessmentData Request / Response Trace

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #htmlEditFormat(arguments.websiteName)#

Job ID: #htmlEditFormat(arguments.jobID)#

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

Last Step: #htmlEditFormat(arguments.currentStep)#

#vitalsWoundsSummaryHtml#

#questionsAnswersTableHtml#

Request Payload

#htmlEditFormat(requestBody)#

Response Payload

#htmlEditFormat(responseBody)#

Step Errors / Warnings

#htmlEditFormat(traceEntry)#

This trace email is sent only for importAssessmentData.

The full trace email could not be sent.

Error: #htmlEditFormat(mailError)#

Assessment ID: #arguments.assessmentID#

Last Step: #htmlEditFormat(arguments.currentStep)#

SELECT Lookup_1, Lookup_2, Measure FROM #arguments.lookup_db#.pValue_Lookup WHERE Item_ID = ORDER BY ID SELECT vp.Item_ID, vp.Value_Low, vp.Value_High, MAX(vl.Description) AS Description, MAX(vl.Measure) AS Measure, MAX(vl.Required) AS Required FROM #arguments.agency_db#.pVital_Param vp INNER JOIN #arguments.lookup_db#.pValue_Lookup vl ON vl.Item_ID = vp.Item_ID AND vl.Description <> WHERE vp.Status = AND vp.Vital_Sign <> GROUP BY vp.Item_ID, vp.Value_Low, vp.Value_High ORDER BY vp.Item_ID SELECT MAX(vl.Description) AS Description FROM #arguments.lookup_db#.pValue_Lookup vl WHERE vl.Item_ID = AND vl.Description <> SELECT Vital_Sign FROM #arguments.agency_db#.pVital_Param WHERE Item_ID = AND Status = LIMIT 1 SELECT Value_Low, Value_High FROM #arguments.agency_db#.pVital_Param WHERE Item_ID = AND Status = LIMIT 1 SELECT ID FROM #arguments.agency_db#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = AND Item_ID = LIMIT 1 UPDATE #arguments.agency_db#.pWoundsVitals SET Description = , Reading1 = , Notes = , Param_Lo = , Param_Hi = , pain_location = , pain_duration = , pain_exacerbate = , pain_relief = , pain_med_effectiveness = , Date_Change = , Change_by = WHERE ID = INSERT INTO #arguments.agency_db#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Param_Lo, Param_Hi, Notes, Reading1, pain_location, pain_duration, pain_exacerbate, pain_relief, pain_med_effectiveness, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , ) SELECT ID, Item_ID, Pathway_ID FROM #arguments.agency_db#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = ORDER BY Pathway_ID DESC LIMIT 1 UPDATE #arguments.agency_db#.pWoundsVitals SET Description = , Location = , other_locations = , Length = , Width = , Depth = , healingstage = , woundtype = , Pathway_ID = , wnd_tunneling = , wnd_underm = , wnd_gran = , wnd_epith = , wnd_eschar = , wnd_slough = , wnd_fib = , wnd_margin = , wnd_exudate = , wnd_odor = , wnd_pain = , Param_Hi = , Reading1 = , Date_Change = , Change_by = WHERE ID = SELECT Item_ID FROM #arguments.agency_db#.pWoundsVitals WHERE VitalOrWound = AND Assmt_ID = AND Status = ORDER BY Pathway_ID DESC INSERT INTO #arguments.agency_db#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Location, other_locations, Length, Width, Depth, Param_Hi, Reading1, Date_Create, Created_by, Date_Change, Change_by, healingstage, frompgnote, woundtype, wnd_margin, wnd_exudate, wnd_odor, wnd_pain, wnd_tunneling, wnd_underm, wnd_gran, wnd_epith, wnd_eschar, wnd_slough, wnd_fib ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT ques_id, CASE WHEN questions_2 <> '' THEN TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques_identifier_2), ''), NULLIF(TRIM(questions_2), ''))) ELSE questions END AS questions, ques_identifier_2 AS questions_new, quescolor,title_2 as title, questions_label, answer_label, questions_type, new_order_id AS order_id , assessment_reason, new_wizard AS wizard, ques_identifier_2 AS ques_identifier FROM #lookup_db#.assessment_questions_lookup WHERE assessment_reason = AND Deleted = 0 ORDER BY order_id, wizard, answer_label SELECT val_id AS VAL_ID, answer_2 AS ANSWER, text_labels AS TEXT_LABELS, assessment_reason AS ASSESSMENT_REASON, ans_id AS ANS_ID, item_id AS ITEM_ID, answer_2 AS ANSWER_2, question_id AS QUESTION_ID, answer_type AS ANSWER_TYPE FROM #lookup_db#.assessment_answers_lookup WHERE assessment_reason = AND Deleted = 0 ORDER BY question_id, srt_id, answer_label SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND COLUMN_NAME IN ('Review_Status', 'Upload_Source') ALTER TABLE #arguments.agency_db#.whisper_files ADD COLUMN Review_Status TINYINT NOT NULL DEFAULT 0 ALTER TABLE #arguments.agency_db#.whisper_files ADD COLUMN Upload_Source VARCHAR(20) NOT NULL DEFAULT '' SELECT INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND INDEX_NAME IN ('idx_whisper_review_status', 'idx_whisper_assmt_review') GROUP BY INDEX_NAME ALTER TABLE #arguments.agency_db#.whisper_files ADD INDEX idx_whisper_review_status (Review_Status) ALTER TABLE #arguments.agency_db#.whisper_files ADD INDEX idx_whisper_assmt_review (Assmt_ID, Review_Status) UPDATE #arguments.agency_db#.whisper_files SET Review_Status = WHERE ID = AND Status = AND Review_Status = SELECT ID FROM #arguments.agency_db#.whisper_files WHERE Assmt_ID = AND Status = AND Review_Status = ORDER BY ID DESC LIMIT 1 UPDATE #arguments.agency_db#.whisper_files SET Review_Status = WHERE ID = UPDATE #arguments.agency_db#.whisper_files SET Review_Status = WHERE Assmt_ID = AND Status = AND Review_Status = SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = UPDATE #arguments.agency_db#.pAssessments SET #batchFields[i]# = NULL , , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = UPDATE #arguments.agency_db#.pAssessments SET #fieldName# = NULL , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = SELECT AutoAssmt_ID, F26 FROM #agency_db#.pAssessments WHERE Assmt_ID = AND Patient_ID = AND Status = ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND COLUMN_NAME NOT IN ( , ) ORDER BY ORDINAL_POSITION INSERT INTO #agency_db#.pAssessments (#preserveSingleQuotes(assessmentColumnList)#) SELECT #preserveSingleQuotes(assessmentColumnList)# FROM #agency_db#.pAssessments WHERE AutoAssmt_ID = LIMIT 1 SELECT LAST_INSERT_ID() AS LastInsertID UPDATE #agency_db#.pAssessments SET Status = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = UPDATE #agency_db#.pAssessments SET Status = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = SELECT F26 FROM #agency_db#.pAssessments WHERE AutoAssmt_ID = SELECT ques_id, answer_label FROM #lookup_db#.assessment_questions_lookup WHERE assessment_reason = AND Deleted = AND answer_label IS NOT NULL AND trim(answer_label) != ''