Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 4th, 2012  |  syntax: None  |  size: 5.98 KB  |  hits: 5  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.     [java]  INFO Created new lazily initialized GenericApplicationContext for the portal in 21427ms
  2.      [java]  INFO
  3.      [java]  INFO
  4.      [java]  INFO Running DbLoader with: DbLoaderConfigBuilder[tablesFile=/properties/db/tables.xml,dataFile=/properties/db/data.xml,scriptFile=<null>,dropTables=true,createTables=true,populateTables=true]
  5.      [java]  INFO HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
  6.      [java]  INFO Resolved Hibernate Dialect: org.hibernate.dialect.PostgreSQLDialect
  7.      [java]  INFO Dropping existing tables
  8.      [java]  INFO drop table if exists UP_USER cascade
  9.      [java] Exception in thread "main" java.lang.RuntimeException: db for /properties/db/tables.xml and /properties/db/data.xml failed
  10.      [java]     at s INFO drop table if exists UP_USER_LOCALE cascade
  11.      [java]  INFO drop table if exists UP_PERMISSION cascade
  12.      [java]  INFO drop table if exists UPun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  13.      [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
  14.      [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
  15.      [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
  16.      [java]     at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77)
  17.      [java]     at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102)
  18.      [java]     at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54)
  19.      [java]     at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182)
  20.      [java]     at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194)
  21.      [java]     at upshell_12230179.run(upshell_12230179.groovy:27)
  22.      [java]     at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266)
  23.      [java]     at groovy.lang.GroovyShell.run(GroovyShell.java:229)
  24.      [java]     at org.jasig.portal.shell.PortalShell.main(PortalShell.java:84)
  25.      [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table UP_USER (USER_ID int4 not null, USER_NAME varchar(35), USER_DFLT_USR_ID int4, USER_DFLT_LAY_ID int4, NEXT_STRUCT_ID int4, LST_CHAN_UPDT_DT timestamp, primary key (USER_ID), unique (USER_NAME))]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "up_user" already exists
  26.      [java]     at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
  27.      [java]     at org.springframework.jdbc.s_USER_LAYOUT cascade
  28.      [java]  INFO drop table if exists UP_LAYOUT_STRUCT cascade
  29.      [java]  INFO drop table if exists UP_LAYOUT_PARAM cascade
  30.      [java]  INFO drop table if exists UP_SEQUENCE cascade
  31.      [java]  INFO drop table if exists UP_USER_PROFILE cascade
  32.      [java]  INFO drop table if exists UP_GROUP cascade
  33.      [java]  INFO drop table if exists UP_ENTITY_TYPE cascade
  34.      [java]  INFO drop table if exists UP_GROUP_MEMBERSHIP cascade
  35.      [java]  INFO drop table if exists UP_ENTITY_CACHE_INVALIDATION cascade
  36.      [java]  INFO drop table if exists UP_ENTITY_LOCK cascade
  37.      [java]  INFO drop table if exists UP_ENTITY_PROP cascade
  38.      [java]  INFO Creating tables
  39.      [java]  INFO create table UP_USER (USER_ID int4 not null, USER_NAME varchar(35), USER_DFLT_USR_ID int4, USER_DFLT_LAY_ID int4, NEXT_STRUCT_ID int4, LST_CHAN_UPDT_DT timestamp, primary key (USER_ID), unique (USER_NAME))
  40.      [java] upport.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  41.      [java]     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  42.      [java]     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
  43.      [java]     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  44.      [java]     at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:519)
  45.      [java]     at org.jasig.portal.tools.dbloader.HibernateDbLoader.process(HibernateDbLoader.java:182)
  46.      [java]     at org.jasig.portal.tools.dbloader.IDbLoader$process.call(Unknown Source)
  47.      [java]     at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42)
  48.      [java]     at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)
  49.      [java]     at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
  50.      [java]     at upshell_12230179.run(upshell_12230179.groovy:24)
  51.      [java]     ... 3 more
  52.      [java] Caused by: org.postgresql.util.PSQLException: ERROR: relation "up_user" already exists
  53.      [java]     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
  54.      [java]     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
  55.      [java]     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
  56.      [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
  57.      [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
  58.      [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
  59.      [java]     at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
  60.      [java]     at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
  61.      [java]     at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:509)
  62.      [java]     at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:1)
  63.      [java]     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  64.      [java]     ... 10 more
create a new version of this paste RAW Paste Data