java.lang.RuntimeException

db-hibernate for PortalDb failed

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1208

  • via Unknown by Eric Dalquist,
  • via Unknown by Eric Dalquist,
  • via Unknown by Drew Wills,
  • Stack trace

    • java.lang.RuntimeException: db-hibernate for PortalDb failed at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:137) at org.jasig.portal.shell.PortalShellBuildHelper$hibernateCreate.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) at upshell_1583455373.run(upshell_1583455373.groovy:20) at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:257) at groovy.lang.GroovyShell.run(GroovyShell.java:220) at org.jasig.portal.shell.PortalShell.main(PortalShell.java:86) Caused by: java.lang.RuntimeException: Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:133) at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.create(DataSourceSchemaExport.java:102) at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:132) ... 8 more Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428) at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:127) ... 10 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length at sun.reflect.GeneratedConstructorAccessor149.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) at $Proxy173.execute(Unknown Source) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) ... 12 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    slashslash
    11 times, last one
    CasperCasper
    88 times, last one
    tvrmsmithtvrmsmith
    7 times, last one
    HronomHronom
    3 times, last one
    KialandeiKialandei
    13 times, last one
    113 more bugmates