Troubleshooting: Error [E990] Exception in GetPatients...Syntax Error
If you see an Error [E990] message like the one below when trying to file patient forms, follow the steps below to troubleshoot.
Important! Not all E990 errors are the same! If your message is different from the one below, check out our other articles Troubleshooting: Error [E990] Recall Manager Is Disabled and Troubleshooting: Error [E990] Exception in GetPatients...A key has reached a maximum limit...
or contact our Customer Support team.
| Error Message | |
|---|---|
|
|
ERROR: Exception in GetPatients: ERROR [42000] [Pervasive][ODBC Client Interface][Pervasive][ODBC Engine Interface] Syntax Error e","Person File" LEFT OUTER JOIN 'PatMedAlerts' ON 'PatMedAlerts","PatientID" = "Person ID" where "Patient File","Person ID" = "Person File","Person ID" AND "Patient File","Last name" LIKE....<<??? |
Table of Contents
Troubleshooting This Error
This form of Error [E990] occurs when a patient in your practice management software (Dentrix, Open Dental, or Eaglesoft) has a name with punctuation or a special character in it like "Ming-Na," "Amanté," or "O'Connor." This is more common with Eaglesoft users.
To fix this issue so you can file your patient's forms:
-
In your practice management software, remove the punctuation or special character from the patient's name.
-
Close and reopen YAPI.
Related Articles
- Troubleshooting: Error [E990] Recall Manager Is Disabled
-
Troubleshooting: Error [E990] Exception in GetPatients...A key has reached a maximum limit...