java.sql.SQLException: Could not find prepared statement with handle 1.

jtds | torres4321 | 8 years ago
  1. 0

    Exception being thrown when using PreparedStatement.excute()

    jtds | 8 years ago | torres4321
    java.sql.SQLException: Could not find prepared statement with handle 1.
  2. 0

    hi....i have installed mirth2.1.0.5389. When i was deployed any channel i m getting following errors on server log....can anybody help me regarding this issue.... 1> [2011-05-10 12:24:53,777] ERROR (com.mirth.connect.server.controllers.MuleEngineController:230): Error unregistering channel after failed deploy. com.mirth.connect.server.controllers.ControllerException: error clearing templates at com.mirth.connect.server.controllers.DefaultTemplateController.removeTemplates(DefaultTemplateController.java:98) at com.mirth.connect.server.controllers.MuleEngineController.unregisterChannel(MuleEngineController.java:805) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:228) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the Template.deleteTemplate-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:480) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:74) at com.mirth.connect.server.controllers.DefaultTemplateController.removeTemplates(DefaultTemplateController.java:96) ... 26 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94) ... 31 more 2>[2011-05-10 12:24:53,761] ERROR (com.mirth.connect.server.controllers.MuleEngineController:219): Error registering channel. javax.management.InstanceAlreadyExistsException: MirthConfiguration:type=control,name=e7a071be-a21b-4829-892b-e730b7b63c06ComponentService at com.sun.jmx.mbeanserver.Repository.addMBean(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source) at org.mule.management.agents.JmxAgent.registerComponentService(JmxAgent.java:316) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:348) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) 3>[2011-05-10 12:24:53,746] ERROR (com.mirth.connect.server.controllers.MuleEngineController:341): Failed to configure outbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:180) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureOutboundRouter(MuleEngineController.java:531) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:339) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) ... 28 moreCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 4>[2011-05-10 12:24:53,746] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureOutboundRouter(MuleEngineController.java:531) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:339) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 more Caused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 5>[2011-05-10 12:24:53,667] ERROR (com.mirth.connect.server.controllers.MuleEngineController:334): Failed to configure inbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:180) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:425) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:332) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) ... 28 moreCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 6>[2011-05-10 12:24:53,667] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:425) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:332) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 more Caused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more

    Mirth Project | 6 years ago | vinayak bennur
    java.sql.SQLException: Invalid column name 'GROUP_ID'.
  3. 0

    hi....i have installed mirth2.1.0.5389. When i was deployed any channel i m getting following errors on server log....can anybody help me regarding this issue.... 1> [2011-05-10 12:24:53,777] ERROR (com.mirth.connect.server.controllers.MuleEngineController:230): Error unregistering channel after failed deploy. com.mirth.connect.server.controllers.ControllerException: error clearing templates at com.mirth.connect.server.controllers.DefaultTemplateController.removeTemplates(DefaultTemplateController.java:98) at com.mirth.connect.server.controllers.MuleEngineController.unregisterChannel(MuleEngineController.java:805) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:228) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the Template.deleteTemplate-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:457) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:480) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:74) at com.mirth.connect.server.controllers.DefaultTemplateController.removeTemplates(DefaultTemplateController.java:96) ... 26 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94) ... 31 more 2>[2011-05-10 12:24:53,761] ERROR (com.mirth.connect.server.controllers.MuleEngineController:219): Error registering channel. javax.management.InstanceAlreadyExistsException: MirthConfiguration:type=control,name=e7a071be-a21b-4829-892b-e730b7b63c06ComponentService at com.sun.jmx.mbeanserver.Repository.addMBean(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(Unknown Source) at org.mule.management.agents.JmxAgent.registerComponentService(JmxAgent.java:316) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:348) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) 3>[2011-05-10 12:24:53,746] ERROR (com.mirth.connect.server.controllers.MuleEngineController:341): Failed to configure outbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:180) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureOutboundRouter(MuleEngineController.java:531) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:339) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) ... 28 moreCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 4>[2011-05-10 12:24:53,746] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureOutboundRouter(MuleEngineController.java:531) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:339) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 more Caused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 5>[2011-05-10 12:24:53,667] ERROR (com.mirth.connect.server.controllers.MuleEngineController:334): Failed to configure inbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:180) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:425) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:332) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source)Caused by: com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) ... 28 moreCaused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 moreCaused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more 6>[2011-05-10 12:24:53,667] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.controllers.ControllerException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:85) at com.mirth.connect.server.mule.transformers.JavaScriptTransformer.initialise(JavaScriptTransformer.java:160) at org.mule.MuleManager.registerTransformer(MuleManager.java:567) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:425) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:332) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:206) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:475) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:929) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:403) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:864) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:114) at org.eclipse.jetty.server.Server.handle(Server.java:352) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:596) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1068) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:805) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:212) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:426) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:508) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access$000(SelectChannelEndPoint.java:34) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:451) at java.lang.Thread.run(Unknown Source) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'. at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82) at com.mirth.connect.server.controllers.DefaultTemplateController.getTemplate(DefaultTemplateController.java:83) ... 29 more Caused by: java.sql.SQLException: Invalid column name 'GROUP_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) ... 35 more

    Mirth Project | 6 years ago | vinayak bennur
    org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlserver/sqlserver-template.xml. --- The error occurred while applying a parameter map. --- Check the Template.getTemplate-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Invalid column name 'GROUP_ID'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    flyway:clean doesnt remove check constraint

    GitHub | 3 years ago | lrozek
    java.sql.SQLException: Cannot DROP FUNCTION 'dbo.CHECK_UNTERNEHMEN_OVERLAPPING_GFK' because it is being referenced by object 'U_C_UNTERNEHMEN_GFK_NUMMER'.
  6. 0

    SQL Server Unable to drop schema when functions exist

    GitHub | 3 years ago | flyway
    org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal com.googlecode.flyway:flyway-maven-plugin:2.1.1:clean (default-cli) on project sql-fod-flyway: Flyway Error: com.googlecode.flyway.core.api.FlywayException: Unable to clean schema [dbo]

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Could not find prepared statement with handle 1.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      JtdsPreparedStatement.execute
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
      6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
      7. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475)
      7 frames
    3. com.wachovia.cmg
      DBCallManager.main
      1. com.wachovia.cmg.base.DBCallManager.execute(DBCallManager.java:228)
      2. com.wachovia.cmg.base.DBCallManager.main(DBCallManager.java:515)
      2 frames