We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

Cannot view Discrepancy Notes:NumberFormatException

Hi Michael,
Yes, that's it, thanks alot! My "Oops!" screen appears on CRFs that hasn't
been SDV'ed yet, but they do have DN's on Interviewer name and Interview
date.
What to do about this? I need a quick fix :)
Best,
Janus

Michael Bluett
To
Sent by: "[email protected]"
developers-bounce
[email protected] cc

Subject
17-09-2012 16:33 Re: [Developers] Cannot view
Discrepancy
Notes:NumberFormatException
Please respond to
[email protected]
inica.org



Dear Janus,
Does it seem related to:
https://issuetracker.openclinica.com/view.php?id=14152
(found via search for NumberFormatException)? If so, you could add that you
are also suffering from it.
Yours,
Michael
[mailto:[email protected]] On Behalf Of Janus Engstrøm
Sent: 17 September 2012 15:14
To: [email protected]; [email protected]
Subject: [Developers] Cannot view Discrepancy Notes: NumberFormatException
Hi,
When I click View button on the Notes & Discrepancies, I get an "Oops!"
error message in the popup window.
I checked the log, and it seems like OpenClinica fails to perform the task
due to a NumberFormatException when trying to get an integer out of the
value "false":
09/17 16:00:26 [OpenClinica] AUTHPRIV INFO root
o.a.o.dao.admin.AuditDAO:226 - Executing dynamic query,
EntityDAO.select:query SELECT ale.audit_id, ale.audit_date,
ale.audit_table, ale.user_id, ale.entity_id,
ale.entity_name, ale.reason_for_change,
ale.audit_log_event_type_id, ale.old_value,
ale.new_value, ale.event_crf_id, ua.user_name, alet.name
FROM audit_log_event ale JOIN user_account ua ON
ale.user_id=ua.user_id
JOIN audit_log_event_type alet ON
ale.audit_log_event_type_id=alet.audit_log_event_type_id
WHERE ale.entity_id = ? and ale.audit_table = ?
09/17 16:00:26 [OpenClinica] USER ERROR root
o.a.o.c.s.ViewDiscrepancyNoteServlet:578 - java.lang.NumberFormatException:
For input string: "false"
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.(Integer.java:677)
at
org.akaza.openclinica.dao.admin.AuditDAO.findItemAuditEvents(AuditDAO.java:397)
at
org.akaza.openclinica.control.submit.ViewDiscrepancyNoteServlet.processRequest(ViewDiscrepancyNoteServlet.java:679)
[...]
I include the log file beginning at a server restart up to the click to the
View button. It this a know bug? It's pretty important I find a solution to
this, as the problem exists on a production server! I do not know if the
problem has suddenly arisen or has been there always, as the installation
is pretty new and this is the first use of the monitoring role.
Best regards,
Janus
The University of Dundee is a registered Scottish Charity, No: SC015096

Comments

  • JanusJanus Posts: 260
    Ok, looked a bit into the database... in the audit_log_event there is an
    entry for (one of the) problematic CRFs, where the EventCRF SDV Status goes
    from false to true: old_value = false, new_value = true. But then the
    AuditDAO reads this entry and incorrectly tries to parse the false/true
    values as integers.

    Michael Bluett
    To
    Sent by: "[email protected]"
    developers-bounce
    [email protected] cc

    Subject
    17-09-2012 16:33 Re: [Developers] Cannot view
    Discrepancy
    Notes:NumberFormatException
    Please respond to
    [email protected]
    inica.org



    Dear Janus,
    Does it seem related to:
    https://issuetracker.openclinica.com/view.php?id=14152
    (found via search for NumberFormatException)? If so, you could add that you
    are also suffering from it.
    Yours,
    Michael
    [mailto:[email protected]] On Behalf Of Janus Engstrøm
    Sent: 17 September 2012 15:14
    To: [email protected]; [email protected]
    Subject: [Developers] Cannot view Discrepancy Notes: NumberFormatException
    Hi,
    When I click View button on the Notes & Discrepancies, I get an "Oops!"
    error message in the popup window.
    I checked the log, and it seems like OpenClinica fails to perform the task
    due to a NumberFormatException when trying to get an integer out of the
    value "false":
    09/17 16:00:26 [OpenClinica] AUTHPRIV INFO root
    o.a.o.dao.admin.AuditDAO:226 - Executing dynamic query,
    EntityDAO.select:query SELECT ale.audit_id, ale.audit_date,
    ale.audit_table, ale.user_id, ale.entity_id,
    ale.entity_name, ale.reason_for_change,
    ale.audit_log_event_type_id, ale.old_value,
    ale.new_value, ale.event_crf_id, ua.user_name, alet.name
    FROM audit_log_event ale JOIN user_account ua ON
    ale.user_id=ua.user_id
    JOIN audit_log_event_type alet ON
    ale.audit_log_event_type_id=alet.audit_log_event_type_id
    WHERE ale.entity_id = ? and ale.audit_table = ?
    09/17 16:00:26 [OpenClinica] USER ERROR root
    o.a.o.c.s.ViewDiscrepancyNoteServlet:578 - java.lang.NumberFormatException:
    For input string: "false"
    at
    java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:492)
    at java.lang.Integer.(Integer.java:677)
    at
    org.akaza.openclinica.dao.admin.AuditDAO.findItemAuditEvents(AuditDAO.java:397)
    at
    org.akaza.openclinica.control.submit.ViewDiscrepancyNoteServlet.processRequest(ViewDiscrepancyNoteServlet.java:679)
    [...]
    I include the log file beginning at a server restart up to the click to the
    View button. It this a know bug? It's pretty important I find a solution to
    this, as the problem exists on a production server! I do not know if the
    problem has suddenly arisen or has been there always, as the installation
    is pretty new and this is the first use of the monitoring role.
    Best regards,
    Janus
    The University of Dundee is a registered Scottish Charity, No: SC015096
  • JanusJanus Posts: 260
    And here is the solution:
    Edit the audit_log_event entries concerning EventCRF SDV Status (audti_log_event_type_id = 32) from "false" to 0 and from "true" to 1. The audit log still informs of boolean values concerning the SDV status, but now it's not "true" and "false", but "TRUE" and "FALSE" (uppercase).
    Now, please correct the AuditLogEntryDAO to write 0 and 1 instead of "true" and "false" and send me a copy :)
    Best,
    Janus
    Janus Engstrøm
    Sent by: [email protected]
    18-09-2012 01:21
    Please respond to
    [email protected]

    To
    [email protected]
    cc

    Subject
    Re: [Developers] Cannot view Discrepancy Notes:NumberFormatException

    Ok, looked a bit into the database... in the audit_log_event there is an
    entry for (one of the) problematic CRFs, where the EventCRF SDV Status goes
    from false to true: old_value = false, new_value = true. But then the
    AuditDAO reads this entry and incorrectly tries to parse the false/true
    values as integers.

    Michael Bluett
    To
    Sent by: "[email protected]"
    developers-bounce
    [email protected] cc

    Subject
    17-09-2012 16:33 Re: [Developers] Cannot view
    Discrepancy
    Notes:NumberFormatException
    Please respond to
    [email protected]
    inica.org



    Dear Janus,
    Does it seem related to:
    https://issuetracker.openclinica.com/view.php?id=14152
    (found via search for NumberFormatException)? If so, you could add that you
    are also suffering from it.
    Yours,
    Michael
    [mailto:[email protected]] On Behalf Of Janus Engstrøm
    Sent: 17 September 2012 15:14
    To: [email protected]; [email protected]
    Subject: [Developers] Cannot view Discrepancy Notes: NumberFormatException
    Hi,
    When I click View button on the Notes & Discrepancies, I get an "Oops!"
    error message in the popup window.
    I checked the log, and it seems like OpenClinica fails to perform the task
    due to a NumberFormatException when trying to get an integer out of the
    value "false":
    09/17 16:00:26 [OpenClinica] AUTHPRIV INFO root
    o.a.o.dao.admin.AuditDAO:226 - Executing dynamic query,
    EntityDAO.select:query SELECT ale.audit_id, ale.audit_date,
    ale.audit_table, ale.user_id, ale.entity_id,
    ale.entity_name, ale.reason_for_change,
    ale.audit_log_event_type_id, ale.old_value,
    ale.new_value, ale.event_crf_id, ua.user_name, alet.name
    FROM audit_log_event ale JOIN user_account ua ON
    ale.user_id=ua.user_id
    JOIN audit_log_event_type alet ON
    ale.audit_log_event_type_id=alet.audit_log_event_type_id
    WHERE ale.entity_id = ? and ale.audit_table = ?
    09/17 16:00:26 [OpenClinica] USER ERROR root
    o.a.o.c.s.ViewDiscrepancyNoteServlet:578 - java.lang.NumberFormatException:
    For input string: "false"
    at
    java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:492)
    at java.lang.Integer.(Integer.java:677)
    at
    org.akaza.openclinica.dao.admin.AuditDAO.findItemAuditEvents(AuditDAO.java:397)
    at
    org.akaza.openclinica.control.submit.ViewDiscrepancyNoteServlet.processRequest(ViewDiscrepancyNoteServlet.java:679)
    [...]
    I include the log file beginning at a server restart up to the click to the
    View button. It this a know bug? It's pretty important I find a solution to
    this, as the problem exists on a production server! I do not know if the
    problem has suddenly arisen or has been there always, as the installation
    is pretty new and this is the first use of the monitoring role.
    Best regards,
    Janus
    The University of Dundee is a registered Scottish Charity, No: SC015096
This discussion has been closed.