web stats

Mirth Connect

Channel messages cannot be viewed if day of month is greater than 12 (localization issue I pressume)

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.6.0
  • Fix Version/s: 1.8.2
  • Component/s: Administrator
  • Operating System:
    Other
  • Description:
    Hide
    when accessing to channel messages suddenly appears an error message with this description:

    om.webreach.mirth.client.core.ClientException: com.webreach.mirth.client.core.ClientException: method failed: HTTP/1.1 500 com.ibatis.common.jdbc.exception.NestedSQLException:
    --- The error occurred while applying a parameter map.
    --- Check the getMessageByPageLimit-InlineParameterMap.
    --- Check the statement (query failed).
    --- Cause: java.sql.SQLException: La conversi�n del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
    Caused by: java.sql.SQLException: La conversi�n del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
    com.webreach.mirth.client.core.MessageListHandler.getMessagesByPage(MessageListHandler.java:143)
    com.webreach.mirth.client.core.MessageListHandler.getFirstPage(MessageListHandler.java:96)
    com.webreach.mirth.client.ui.browsers.message.MessageBrowser.getMessageTableData(MessageBrowser.java:505)
    com.webreach.mirth.client.ui.browsers.message.MessageBrowser.access$1000(MessageBrowser.java:87)
    com.webreach.mirth.client.ui.browsers.message.MessageBrowser$1MessageWorker.doInBackground(MessageBrowser.java:1298)
    com.webreach.mirth.client.ui.browsers.message.MessageBrowser$1MessageWorker.doInBackground(MessageBrowser.java:1284)
    org.jdesktop.swingworker.SwingWorker$1.call(Unknown Source)
    java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    java.util.concurrent.FutureTask.run(Unknown Source)
    org.jdesktop.swingworker.SwingWorker.run(Unknown Source)
    java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    java.lang.Thread.run(Unknown Source)

    Translating from spanish, the cause is:

    La conversi�n del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
    Data type conversion from char to datetime produced a datetime value out of range.



    Show
    when accessing to channel messages suddenly appears an error message with this description: om.webreach.mirth.client.core.ClientException: com.webreach.mirth.client.core.ClientException: method failed: HTTP/1.1 500 com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the getMessageByPageLimit-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: La conversi�n del tipo de datos char a datetime produjo un valor datetime fuera de intervalo. Caused by: java.sql.SQLException: La conversi�n del tipo de datos char a datetime produjo un valor datetime fuera de intervalo. com.webreach.mirth.client.core.MessageListHandler.getMessagesByPage(MessageListHandler.java:143) com.webreach.mirth.client.core.MessageListHandler.getFirstPage(MessageListHandler.java:96) com.webreach.mirth.client.ui.browsers.message.MessageBrowser.getMessageTableData(MessageBrowser.java:505) com.webreach.mirth.client.ui.browsers.message.MessageBrowser.access$1000(MessageBrowser.java:87) com.webreach.mirth.client.ui.browsers.message.MessageBrowser$1MessageWorker.doInBackground(MessageBrowser.java:1298) com.webreach.mirth.client.ui.browsers.message.MessageBrowser$1MessageWorker.doInBackground(MessageBrowser.java:1284) org.jdesktop.swingworker.SwingWorker$1.call(Unknown Source) java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) org.jdesktop.swingworker.SwingWorker.run(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source) Translating from spanish, the cause is: La conversi�n del tipo de datos char a datetime produjo un valor datetime fuera de intervalo. Data type conversion from char to datetime produced a datetime value out of range.
  • Environment:
    Windows 2003 server SP2 SPANISH version

Activity

No work has yet been logged on this issue.

People

Dates

  • Created:
    27/Aug/07 4:00 PM
    Updated:
    05/Nov/09 12:44 PM
    Resolved:
    05/Nov/09 12:44 PM