#3430 Display Error in Inbox when sex is blank in demographics

[Shehzad Merchant]

OSCAR build date: Jun 13, 2014 12:28:45 PM
OSCAR build tag: 12.1.1.51general410
Client browser: FireFox ESR 24.7.0

Client OS: Windows 7

Preconditions:

1. Please provide all information needed before this issue will present

If patient's sex(gender) is blank in the demographics and try to view the documents of type 'DOC' in Inbox. It will display the number of documents in left panel but when click it does not display any documents

Steps to reproduce:

1. Please give all steps to reproduce this issue (if there is data required to reproduce, please attach that to the issue)

If patient's sex(gender) is blank in the demographics and try to view the documents of type 'DOC' from Inbox. It will show the number of documents in left panel but when click it does not display any documents

When verifies from the catalina.log it indicates the error that 'could not read column value from result set: sex; String index out of range: 0' and displays the exception message 'exception in DOCPopulate'

Error occurs in the file 'InboxResultsDao.java' on line
lbData.sex = getStringValue(r[sexLoc]);

and catch in the exception.

Following query would be executed in that scenario.

SELECT doc.document_no as id, plr.status, last_name, first_name, hin, sex, module_id, observationdate, plr.lab_type as doctype, doc.document_no
FROM document doc,
(SELECT DISTINCT plr.* FROM providerLabRouting plr
, hl7TextInfo info
WHERE plr.status like '%N%'
AND plr.provider_no = '<<demogharic no="" without="" the="" gender="">>' And
(plr.lab_type = 'DOC' OR (plr.lab_no = info.lab_no AND (info.result_status IS NULL OR info.result_status != 'A')))
ORDER BY id DESC
) AS plr
LEFT JOIN
(SELECT module_id, document_no FROM ctl_document cd
WHERE cd.module = 'demographic' AND cd.module_id != '-1') AS Y
ON plr.lab_type = 'DOC' AND plr.lab_no = Y.document_no
LEFT JOIN
(SELECT demographic_no, first_name, last_name, hin, sex
FROM demographic d) AS Z
ON Y.module_id = Z.demographic_no
WHERE doc.document_no = plr.lab_no AND plr.lab_type = 'DOC'</demogharic>

Expected Result:

It should display the list of documents when select the patient.

Observed:

It was resolved by providing the sex (gender) of patient. During migration from legacy System into OSCAR database, some of the mandatory fields could be blank.

Other details:

[SBek]

Replicated on both R12.1 (build #416) and Master(build #2068)

[Marc Dumontier]

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

[SBek]

Re-tested R12.1 (build#435) -> issue has been resolved

[SBek]

Could the fix be applied to Master?

[Shehzad Merchant]

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

Hi Suni Bek,

We updated the blank fields of Sex(Gender) into the database in order to resolve the issue. We did not make any changes in the source code.

Thanks

Shehzad Merchant

Programmer Analyst
THIYOH Inc.

3020 Brock St. N
Whitby, Ontario
L1R 3J7

p 905.665.KELA (5352)
c. 647.786.4380
f. 905.668.8778

----

On September 26, 2014 at 1:24 PM Suni Bek <sunibek@users.sf.net> wrote:

Could the fix be applied to Master?

---

[bugs:#3430] Display Error in Inbox when sex is blank in demographics

Status: open-fixed
Group: OSCAR Main Trunk
Created: Tue Jul 29, 2014 06:06 PM UTC by Shehzad Merchant
Last Updated: Fri Sep 26, 2014 05:22 PM UTC
Owner: Marc Dumontier

OSCAR build date: Jun 13, 2014 12:28:45 PM
OSCAR build tag: 12.1.1.51general410
Client browser: FireFox ESR 24.7.0

Client OS: Windows 7

Preconditions:

1. Please provide all information needed before this issue will present

If patient's sex(gender) is blank in the demographics and try to view the documents of type 'DOC' in Inbox. It will display the number of documents in left panel but when click it does not display any documents

Steps to reproduce:

1. Please give all steps to reproduce this issue (if there is data required to reproduce, please attach that to the issue)

If patient's sex(gender) is blank in the demographics and try to view the documents of type 'DOC' from Inbox. It will show the number of documents in left panel but when click it does not display any documents

When verifies from the catalina.log it indicates the error that 'could not read column value from result set: sex; String index out of range: 0' and displays the exception message 'exception in DOCPopulate'

Error occurs in the file 'InboxResultsDao.java' on line
lbData.sex = getStringValue(r[sexLoc]);

and catch in the exception.

Following query would be executed in that scenario.

SELECT doc.document_no as id, plr.status, last_name, first_name, hin, sex, module_id, observationdate, plr.lab_type as doctype, doc.document_no
FROM document doc,
(SELECT DISTINCT plr.* FROM providerLabRouting plr
, hl7TextInfo info
WHERE plr.status like '%N%'
AND plr.provider_no = '<<Demogharic No="" without="" the="" Gender="">>' And
(plr.lab_type = 'DOC' OR (plr.lab_no = info.lab_no AND (info.result_status IS NULL OR info.result_status != 'A')))
ORDER BY id DESC
) AS plr
LEFT JOIN
(SELECT module_id, document_no FROM ctl_document cd
WHERE cd.module = 'demographic' AND cd.module_id != '-1') AS Y
ON plr.lab_type = 'DOC' AND plr.lab_no = Y.document_no
LEFT JOIN
(SELECT demographic_no, first_name, last_name, hin, sex
FROM demographic d) AS Z
ON Y.module_id = Z.demographic_no
WHERE doc.document_no = plr.lab_no AND plr.lab_type = 'DOC'

Expected Result:

It should display the list of documents when select the patient.

Observed:

It was resolved by providing the sex (gender) of patient. During migration from legacy System into OSCAR database, some of the mandatory fields could be blank.

Other details:

---

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/oscarmcmaster/bugs/3430/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

 

[SBek]

Marc, could you commit your fix to the Master branch as well so we can validate and close the bug

[Marc Dumontier]

I don't have a fix. It's more like make sure there's never an empty value
at this point, or I guess we could change the type to just be a varchar or
an enum.

On Wed, Oct 1, 2014 at 12:10 PM, Suni Bek sunibek@users.sf.net wrote:

Marc, could you commit your fix to the Master branch as well so we can
validate and close the bug

---

• [bugs:#3430] http://sourceforge.net/p/oscarmcmaster/bugs/3430 Display
  Error in Inbox when sex is blank in demographics*

Status: open-fixed
Group: OSCAR Main Trunk
Created: Tue Jul 29, 2014 06:06 PM UTC by Shehzad Merchant
Last Updated: Fri Sep 26, 2014 05:24 PM UTC
Owner: Marc Dumontier

OSCAR build date: Jun 13, 2014 12:28:45 PM
OSCAR build tag: 12.1.1.51general410
Client browser: FireFox ESR 24.7.0

Client OS: Windows 7
Preconditions:

1. Please provide all information needed before this issue will present

If patient's sex(gender) is blank in the demographics and try to view the
documents of type 'DOC' in Inbox. It will display the number of documents
in left panel but when click it does not display any documents
Steps to reproduce:

1. Please give all steps to reproduce this issue (if there is data
   required to reproduce, please attach that to the issue)

If patient's sex(gender) is blank in the demographics and try to view the
documents of type 'DOC' from Inbox. It will show the number of documents in
left panel but when click it does not display any documents

When verifies from the catalina.log it indicates the error that 'could not
read column value from result set: sex; String index out of range: 0' and
displays the exception message 'exception in DOCPopulate'

Error occurs in the file 'InboxResultsDao.java' on line
lbData.sex = getStringValue(r[sexLoc]);

and catch in the exception.

Following query would be executed in that scenario.

SELECT doc.document_no as id, plr.status, last_name, first_name, hin, sex,
module_id, observationdate, plr.lab_type as doctype, doc.document_no
FROM document doc,
(SELECT DISTINCT plr.* FROM providerLabRouting plr
, hl7TextInfo info
WHERE plr.status like '%N%'
AND plr.provider_no = '<<demogharic no="" without="" the="" gender="">>'
And
(plr.lab_type = 'DOC' OR (plr.lab_no = info.lab_no AND (info.result_status
IS NULL OR info.result_status != 'A')))
ORDER BY id DESC
) AS plr
LEFT JOIN
(SELECT module_id, document_no FROM ctl_document cd
WHERE cd.module = 'demographic' AND cd.module_id != '-1') AS Y
ON plr.lab_type = 'DOC' AND plr.lab_no = Y.document_no
LEFT JOIN
(SELECT demographic_no, first_name, last_name, hin, sex
FROM demographic d) AS Z
ON Y.module_id = Z.demographic_no
WHERE doc.document_no = plr.lab_no AND plr.lab_type = 'DOC'
Expected Result:</demogharic>

It should display the list of documents when select the patient.
Observed:

It was resolved by providing the sex (gender) of patient. During migration
from legacy System into OSCAR database, some of the mandatory fields could
be blank.

Other details:

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/oscarmcmaster/bugs/3430/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

--
Marc Dumontier
519-584-5601
http://oscardevel.com/wordpress/
http://www.oscarmcmaster.org