org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: invalid return (5f03ca21-35b2-411f-bb79-26ab956dab6d#791)

Mirth Project | Johnson Dea | 4 years ago
  1. 0

    There was a problem deploying channels and the errors below popped up and the deploy failed. We narrowed it down to a code template, comment line in Javascript. "//}" After we removed that line, it was able to deploy channels again, it was the last line, but there are still comments before it. Here is what the comment looked like in the code template: // var outString = new String(mString); // var padLength = new Number(mLength); // if (outString=='null'){ // outString='' // } // while( outString.length<padLength) // { // outString = ' ' + outString; // } // if // return outString; //} // write code here. //} The errors in deploy seemed to only occur in channels with transformers, even ones that didn't call any templates. The comments will work if /* and */ is used instead. ERROR 1: [2012-08-14 17:35:27,272] ERROR (com.mirth.connect.server.controllers.MuleEngineController:376): Failed to configure outbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: invalid return (5f03ca21-35b2-411f-bb79-26ab956dab6d#791) at com.mirth.connect.connectors.js.JavaScriptConnector.initFromServiceDescriptor(JavaScriptConnector.java:69) at org.mule.providers.AbstractServiceEnabledConnector.doInitialise(AbstractServiceEnabledConnector.java:54) ........ ERROR 2: [2012-08-14 17:36:48,230] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.MirthJavascriptTransformerException: CONNECTOR: TransactionLogger SCRIPT SOURCE: Filter/Transformer LINE NUMBER: 799 LINE SOURCE: } DETAILS: syntax error ERROR 3: [2012-08-14 17:36:48,204] ERROR (com.mirth.connect.server.controllers.MuleEngineController:369): Failed to configure inbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: CONNECTOR: sourceConnectorSCRIPT SOURCE: Filter/TransformerLINE NUMBER: 827LINE SOURCE: }DETAILS: syntax error

    Mirth Project | 4 years ago | Johnson Dea
    org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: invalid return (5f03ca21-35b2-411f-bb79-26ab956dab6d#791)
  2. 0

    There was a problem deploying channels and the errors below popped up and the deploy failed. We narrowed it down to a code template, comment line in Javascript. "//}" After we removed that line, it was able to deploy channels again, it was the last line, but there are still comments before it. Here is what the comment looked like in the code template: // var outString = new String(mString); // var padLength = new Number(mLength); // if (outString=='null'){ // outString='' // } // while( outString.length<padLength) // { // outString = ' ' + outString; // } // if // return outString; //} // write code here. //} The errors in deploy seemed to only occur in channels with transformers, even ones that didn't call any templates. The comments will work if /* and */ is used instead. ERROR 1: [2012-08-14 17:35:27,272] ERROR (com.mirth.connect.server.controllers.MuleEngineController:376): Failed to configure outbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: invalid return (5f03ca21-35b2-411f-bb79-26ab956dab6d#791) at com.mirth.connect.connectors.js.JavaScriptConnector.initFromServiceDescriptor(JavaScriptConnector.java:69) at org.mule.providers.AbstractServiceEnabledConnector.doInitialise(AbstractServiceEnabledConnector.java:54) ........ ERROR 2: [2012-08-14 17:36:48,230] ERROR (com.mirth.connect.server.mule.transformers.JavaScriptTransformer:179): ERROR-300: Transformer error com.mirth.connect.server.MirthJavascriptTransformerException: CONNECTOR: TransactionLogger SCRIPT SOURCE: Filter/Transformer LINE NUMBER: 799 LINE SOURCE: } DETAILS: syntax error ERROR 3: [2012-08-14 17:36:48,204] ERROR (com.mirth.connect.server.controllers.MuleEngineController:369): Failed to configure inbound router. org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: CONNECTOR: sourceConnectorSCRIPT SOURCE: Filter/TransformerLINE NUMBER: 827LINE SOURCE: }DETAILS: syntax error

    Mirth Project | 4 years ago | Johnson Dea
    org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: invalid return (5f03ca21-35b2-411f-bb79-26ab956dab6d#791)
  3. 0

    I am trying to read from ActiveMQ queue. JMS Reader settings Use JNDI: No Connection Factory Class: org.apache.activemq.ActiveMQConnectionFactory Destination: testQueue Produces the following error: ERROR (com.mirth.connect.server.controllers.MuleEngineController:316): Failed to configure inbound router. org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrategy" failed to reconnect receiver on endpoint "com.mirth.connect.connectors.jms.JmsConnector@109851a" at org.mule.providers.SingleAttemptConnectionStrategy.doConnect(SingleAttemptConnectionStrategy.java:34) at org.mule.providers.AbstractConnectionStrategy.connect(AbstractConnectionStrategy.java:67) at org.mule.providers.AbstractConnector.startConnector(AbstractConnector.java:252) at org.mule.MuleManager.registerConnector(MuleManager.java:497) at com.mirth.connect.server.controllers.MuleEngineController.registerConnector(MuleEngineController.java:668) at com.mirth.connect.server.controllers.MuleEngineController.configureInboundRouter(MuleEngineController.java:440) at com.mirth.connect.server.controllers.MuleEngineController.registerChannel(MuleEngineController.java:314) at com.mirth.connect.server.controllers.MuleEngineController.deployChannels(MuleEngineController.java:201) at com.mirth.connect.server.servlets.EngineServlet.doPost(EngineServlet.java:46) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)Caused by: org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrategy" failed to reconnect receiver on endpoint "com.mirth.connect.connectors.jms.JmsConnector@109851a" at org.mule.providers.SingleAttemptConnectionStrategy.doConnect(SingleAttemptConnectionStrategy.java:34) at org.mule.providers.AbstractConnectionStrategy.connect(AbstractConnectionStrategy.java:67) at org.mule.providers.AbstractConnector.connect(AbstractConnector.java:774) at org.mule.providers.SingleAttemptConnectionStrategy.doConnect(SingleAttemptConnectionStrategy.java:32) ... 22 moreCaused by: org.mule.providers.ConnectException: Initialisation Failure: Initialisation Failure: org.apache.activemq.ActiveMQConnectionFactory at com.mirth.connect.connectors.jms.JmsConnector.doConnect(JmsConnector.java:256) at org.mule.providers.AbstractConnector.connect(AbstractConnector.java:780) at org.mule.providers.SingleAttemptConnectionStrategy.doConnect(SingleAttemptConnectionStrategy.java:32) ... 25 moreCaused by: org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: org.apache.activemq.ActiveMQConnectionFactory at com.mirth.connect.connectors.jms.JmsConnector.createConnectionFactory(JmsConnector.java:185) at com.mirth.connect.connectors.jms.JmsConnector.createConnection(JmsConnector.java:202) at com.mirth.connect.connectors.jms.JmsConnector.doConnect(JmsConnector.java:251) ... 27 moreCaused by: java.lang.ClassNotFoundException: org.apache.activemq.ActiveMQConnectionFactory at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at com.mirth.connect.connectors.jms.JmsConnector.createConnectionFactory(JmsConnector.java:172) Where does it look for connectionFactory classes? Is it possible to specify a path to the class within connection factory class settings?

    Mirth Project | 6 years ago | mikhail reyderman
    org.mule.umo.lifecycle.InitialisationException: Initialisation Failure: org.apache.activemq.ActiveMQConnectionFactory
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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'.
  6. 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'.

    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. org.mule.umo.lifecycle.InitialisationException

      Initialisation Failure: invalid return (5f03ca21-35b2-411f-bb79-26ab956dab6d#791)

      at com.mirth.connect.connectors.js.JavaScriptConnector.initFromServiceDescriptor()
    2. com.mirth.connect
      JavaScriptConnector.initFromServiceDescriptor
      1. com.mirth.connect.connectors.js.JavaScriptConnector.initFromServiceDescriptor(JavaScriptConnector.java:69)
      1 frame
    3. org.mule.providers
      AbstractServiceEnabledConnector.doInitialise
      1. org.mule.providers.AbstractServiceEnabledConnector.doInitialise(AbstractServiceEnabledConnector.java:54)
      1 frame