· 7 years ago · Sep 07, 2018, 09:27 PM
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