How to Delete a Patient with No Patient ID

If a patient is in the patient cache and has no patient ID, when the patient is deleted completely an error report will be generated.

Blue Cherry will shut down and once restarted the patient is out of the cache but is still in the database but cannot be opened into the patient cache without and error report being displayed.

1. Install SQL Server Management Studio Express (https://www.microsoft.com/en gb/download/details.aspx?id=8961).

2. Once downloaded open SQL Server Management Studio

3. Find out which database Blue Cherry is currently using.

(check the config.xml file for the correct database (Located: C:\ProgramData\Geratherm Respiratory GmbH\Blue Cherry) the text between the <DATASOURCE> & </DATASOURCE> is the database that Blue Cherry is using.

4. Connect to the correct database using SQL Server Authentication;

Username: sa
Password: Blue123Cherry

5. Once logged in navigate to Databases > Geratherm Respiratory > Tables > dbo.Patients.

6. Right click on dbo.Patients and click ‘Open Table’.

7. In the main viewing window a list of all of the patients in Blue Cherry will be shown.

8. The second column from the left is the Blue Cherry patient ID, Scroll down this list until a blank cell is visible; looking along the row the details of this patient should match the details of the patient that cannot be deleted in Blue Cherry.

9. *BEFORE DELETEING ANY OF THESE PATIENTS BE 100% SURE THAT IT IS THE CORRECT PATIENT, THE DELETION OF THE WRONG PATIENT WILL RESULT IN THE PATIENT FILE BEING LOST AND UNRECOVERABLE.* This patient needs to be deleted from within SQL Server management Studio Express. To delete the patient right click on the column and select ‘Delete’.

10. Once the patient has been deleted open Blue Cherry and search for the patient to ensure it has been deleted correctly and is no longer in the database