Crowd starts with error

Question

Hi,

When Crowd started, I'm getting SQL Constraint error as follows;

Caused by: java.sql.SQLException: Constraint already exists: FKAD5HDVSJWPAH0OJNR
AAQT2VQS in statement [
alter table SITEAPPROVAL
add constraint FKad5hdvsjwpah0ojnraaqt2vqs
foreign key (PROFILE_ID)
references PROFILE]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

Caused by: java.sql.SQLException: Constraint already exists: FKHB62I9MD6E0P9OPG5
7UYII4B3 in statement [
alter table SITEAPPROVAL
add constraint FKhb62i9md6e0p9opg57uyii4b3
foreign key (SITE_ID)
references SITE]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

Caused by: java.sql.SQLException: Constraint already exists: FKQAF1TEP0XTTUBL9E3
LKRM3FQK in statement [
alter table SITEAPPROVAL
add constraint FKqaf1tep0xttubl9e3lkrm3fqk
foreign key (USER_ID)
references OPENIDUSER]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

Please Help Us, Thanks in advance.

Christian Schlaefcke_9pmuqe · Answer

Hi @Gaurav, can you post the issue link, please?

Gaurav_x61rsc · Answer

Hi @BT-EGM ,

This is just harmless errors in Crowd, which you will see if you are running a version newer than 3.3.0.

This is something which you can ignore, there is a public-facing issue for this already to suppress this DDL error logs.

Thanks,

Gaurav