I am getting the same thing now. We need to role back the SQL logic to
the point before the M1 release when this was not an issue.
Randy Watler wrote:
David/Ate/Scott,
While executing the M1 scripts for DB configuration of MS SQL Server
2K, I ended up with these errors:
db.execute:
[echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
[sql] Executing file:
/usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security-schema.sql
[sql] Failed to execute: BEGIN ALTER TABLE
SSO_PRINCIPAL_TO_REMOTE ADD CONSTRAINT SSO_PRINCIPAL_TO_REMOTE_FK_2
FOREIGN KEY (REMOTE_PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL
(PRINCIPAL_ID) ON DELETE CASCADE END
BUILD FAILED
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The
following error occurred while executing this line:
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:
java.sql.SQLException: Introducing FOREIGN KEY constraint
'SSO_PRINCIPAL_TO_REMOTE_FK_2' on table 'SSO_PRINCIPAL_TO_REMOTE' may
cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or
ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
----------------------------------------------------------------------------------------------------------
db.execute:
[echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
[sql] Executing file:
/usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security-schema.sql
[sql] Failed to execute: BEGIN ALTER TABLE SECURITY_USER_ROLE
ADD CONSTRAINT SECURITY_USER_ROLE_FK_2 FOREIGN KEY (USER_ID)
REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON DELETE CASCADE END
BUILD FAILED
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The
following error occurred while executing this line:
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:
java.sql.SQLException: Introducing FOREIGN KEY constraint
'SECURITY_USER_ROLE_FK_2' on table 'SECURITY_USER_ROLE' may cause
cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON
UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
----------------------------------------------------------------------------------------------------------
db.execute:
[echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
[sql] Executing file:
/usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security-schema.sql
[sql] Failed to execute: BEGIN ALTER TABLE SECURITY_USER_GROUP
ADD CONSTRAINT SECURITY_USER_GROUP_FK_2 FOREIGN KEY (USER_ID)
REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON DELETE CASCADE END
BUILD FAILED
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The
following error occurred while executing this line:
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:
java.sql.SQLException: Introducing FOREIGN KEY constraint
'SECURITY_USER_GROUP_FK_2' on table 'SECURITY_USER_GROUP' may cause
cycles or multiple cascade paths. Specify ON DELETE NO ACTION or
ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
----------------------------------------------------------------------------------------------------------
db.execute:
[echo] Executing scripts for ./sql/DDL/mssql/security-schema.sql
[sql] Executing file:
/usr/share/tomcat5/jetspeed-database/scripts/sql/DDL/mssql/security-schema.sql
[sql] Failed to execute: BEGIN ALTER TABLE SECURITY_GROUP_ROLE
ADD CONSTRAINT SECURITY_GROUP_ROLE_FK_2 FOREIGN KEY (ROLE_ID)
REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON DELETE CASCADE END
BUILD FAILED
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:64: The
following error occurred while executing this line:
/usr/share/tomcat5/jetspeed-database/scripts/build.xml:38:
java.sql.SQLException: Introducing FOREIGN KEY constraint
'SECURITY_GROUP_ROLE_FK_2' on table 'SECURITY_GROUP_ROLE' may cause
cycles or multiple cascade paths. Specify ON DELETE NO ACTION or
ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
I worked around this by patching the constraints setting them to
"DELETE NO ACTION", but I have not attempted to diagnose or fix this
issue for real. Anyone else seen these errors?
Randy
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
"Great minds discuss ideas. Average minds discuss events. Small minds discuss
people." - Admiral Hyman Rickover
*******************************************
* Scott T. Weaver *
* <[EMAIL PROTECTED]> *
* <http://www.einnovation.com> *
* -------------------------------------- *
* Apache Jetspeed Enterprise Portal *
* Apache Pluto Portlet Container *
* *
* OpenEdit, Website Content Management *
* <http://www.openedit.org> *
*******************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
