liquibase.exception.JDBCException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Liquibase 1.9.5 on Windows against MS-SQL. Liquibase is case insensitive on its arguments, so >liquibase --changeLogFile=casesensitive.xml update >liquibase --changeLogFile=CASESENSITIVE.xml update will execute the same changelogfile. The database is also case insensitive and will see the two nameings as the same. If a changelog contains a changeset with attribute runAlways="true", running it using case different naming will raise an database exception. So somewhere in the code there must be a case sensitive comparison that results in an INSERT statement where it should have been an UPDATE statement. casesensitive.xml Code: <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd"> <changeSet id="1" author="justx2" runAlways="true"> <comment>Doing nothing</comment> </changeSet> </databaseChangeLog> Example: >liquibase --changeLogFile=casesensitive.xml update Migration successful >liquibase --changeLogFile=casesensitive.xml update Migration successful >liquibase --changeLogFile=CASESENSITIVE.xml update Migration Failed: Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'.. For more information, use the --logLevel flag) 144 ERROR liquibase.main (111) - Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'. liquibase.exception.JDBCException: Error executing SQL INSERT INTO [dbo].[DATABASECHANGELOG] ([DATEEXECUTED], [AUTHOR], [LIQUIBASE], [DESCRIPTION], [COMMENTS], [MD5SUM], [ID], [FILENAME]) VALUES (GETDATE(), 'justx2', '1.9.5_ct1', 'Empty', 'Doing nothing', 'd41d8cd98f0b24e980998ecf8427e', '1', 'CASESENSITIVE.xml') at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.database.AbstractDatabase.markChangeSetAsRan(AbstractDatabase.java:1309) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:28) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.commandline.Main.doMigration(Main.java:650) at liquibase.commandline.Main.main(Main.java:97) Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 7 more
    via by Nathan Voxland,
  • Liquibase 1.9.5 on Windows against MS-SQL. Liquibase is case insensitive on its arguments, so >liquibase --changeLogFile=casesensitive.xml update >liquibase --changeLogFile=CASESENSITIVE.xml update will execute the same changelogfile. The database is also case insensitive and will see the two nameings as the same. If a changelog contains a changeset with attribute runAlways="true", running it using case different naming will raise an database exception. So somewhere in the code there must be a case sensitive comparison that results in an INSERT statement where it should have been an UPDATE statement. casesensitive.xml Code: <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd"> <changeSet id="1" author="justx2" runAlways="true"> <comment>Doing nothing</comment> </changeSet> </databaseChangeLog> Example: >liquibase --changeLogFile=casesensitive.xml update Migration successful >liquibase --changeLogFile=casesensitive.xml update Migration successful >liquibase --changeLogFile=CASESENSITIVE.xml update Migration Failed: Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'.. For more information, use the --logLevel flag) 144 ERROR liquibase.main (111) - Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'. liquibase.exception.JDBCException: Error executing SQL INSERT INTO [dbo].[DATABASECHANGELOG] ([DATEEXECUTED], [AUTHOR], [LIQUIBASE], [DESCRIPTION], [COMMENTS], [MD5SUM], [ID], [FILENAME]) VALUES (GETDATE(), 'justx2', '1.9.5_ct1', 'Empty', 'Doing nothing', 'd41d8cd98f0b24e980998ecf8427e', '1', 'CASESENSITIVE.xml') at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.database.AbstractDatabase.markChangeSetAsRan(AbstractDatabase.java:1309) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:28) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.commandline.Main.doMigration(Main.java:650) at liquibase.commandline.Main.main(Main.java:97) Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 7 more
    via by Nathan Voxland,
  • SQL Server Schema Upgrade Fails (6.5 -> 7.0 EAP)
    via by Unknown author,
  • During a deployment of 2.5.0 at Sinclair, the SSP deployment failed with the following error in the log {noformat} Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000130.xml::create mv directory_person view and pop msql::jim.stanley: Reason: liquibase.exception.DatabaseException: Error executing SQL SELECT * INTO dbo.mv_directory_person FROM dbo.v_directory_person;: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.: Caused By: Error executing SQL SELECT * INTO dbo.mv_directory_person FROM dbo.v_directory_person;: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.: Caused By: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 65 common frames omitted Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000130.xml::create mv directory_person view and pop msql::jim.stanley: Reason: liquibase.exception.DatabaseException: Error executing SQL SELECT * INTO dbo.mv_directory_person FROM dbo.v_directory_person;: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.: Caused By: Error executing SQL SELECT * INTO dbo.mv_directory_person FROM dbo.v_directory_person;: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.: Caused By: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) ~[liquibase-core-2.0.3.jar:na] at liquibase.Liquibase.update(Liquibase.java:113) ~[liquibase-core-2.0.3.jar:na] at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244) ~[liquibase-core-2.0.3.jar:na] at org.jasig.ssp.util.liquibase.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:67) ~[ExtendedSpringLiquibase.class:na] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 77 common frames omitted Caused by: liquibase.exception.DatabaseException: Error executing SQL SELECT * INTO dbo.mv_directory_person FROM dbo.v_directory_person;: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ~[liquibase-core-2.0.3.jar:na] ... 84 common frames omitted Caused by: java.sql.SQLException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) ~[jtds-1.2.4.jar:1.2.4] at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-2.0.3.jar:na] ... 88 common frames omitted {noformat}
    via by Jason Elwood,
  • The job_queue table creation is failing on SQL Server with the following errors in the log {noformat} DEV: 10:13:30.813 [main] INFO o.j.s.c.logging.LogBackConfigLoader - Configured Logback with config file from: C:\src\ssp-local\logback.xml DEV: 10:13:31.141 [main] INFO o.j.s.c.BeanProfileApplicationContextInitializer - Loaded properties file from C:\src\ssp-local\ssp-config.properties for determining spring profile. DEV: 10:13:31.141 [main] INFO o.j.s.c.BeanProfileApplicationContextInitializer - Loaded properties file from classpath:ssp-config.default.properties for determining spring profile. DEV: 10:13:42.825 [main] INFO o.s.s.c.ThreadPoolTaskScheduler - Initializing ExecutorService 'sspScheduler' DEV: 10:14:14.382 [main] INFO o.s.s.c.ThreadPoolTaskScheduler - Shutting down ExecutorService 'sspScheduler' DEV: 10:14:14.397 [main] ERROR o.s.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'webProperties': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.service.reference.ConfigService org.jasig.ssp.config.WebProperties.configService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932) ~[spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479) ~[spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) ~[spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) ~[spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) [spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) [catalina.jar:6.0.36] at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) [catalina.jar:6.0.36] at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.36] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_67] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_67] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.36] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.36] Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.service.reference.ConfigService org.jasig.ssp.config.WebProperties.configService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 37 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 39 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 50 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 52 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 63 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 65 common frames omitted Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) ~[liquibase-core-2.0.3.jar:na] at liquibase.Liquibase.update(Liquibase.java:113) ~[liquibase-core-2.0.3.jar:na] at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244) ~[liquibase-core-2.0.3.jar:na] at org.jasig.ssp.util.liquibase.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:67) ~[ExtendedSpringLiquibase.class:na] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 77 common frames omitted Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ~[liquibase-core-2.0.3.jar:na] ... 84 common frames omitted Caused by: java.sql.SQLException: There is already an object named 'watch_modified_person_id' in the database. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) ~[jtds-1.2.4.jar:1.2.4] at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-2.0.3.jar:na] ... 88 common frames omitted {noformat}
    via by Jason Elwood,
  • As of d564427d2d83124296a1d06bc36615e78b942564 the data migration tool is generating {{insert}} refactoring commands but no preceding {{deletes}}. So you get errors like the following when actually running the changesets against a SSP database in a default state: {noformat} INFO 4/11/13 11:05 AM:liquibase: Successfully released change log lock Liquibase Update Failed: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. SEVERE 4/11/13 11:05 AM:liquibase: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. liquibase.exception.MigrationFailedException: Migration failed for change set mssql-1-2-src.xml::data migration tool - insert migrated data::data.migration.tool: Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.integration.commandline.Main.doMigration(Main.java:779) at liquibase.integration.commandline.Main.main(Main.java:133) Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ... 5 more Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 9 more {noformat}
    via by Dan McCallum,
  • As of d564427d2d83124296a1d06bc36615e78b942564 the data migration tool is generating {{insert}} refactoring commands but no preceding {{deletes}}. So you get errors like the following when actually running the changesets against a SSP database in a default state: {noformat} INFO 4/11/13 11:05 AM:liquibase: Successfully released change log lock Liquibase Update Failed: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. SEVERE 4/11/13 11:05 AM:liquibase: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. liquibase.exception.MigrationFailedException: Migration failed for change set mssql-1-2-src.xml::data migration tool - insert migrated data::data.migration.tool: Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'.: Caused By: Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:113) at liquibase.integration.commandline.Main.doMigration(Main.java:779) at liquibase.integration.commandline.Main.main(Main.java:133) Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19:00:00.0', 'net.sourceforge.jtds.jdbc.ClobImpl@6d13e8f3', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '901E104B-4DC7-43F5-A38E-581015E204E1', 'DA572870-5699-11E2-BE1E-406C8F22C3CE', '2013-03-19 13:27:33.533', 'Test Campus', '1'): Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ... 5 more Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_CAMPUS'. Cannot insert duplicate key in object 'dbo.campus'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 9 more {noformat}
    via by Dan McCallum,
  • The job_queue table creation is failing on SQL Server with the following errors in the log {noformat} DEV: 10:13:30.813 [main] INFO o.j.s.c.logging.LogBackConfigLoader - Configured Logback with config file from: C:\src\ssp-local\logback.xml DEV: 10:13:31.141 [main] INFO o.j.s.c.BeanProfileApplicationContextInitializer - Loaded properties file from C:\src\ssp-local\ssp-config.properties for determining spring profile. DEV: 10:13:31.141 [main] INFO o.j.s.c.BeanProfileApplicationContextInitializer - Loaded properties file from classpath:ssp-config.default.properties for determining spring profile. DEV: 10:13:42.825 [main] INFO o.s.s.c.ThreadPoolTaskScheduler - Initializing ExecutorService 'sspScheduler' DEV: 10:14:14.382 [main] INFO o.s.s.c.ThreadPoolTaskScheduler - Shutting down ExecutorService 'sspScheduler' DEV: 10:14:14.397 [main] ERROR o.s.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'webProperties': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.service.reference.ConfigService org.jasig.ssp.config.WebProperties.configService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932) ~[spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479) ~[spring-context-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) ~[spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) ~[spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) [spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) [catalina.jar:6.0.36] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) [catalina.jar:6.0.36] at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) [catalina.jar:6.0.36] at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.36] at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) [catalina.jar:6.0.36] at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.36] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_67] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_67] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.36] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.36] Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.service.reference.ConfigService org.jasig.ssp.config.WebProperties.configService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 37 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 39 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private transient org.jasig.ssp.dao.reference.ConfigDao org.jasig.ssp.service.reference.impl.ConfigServiceImpl.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 50 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'configDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:289) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1146) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 52 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: protected transient org.hibernate.SessionFactory org.jasig.ssp.dao.AbstractDao.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:517) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 63 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in ServletContext resource [/WEB-INF/spring/app-config.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 65 common frames omitted Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set org/jasig/ssp/database/changesets/000156.xml::create table job_queue::tony.arland: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database.: Caused By: There is already an object named 'watch_modified_person_id' in the database. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) ~[liquibase-core-2.0.3.jar:na] at liquibase.Liquibase.update(Liquibase.java:113) ~[liquibase-core-2.0.3.jar:na] at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244) ~[liquibase-core-2.0.3.jar:na] at org.jasig.ssp.util.liquibase.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:67) ~[ExtendedSpringLiquibase.class:na] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509) ~[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE] ... 77 common frames omitted Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [dbo].[job_queue] ([id] UNIQUEIDENTIFIER NOT NULL, [owner_id] UNIQUEIDENTIFIER NOT NULL, [run_as_id] UNIQUEIDENTIFIER NOT NULL, [execution_component_name] NVARCHAR(150) NOT NULL, [execution_spec] NVARCHAR(MAX), [execution_state] NVARCHAR(MAX) NOT NULL, [workflow_status] NVARCHAR(50) NOT NULL, [workflow_status_desc] NVARCHAR(MAX), [scheduling_started_date] DATETIME, [scheduled_by_process] NVARCHAR(150), [execution_started_date] DATETIME, [workflow_stopped_date] DATETIME, [created_date] DATETIME NOT NULL, [modified_date] DATETIME, [created_by] UNIQUEIDENTIFIER NOT NULL, [modified_by] UNIQUEIDENTIFIER, [object_status] INT NOT NULL, CONSTRAINT [PK_JOB_QUEUE] PRIMARY KEY ([id]), CONSTRAINT [watch_modified_person_id] FOREIGN KEY ([modified_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_owner_id] FOREIGN KEY ([owner_id]) REFERENCES dbo.person(id), CONSTRAINT [watch_created_person_id] FOREIGN KEY ([created_by]) REFERENCES dbo.person(id), CONSTRAINT [job_queue_run_as_id] FOREIGN KEY ([run_as_id]) REFERENCES dbo.person(id)): There is already an object named 'watch_modified_person_id' in the database. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075) ~[liquibase-core-2.0.3.jar:na] at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059) ~[liquibase-core-2.0.3.jar:na] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317) ~[liquibase-core-2.0.3.jar:na] ... 84 common frames omitted Caused by: java.sql.SQLException: There is already an object named 'watch_modified_person_id' in the database. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) ~[jtds-1.2.4.jar:1.2.4] at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) ~[jtds-1.2.4.jar:1.2.4] at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) ~[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-2.0.3.jar:na] ... 88 common frames omitted {noformat}
    via by Jason Elwood,
    • liquibase.exception.JDBCException: Error executing SQL INSERT INTO [dbo].[DATABASECHANGELOG] ([DATEEXECUTED], [AUTHOR], [LIQUIBASE], [DESCRIPTION], [COMMENTS], [MD5SUM], [ID], [FILENAME]) VALUES (GETDATE(), 'justx2', '1.9.5_ct1', 'Empty', 'Doing nothing', 'd41d8cd98f0b24e980998ecf8427e', '1', 'CASESENSITIVE.xml') at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.database.AbstractDatabase.markChangeSetAsRan(AbstractDatabase.java:1309) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:28) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.commandline.Main.doMigration(Main.java:650) at liquibase.commandline.Main.main(Main.java:97) Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_DATABASECHANGELOG'. Cannot insert duplicate key in object 'dbo.DATABASECHANGELOG'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:78) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48) ... 7 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    EricEric
    3 times, last one,
    abrazenebabrazeneb
    8 times, last one,
    oddodd
    72 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    22 more bugmates