#3492 Making a tickler note renders chart unusable

[Randy Jonasz]

If user makes a note on a tickler, the code inserts a record into casemgmt_issue even if the tickler issue already exists for the patient. Duplicate issues prevent the user from saving notes in the patient's chart.

[SBek]

Replicated in Master (build# 2168)

Pre-condition: Active Tickler is added to the Patient Record
Steps to replicate:

1. Launch Patient eChart
2. Select Tickler from the left menu bar
3. Select Tickler Note icon
4. Enter Tickler note text and select Save&Exit button
5. Go back to the Patient's echart and add new note
6. Enter note text and select Save/Sign&Save button

Expected: Encounter note is saved/signed and saved
Observed: HTTP Status 500 is triggered.
NOTE: Attached full stack trace

[SBek]

Screen shot is attached

[Marc Dumontier]

https://source.oscartools.org:8080/10992

[SBek]

Re-tested Master commit: https://source.oscartools.org:8080/10992
Observed: issue still persists

[Marc Dumontier]

The check I added looks to see if there exists an entry in the casemgmt_issue table where issue_id = ? and demographic_no = ?. If an entry exists, it should not create a new one.

Can you run this on your db and substitute in your patient id

select ci.*,i.code from casemgmt_issue ci,issue i where ci.issue_id=i.issue_id and demographic_no = <patient.id>;</patient.id>

and post the results. If you have a patient that's already messed up, the fix doesn't backfix the data as it's never been put into production, it shouldn't be a concern.

[SBek]

Tested on demo server https://demo.oscarmcmaster.org:11246/oscar_twelve/index.jsp:

1. created a new patient (Test, Tickler)
2. added a tickler and tickler note
3. added echart note -> works fine (screen shot 1)
4. repeated steps 2-3 -> 500 error is produced

[SBek]

Also tested SFHC demo (oct2014AlphaMaster-1)-> Error is produced

[Marc Dumontier]

when i go onto the demo server, create a new patient (test,tickler2), the tickler note button doesn't work for me so I can't continue. You don't get this issue?

[Marc Dumontier]

https://source.oscartools.org:8080/11158

[SBek]

Re-tested Master build #2249 -> issue has been resolved

The tickler note button doesn't work when you access it from the encounter screen on demo server. It works fine on local machine as well as the clinic's test server. Check it later when demo server will be upgraded if it reoccurs again.
Workaround is available: add a tickler note from the main Ticklers tab.