JetSpeed2 Installation Problem

["Redman, Greg" <gr...@nasa.gov>]

I'm receiving the following error while trying to install the
jetspeed-2.1.2-demo-installer.jar on a Windows 2003 Server box.  I
receive the "Finished" pop-up box.  When I click "OK", I receive another
pop-up box saying;

Install Failed
Error running the install.  The following error occurred while executing
this line:
E:\Apache\Jetspeed-2.1.2\database\build.xml:133:
com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY
constraint 'FK_FOLDER_1' on table 'FOLDER' may cause cycles or multiple
cascade paths.  

build.xml:132-133
    <sql driver="${_jdbc.driver.class}" url="${_jdbc.url}"
userid="${_db.username}" password="${_db.password}"
      src="${basedir}/${db.type}/phase2-schema.sql" print="yes"
output="setup.log">

Here's the last error from the GUI "Errors" tab;

      [sql]   BEGIN ALTER TABLE FOLDER ADD CONSTRAINT FK_FOLDER_1
FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE CASCADE
END


Any help would be greatly appreciated!

Greg

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org