Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.6.0
-
Fix Version/s: 1.8.2
-
Component/s: Administrator
-
Labels:None
-
Environment:Windows 2003 server SP2 SPANISH version
-
Operating System:Other
Description
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.
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.