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

Christopher Lang made changes - 28/Aug/07 3:09 AM
Field Original Value New Value
Assignee Christopher Lang [ chrisl ] Jacob Brauer [ jacobb ]
Christopher Lang made changes - 28/Aug/07 3:09 AM
Fix Version/s 1.6.1 [ 10070 ]
Christopher Lang made changes - 28/Aug/07 11:25 AM
Fix Version/s 1.7.0 [ 10071 ]
Fix Version/s 1.6.1 [ 10070 ]
Jacob Brauer made changes - 14/Nov/07 10:56 AM
Fix Version/s 2.0.0 [ 10056 ]
Fix Version/s 1.7.0 [ 10071 ]
Jacob Brauer made changes - 04/Nov/08 1:30 PM
Fix Version/s 1.8.1 [ 10131 ]
Fix Version/s 2.0.0 [ 10056 ]
Jacob Brauer made changes - 15/May/09 1:43 PM
Fix Version/s 1.8.2 [ 10140 ]
Fix Version/s 1.8.1 [ 10131 ]
Jacob Brauer made changes - 24/Sep/09 10:40 AM
Fix Version/s 1.8.2 [ 10140 ]
Status Open [ 1 ] Closed [ 6 ]
Resolution Won't Fix [ 2 ]
Jacob Brauer made changes - 05/Nov/09 12:43 PM
Resolution Won't Fix [ 2 ]
Status Closed [ 6 ] Reopened [ 4 ]
Jacob Brauer made changes - 05/Nov/09 12:44 PM
Status Reopened [ 4 ] Resolved [ 5 ]
Fix Version/s 1.8.2 [ 10140 ]
Resolution Fixed [ 1 ]

People

Dates

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