org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSmtpMailServers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.RuntimeException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT, socks_port, socks_host FROM mailserver ORDER BY ID asc (Invalid column name 'socks_port'.) at /secure/admin/views/smtpServers.vm line 5, column 18

Atlassian JIRA | Eric Dalgliesh | 5 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Copied from https://answers.atlassian.com/questions/74986/after-upgrade-incoming-and-outgoing-settings-page-has-errors After upgrading from 4.4 to 5.1.1 64-bit, Windows Server 2008R2 and SQL 2008, the INCOMING and OUTGOING pages for mail configuration will not work, and receive an error on the page. I have removed all of the old mail settings from the services page and checked the configuration files for anything regarding mail setup and have found nothing. the jirauser permissions in the SQL Database are DBA. I have checked all the things suggested by someone on the https://answers.atlassian.com/questions/72125/can-t-modify-incoming-mail-parameters-after-upgrade Below id the beginning of error message on the OUTGOING mail handler page: (On the INCOMING page, it says 'getPopMailServers' instead of getSmtpMailServers) If you would like the entire messages, let me know. {code} An error occurred whilst rendering this message. Please contact the administrators, and inform them of this bug. Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSmtpMailServers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.RuntimeException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT, socks_port, socks_host FROM mailserver ORDER BY ID asc (Invalid column name 'socks_port'.) at /secure/admin/views/smtpServers.vm line 5, column 18 at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262) at org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:470) at org.apache.velocity.runtime.parser.node.ASTNotNode.evaluate(ASTNotNode.java:63) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:62) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:85) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) at org.apache.velocity.runtime.directive.Parse.render(Parse.java:263) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) at org.apache.velocity.Template.merge(Template.java:328) at org.apache.velocity.Template.merge(Template.java:235) at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:381) at com.atlassian.velocity.DefaultVelocityManager.getEncodedBody(DefaultVelocityManager.java {code}

    Atlassian JIRA | 5 years ago | Eric Dalgliesh
    org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSmtpMailServers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.RuntimeException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT, socks_port, socks_host FROM mailserver ORDER BY ID asc (Invalid column name 'socks_port'.) at /secure/admin/views/smtpServers.vm line 5, column 18
  2. 0

    Copied from https://answers.atlassian.com/questions/74986/after-upgrade-incoming-and-outgoing-settings-page-has-errors After upgrading from 4.4 to 5.1.1 64-bit, Windows Server 2008R2 and SQL 2008, the INCOMING and OUTGOING pages for mail configuration will not work, and receive an error on the page. I have removed all of the old mail settings from the services page and checked the configuration files for anything regarding mail setup and have found nothing. the jirauser permissions in the SQL Database are DBA. I have checked all the things suggested by someone on the https://answers.atlassian.com/questions/72125/can-t-modify-incoming-mail-parameters-after-upgrade Below id the beginning of error message on the OUTGOING mail handler page: (On the INCOMING page, it says 'getPopMailServers' instead of getSmtpMailServers) If you would like the entire messages, let me know. {code} An error occurred whilst rendering this message. Please contact the administrators, and inform them of this bug. Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSmtpMailServers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.RuntimeException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT, socks_port, socks_host FROM mailserver ORDER BY ID asc (Invalid column name 'socks_port'.) at /secure/admin/views/smtpServers.vm line 5, column 18 at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262) at org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:470) at org.apache.velocity.runtime.parser.node.ASTNotNode.evaluate(ASTNotNode.java:63) at org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:62) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:85) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) at org.apache.velocity.runtime.directive.Parse.render(Parse.java:263) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) at org.apache.velocity.Template.merge(Template.java:328) at org.apache.velocity.Template.merge(Template.java:235) at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:381) at com.atlassian.velocity.DefaultVelocityManager.getEncodedBody(DefaultVelocityManager.java {code}

    Atlassian JIRA | 5 years ago | Eric Dalgliesh
    org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSmtpMailServers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.RuntimeException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT, socks_port, socks_host FROM mailserver ORDER BY ID asc (Invalid column name 'socks_port'.) at /secure/admin/views/smtpServers.vm line 5, column 18
  3. 0

    'java.lang.IllegalStateException: Bundle is uninstalled' error due to incompatible Add-on - Atlassian Documentation

    atlassian.com | 2 weeks ago
    org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getMailHandlers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.IllegalStateException: Bundle is uninstalled at /secure/admin/views/popServers.vm[line 90, column 19]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SAK-17623] NoClassDefFoundError : org/bouncycastle/jce/provider/BouncyCastleProviders - Sakai

    sakaiproject.org | 1 year ago
    org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSearchResult' in class org.sakaiproject.search.tool.SearchBeanImpl$3 threw exception class java.lang.NoClassDefFoundError : org/bouncycastle/jce/provider/BouncyCastleProvider
  6. 0

    The "hbm2java" subtask does not work when generics are set to "true" and it encounters a many-to-many mapping. -- from User.hbm.xml -- <set name="roles" lazy="true" cascade="none" table="user_role" > <key> <column name="user_id" /> </key> <many-to-many class="de.oraise.refinery.schema.Role" > <column name="role_id" /> </many-to-many> </set> -- -- from build.xml -- <target name="refinery.hbm2java"> <hibernatetool destdir="${src.java.dir}"> <configuration> <fileset dir="${src.java.dir}"> <include name="**/*.hbm.xml" /> </fileset> </configuration> <hbm2java generics="true"/> </hibernatetool> </target> -- -- Stacktrace org.hibernate.tool.hbm2x.ExporterException: Error while processing template pojo/javaclass.vm at org.hibernate.tool.hbm2x.TemplateHelper.processTemplate(TemplateHelper.java:85) at org.hibernate.tool.hbm2x.POJOExporter.runVelocity(POJOExporter.java:81) at org.hibernate.tool.hbm2x.POJOExporter.startPersistentClass(POJOExporter.java:52) at org.hibernate.tool.hbm2x.ConfigurationNavigator.export(ConfigurationNavigator.java:38) at org.hibernate.tool.ant.Hbm2JavaGeneratorTask.execute(Hbm2JavaGeneratorTask.java:39) at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:101) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:269) at org.apache.tools.ant.Task.perform(Task.java:364) at org.apache.tools.ant.Target.execute(Target.java:301) at org.apache.tools.ant.Target.performTasks(Target.java:328) at org.apache.tools.ant.Project.executeTarget(Project.java:1215) at org.apache.tools.ant.Project.executeTargets(Project.java:1063) at org.apache.tools.ant.Main.runBuild(Main.java:632) at org.apache.tools.ant.Main.startAnt(Main.java:183) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:197) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:56) Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getTypeName' in class org.hib ernate.tool.hbm2x.Cfg2JavaTool threw exception class org.hibernate.tool.hbm2x.ExporterException : Could not resolve type without exception for org.hibernate.mapping.Property(users) Value: org.hibernate.mapping.Set(de.oraise.refinery.schema. Role.users) Type: null at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:284) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:213) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:365) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:166) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:213) at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:258) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94) at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:204) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:152) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:94) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:109) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:269) at org.apache.velocity.Template.merge(Template.java:294) at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:488) at org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:457) at org.hibernate.tool.hbm2x.TemplateHelper.processTemplate(TemplateHelper.java:77) ... 15 more

    Hibernate JIRA | 1 decade ago | Michael Kötter
    org.hibernate.tool.hbm2x.ExporterException: Error while processing template pojo/javaclass.vm

    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.apache.velocity.exception.MethodInvocationException

      Invocation of method 'getSmtpMailServers' in class com.atlassian.jira.plugins.mail.webwork.ViewMailServers threw exception java.lang.RuntimeException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT, socks_port, socks_host FROM mailserver ORDER BY ID asc (Invalid column name 'socks_port'.) at /secure/admin/views/smtpServers.vm line 5, column 18

      at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute()
    2. Apache Velocity
      VelocityEngine.mergeTemplate
      1. org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223)
      2. org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262)
      3. org.apache.velocity.runtime.parser.node.ASTReference.evaluate(ASTReference.java:470)
      4. org.apache.velocity.runtime.parser.node.ASTNotNode.evaluate(ASTNotNode.java:63)
      5. org.apache.velocity.runtime.parser.node.ASTExpression.evaluate(ASTExpression.java:62)
      6. org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:85)
      7. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
      8. org.apache.velocity.runtime.directive.Parse.render(Parse.java:263)
      9. org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
      10. org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
      11. org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
      12. org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
      13. org.apache.velocity.Template.merge(Template.java:328)
      14. org.apache.velocity.Template.merge(Template.java:235)
      15. org.apache.velocity.app.VelocityEngine.mergeTemplate(VelocityEngine.java:381)
      15 frames