Issue 43 in power-matchmaker: SQLException when creating new repository on SQL Server 2008

3 views

Skip to first unread message

power-ma...@googlecode.com

unread,

Jun 16, 2010, 10:41:12 AM6/16/10

to dqguru...@googlegroups.com

Status: Accepted
Owner: mo.j...@gmail.com
Labels: Type-Defect Priority-High Milestone-Release1.0 OpSys-All
DBMS-SQLServer Component-Persistence

New issue 43 by mo.j...@gmail.com: SQLException when creating new
repository on SQL Server 2008
http://code.google.com/p/power-matchmaker/issues/detail?id=43

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(RepositoryUtil.java:307)
at
ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createOrUpdateRepositorySchema(RepositoryUtil.java:226)
at
ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionImpl.<init>(MatchMakerHibernateSessionImpl.java:194)
at
ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionContext.createSession(MatchMakerHibernateSessionContext.java:147)
at
ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.createSession(SwingSessionContextImpl.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(SQLServerException.java:197)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
at
ca.sqlpower.sql.jdbcwrapper.StatementDecorator.execute(StatementDecorator.java:89)
at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at
ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(RepositoryUtil.java:302)
... 7 more