web stats
Mirth Community - View Single Post - Error: Unable to update statistics - Azure SQL Server
View Single Post
  #1  
Old 04-29-2019, 11:59 AM
SeanT SeanT is offline
What's HL7?
 
Join Date: Apr 2019
Posts: 2
SeanT is on a distinguished road
Default Error: Unable to update statistics - Azure SQL Server

Hi all, I Recently moved from Darby to Azure SQL Server, everything seems to be working ,but getting this persistent error message.

Running: Mirth Connect 3.4.2.8129

Quote:
[2019-04-29 19:45:53,311] ERROR (com.mirth.connect.donkey.server.data.DonkeyStatis ticsUpdater:112): Unable to update statistics.
com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find prepared statement with handle 20.
at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. updateStatistics(JdbcDao.java:435)
at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. addChannelStatistics(JdbcDao.java:358)
at com.mirth.connect.donkey.server.data.DonkeyStatist icsUpdater.commit(DonkeyStatisticsUpdater.java:87)
at com.mirth.connect.donkey.server.data.DonkeyStatist icsUpdater.run(DonkeyStatisticsUpdater.java:52)Cau sed by: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find prepared statement with handle 20.
at com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDatabaseError(SQLServerException.java:254)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ge tNextResult(SQLServerStatement.java:1608)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.doExecutePreparedStatement(SQLServerPrepared Statement.java:578)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement$PrepStmtExecCmd.doExecute(SQLServerPreparedS tatement.java:508)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IO Buffer.java:7240)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.e xecuteCommand(SQLServerConnection.java:2869)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ex ecuteCommand(SQLServerStatement.java:243)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.ex ecuteStatement(SQLServerStatement.java:218)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.executeUpdate(SQLServerPreparedStatement.jav a:461)
at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. updateStatistics(JdbcDao.java:414)
... 3 more

Last edited by SeanT; 04-30-2019 at 12:34 PM.
Reply With Quote