#3531 Inbox - Deleted Documents Cannot Be Viewed or Acknowledged

[Trimara Corporation]

Problem Summary:
If a document is routed to a physician for acknowledgement but deleted prior to the physician performing the acknowledgement, the document viewer will not display the document - it simply shows a blank screen. This means that the physician cannot acknowledge the document and causes confusion for staff and physicians.

Expected Result:
Even though the document has been deleted, it should still appear in the document viewer so the physician can acknowledge it.

Actual Result:
The document cannot be acknowledged as the document viewer simply displays a blank screen.

Steps to Reproduce:
(1) Upload a document through Inbox-->Doc Upload. Use the "Send to Provider" dropdown to select the physician that should acknowledge the document (or route it to yourself).
(2) Open the document through the Inbox and assign it to a patient chart.
(3) Go into the patient chart, access the "Documents" section and delete the document. Screenshot attached.
(4) Go back to the Inbox and try to view the document that was deleted. The document viewer will display a blank screen. Screenshot attached.

Reproduced In:
12_1 Deb 436 (fresh install) + Ubuntu 12 LTS (fresh install)

Additional Information:
-- This is being cuased by the fact that the query to open the document filters out deleted documents.
SELECT DISTINCT c.module, c.module_id, d.* FROM document d, ctl_document c WHERE d.status=c.status AND d.status != 'D' AND c.document_no=d.document_no AND c.document_no='3' ORDER BY d.updatedatetime DESC
-- The deleted document being filtered out causes exceptions in the Tomcat
2014-10-16 06:40:18,689 ERROR [DbConnectionFilter:67] Unexpected error.
org.apache.jasper.JasperException: An exception occurred processing JSP page /dms/showDocument.jsp at line 384

381: <bean:message key="inboxmanager.document.LinkedProvidersMsg">
382: <%
383: Properties p = (Properties) session.getAttribute("providerBean");
384: List<providerinboxitem> routeList = providerInboxRoutingDao.getProvidersWithRoutingForDocument("DOC", docId);
385: %>
386: </providerinboxitem></bean:message>

387: <%for (ProviderInboxItem pItem : routeList) {

2014-10-16 06:40:18,833 ERROR [ManageDocumentAction:669] Error
java.lang.NumberFormatException: For input string: "null"

[SBek]

It appears to be a duplicate of the bug [#2475].