SQLServerException when creating new repository on SQL Server 2008

[GoogleCodeExporter]

What steps will reproduce the problem?
1. User attempted to create a new DQguru repository on a SQL Server 2008 
database.

See http://www.sqlpower.ca/forum/posts/list/2667.page

What is the expected output? What do you see instead?
Instead of confirmation of successful repository creation, an exception gets 
thrown. See stacktrace below for details.

Is there an error stacktrace? If so, please paste it below.
ca.sqlpower.matchmaker.dao.hibernate.RepositoryException: Failed to create 
repository. See nested cause for more details. 
at 
ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(Repos
itoryUtil.java:307) 
at 
ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createOrUpdateRepositorySche
ma(RepositoryUtil.java:226) 
at 
ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionImpl.<init>(Match
MakerHibernateSessionImpl.java:194) 
at 
ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionContext.createSes
sion(MatchMakerHibernateSessionContext.java:147)
at 
ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.createSession(SwingSessio
nContextImpl.java:227) 
at 
ca.sqlpower.matchmaker.swingui.LoginDialog$LoginAction.doStuff(LoginDialog.java:
147) 
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104) 
at java.lang.Thread.run(Unknown Source) 
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN 
KEY constraint 'step_output_input_fk' on table 'MM_MUNGE_STEP_INPUT' may cause 
cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO 
ACTION, or modify other FOREIGN KEY constraints. 
at 
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerE
xception.java:197) 
at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement
.java:1493) 
at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStat
ement.java:775) 
at 
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerS
tatement.java:676) 
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874) 
at 
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnect
ion.java:1400) 
at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatemen
t.java:179) 
at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatem
ent.java:154) 
at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:
649) 
at 
ca.sqlpower.sql.jdbcwrapper.StatementDecorator.execute(StatementDecorator.java:8
9) 
at 
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261
) 
at 
ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(Repos
itoryUtil.java:302) 
... 7 more 

Please use labels and text to provide additional information.

Original issue reported on code.google.com by mo.j...@gmail.com on 16 Jun 2010 at 2:40