After checking out fresh copy of uPortal-start and executing ./gradle portalInit I saw following error -[ant:java] CalendarPortlet: ERROR o.h.tool.hbm2ddl.SchemaExport Unsuccessful: alter table CALENDAR_CONFIGURATION add constraint FKF8F0C5957886B9ED foreign key (CALENDAR_ID) references CALENDAR_STORE[ant:java] CalendarPortlet: ERROR o.h.tool.hbm2ddl.SchemaExport a FOREIGN KEY constraint already exists on the set of columns: FKF8F0C5957886B9ED in statement [alter table CALENDAR_CONFIGURATION add constraint FKF8F0C5957886B9ED foreign key (CALENDAR_ID) references CALENDAR_STORE][ant:java] [ant:java] alter table CALENDAR_PARAMETER [ant:java] add constraint FKB05633C8BC98598B [ant:java] foreign key (CALENDAR_ID) [ant:java] references CALENDAR_STORE[ant:java] [ant:java] alter table CALENDAR_PREFERENCE [ant:java] add constraint FKE815407CCAE99FF9 [ant:java] foreign key (CALENDAR_CONFIGURATION_ID) [ant:java] references CALENDAR_CONFIGURATION[ant:java] [ant:java] alter table CALENDAR_ROLE [ant:java] add constraint FK30839CD73B30B1 [ant:java] foreign key (CALENDAR_ID) [ant:java] references CALENDAR_STORE[ant:java] CalendarPortlet: INFO o.h.tool.hbm2ddl.SchemaExport schema export complete[ant:java] CalendarPortlet: ERROR o.j.p.calendar.util.SchemaCreator Schema Create Failed; see below for details[ant:java] CalendarPortlet: ERROR o.j.p.calendar.util.SchemaCreator Exception from Hibernate Tools SchemaExport[ant:java] java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FKF8F0C5957886B9ED[ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:308) ~[hibernate-3.2.3.ga.jar:3.2.3.ga][ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:284) ~[hibernate-3.2.3.ga.jar:3.2.3.ga][ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:186) ~[hibernate-3.2.3.ga.jar:3.2.3.ga][ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.create(SchemaCreator.java:86) [classes/:na][ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.main(SchemaCreator.java:64) [classes/:na][ant:java] CalendarPortlet: ERROR o.j.p.calendar.util.SchemaCreator Exception from Hibernate Tools SchemaExport[ant:java] java.sql.SQLSyntaxErrorException: a FOREIGN KEY constraint already exists on the set of columns: FKF8F0C5957886B9ED in statement [alter table CALENDAR_CONFIGURATION add constraint FKF8F0C5957886B9ED foreign key (CALENDAR_ID) references CALENDAR_STORE][ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2][ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:308) ~[hibernate-3.2.3.ga.jar:3.2.3.ga][ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:267) ~[hibernate-3.2.3.ga.jar:3.2.3.ga][ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:190) ~[hibernate-3.2.3.ga.jar:3.2.3.ga][ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.create(SchemaCreator.java:86) [classes/:na][ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.main(SchemaCreator.java:64) [classes/:na][ant:java] CalendarPortlet: INFO o.hibernate.impl.SessionFactoryImpl closing[ant:java] Fix it please.
After checking out fresh copy of uPortal-start and executing ./gradle portalInit I saw following error -
[ant:java] CalendarPortlet: ERROR o.h.tool.hbm2ddl.SchemaExport Unsuccessful: alter table CALENDAR_CONFIGURATION add constraint FKF8F0C5957886B9ED foreign key (CALENDAR_ID) references CALENDAR_STORE
[ant:java] CalendarPortlet: ERROR o.h.tool.hbm2ddl.SchemaExport a FOREIGN KEY constraint already exists on the set of columns: FKF8F0C5957886B9ED in statement [alter table CALENDAR_CONFIGURATION add constraint FKF8F0C5957886B9ED foreign key (CALENDAR_ID) references CALENDAR_STORE]
[ant:java]
[ant:java] alter table CALENDAR_PARAMETER
[ant:java] add constraint FKB05633C8BC98598B
[ant:java] foreign key (CALENDAR_ID)
[ant:java] references CALENDAR_STORE
[ant:java]
[ant:java] alter table CALENDAR_PREFERENCE
[ant:java] add constraint FKE815407CCAE99FF9
[ant:java] foreign key (CALENDAR_CONFIGURATION_ID)
[ant:java] references CALENDAR_CONFIGURATION
[ant:java]
[ant:java] alter table CALENDAR_ROLE
[ant:java] add constraint FK30839CD73B30B1
[ant:java] foreign key (CALENDAR_ID)
[ant:java] references CALENDAR_STORE
[ant:java] CalendarPortlet: INFO o.h.tool.hbm2ddl.SchemaExport schema export complete
[ant:java] CalendarPortlet: ERROR o.j.p.calendar.util.SchemaCreator Schema Create Failed; see below for details
[ant:java] CalendarPortlet: ERROR o.j.p.calendar.util.SchemaCreator Exception from Hibernate Tools SchemaExport
[ant:java] java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FKF8F0C5957886B9ED
[ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:308) ~[hibernate-3.2.3.ga.jar:3.2.3.ga]
[ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:284) ~[hibernate-3.2.3.ga.jar:3.2.3.ga]
[ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:186) ~[hibernate-3.2.3.ga.jar:3.2.3.ga]
[ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.create(SchemaCreator.java:86) [classes/:na]
[ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.main(SchemaCreator.java:64) [classes/:na]
[ant:java] CalendarPortlet: ERROR o.j.p.calendar.util.SchemaCreator Exception from Hibernate Tools SchemaExport
[ant:java] java.sql.SQLSyntaxErrorException: a FOREIGN KEY constraint already exists on the set of columns: FKF8F0C5957886B9ED in statement [alter table CALENDAR_CONFIGURATION add constraint FKF8F0C5957886B9ED foreign key (CALENDAR_ID) references CALENDAR_STORE]
[ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) ~[hsqldb-2.3.2.jar:2.3.2]
[ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:308) ~[hibernate-3.2.3.ga.jar:3.2.3.ga]
[ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:267) ~[hibernate-3.2.3.ga.jar:3.2.3.ga]
[ant:java] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:190) ~[hibernate-3.2.3.ga.jar:3.2.3.ga]
[ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.create(SchemaCreator.java:86) [classes/:na]
[ant:java] at org.jasig.portlet.calendar.util.SchemaCreator.main(SchemaCreator.java:64) [classes/:na]
[ant:java] CalendarPortlet: INFO o.hibernate.impl.SessionFactoryImpl closing
[ant:java]
Fix it please.