SELECT SuperUsers.User_Id AS Emp_ID,SuperUsers.Username FROM #variables.prefixDbLookup#.SuperUsers WHERE Username = SELECT pEmployee.Emp_ID AS Login_Id,SuperUsers.User_Id AS Emp_ID,SuperUsers.Username, Agency.Agency_ID, Agency.Super_ID, Agency.Agency_Login, pEmployee.Emp_Email AS Emp_Email, pEmployee.Emp_Telephone AS Emp_Telephone ,SuperUsers.Two_FA_Type AS Two_FA_Type FROM #variables.prefixDbLookup#.SuperUsers, #variables.prefixDbLookup#.pEmployee LEFT JOIN #variables.prefixDbLookup#.Agency ON pEmployee.Loc_ID = Agency.Agency_ID WHERE SuperUsers.Super_ID = Agency.Super_ID AND Agency_Login = AND SuperUsers.Username = AND Agency.Status = 'active' SELECT pEmployee.Emp_ID,pEmployee.Username, pEmployee.Password, pEmployee.Emp_ID AS Login_Id,Agency.Agency_Id,Agency.Agency_Login, pEmployee.Emp_Email,1 AS PPInUse ,pPhysicians.Emp_ID, pPhysicians.Phys_ID,0 AS Portal , pEmployee.Emp_Telephone , pEmployee.Two_FA_Type FROM #variables.prefixDbLookup#.pEmployee LEFT JOIN #variables.prefixDbLookup#.Agency ON pEmployee.Loc_ID = Agency.Agency_ID LEFT OUTER JOIN #variables.prefixDbLookup#.pPhysicians ON pEmployee.Emp_ID = pPhysicians.Emp_ID WHERE pEmployee.Username = AND pEmployee.Password = AND pEmployee.Emp_Type != 'Physician' AND Agency.Status = AND pEmployee.Status = SELECT pEmployee.Emp_ID , pEmployee.Emp_Email, pEmployee.Emp_Telephone , pEmployee.Two_FA_Type , pEmployee.Two_FA_Code , Two_FA_CreationTime FROM #variables.prefixDbLookup#.pEmployee WHERE pEmployee.Emp_ID = SELECT Logon_Date FROM #variables.prefixDbLookup#.Logon WHERE Emp_ID = order by Logon_Date DESC limit 1 SELECT Two_FA_Code FROM #variables.prefixDbLookup#.pEmployee WHERE Two_FA_Code = WHERE Emp_ID = UPDATE #variables.prefixDbLookup#.pEmployee SET Two_FA_Code = , Two_FA_CreationTime = WHERE Emp_ID = UPDATE #variables.prefixDbLookup#.pEmployee SET Two_FA_Type = , Emp_Email = , Emp_Telephone = WHERE Emp_ID = SELECT pPatients.Patient_ID,pCMS4857.Order_ID,pCMS4857.Date_Create,pCMS4857.Form_Type,LEFT(pCMS4857.Order_description , 25) AS description FROM #Request.prefix_db_agency#.pCMS4857 LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pCMS4857.Assmt_ID AND pAssessments.status =0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID AND pAssessments.status < 2 WHERE pCMS4857.Form_status = 'Sent via Fax' AND pCMS4857.status = 0 AND pPatients.Patient_ID = GROUP BY pCMS4857.Order_ID UPDATE #Request.prefix_db_agency#.pCMS4857 SET Form_status = 'Signed & Received via Fax', Date_Change = WHERE Order_ID = UPDATE #Request.prefix_db_lookup#.Received_faxes SET Order_ID = , Agency_ID = , Change_by = , Date_Change = WHERE ID = UPDATE #Request.prefix_db_agency#.pCMS4857 SET Form_status = 'Signed & Received via Fax', Date_Change = WHERE Order_ID = UPDATE #Request.prefix_db_lookup#.Received_faxes SET Order_ID = , Patient_ID = , Agency_ID = , Change_by = , Date_Change = WHERE ID = UPDATE #Request.prefix_db_lookup#.Received_faxes SET status = , Change_by = , Date_Change = WHERE ID = SELECT ID, Order_ID FROM #Request.prefix_db_lookup#.Received_faxes WHERE ID = AND Agency_ID = AND Order_ID > 0 AND status = 0 UPDATE #Request.prefix_db_lookup#.Received_faxes SET Order_ID = 0, Change_by = , Date_Change = WHERE ID = SELECT COUNT(*) AS n FROM #Request.prefix_db_lookup#.Received_faxes WHERE Agency_ID = AND Order_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pCMS4857 SET Form_status = 'Sent via Fax', Date_Change = , Change_by = WHERE Order_ID = AND Status = 0 AND Form_status = 'Signed & Received via Fax' UPDATE #Request.prefix_db_agency#.pCMS4857 SET Form_status = 'Signed & Received via Fax', Date_Change = WHERE Order_ID = AND Status = 0 UPDATE #Request.prefix_db_lookup#.Received_faxes SET Order_ID = , Agency_ID = , Change_by = 2, Date_Change = WHERE ID = ANd status = 0

OCR Fax Processing Error

Error Details:

  • Error Message: #CFCATCH.Message#
  • Error Detail: #CFCATCH.Detail#
  • Error Type: #CFCATCH.Type#
  • Timestamp: #now()#

Fax Information:

  • Agency ID: #arguments.agency_id#
  • Order ID: #arguments.order_id#
  • Fax ID: #arguments.ID#

Please investigate this error and take appropriate action.