liquibase.exception.DatabaseException

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.

  • 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,
  • Activiti Liquibase Issue
    via Stack Overflow by Sunita Nayak
    ,
  • 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,
    • liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE cattle.volume ADD access_mode VARCHAR(255) NULL: Can't create table 'cattle.#sql-18_7' (errno: -1) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)[spring-context-3.2.4.RELEASE.jar:3.2.4.RELEASE] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)[spring-context-3.2.4.RELEASE.jar:3.2.4.RELEASE] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:184)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:157)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:348)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:358)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:333)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:152)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:97)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:75)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:56)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.context.SpringContext.<init>(SpringContext.java:11)[cattle-iaas-system-0.5.0-SNAPSHOT.jar:na] at io.cattle.platform.context.WebContextLoaderListener.constructCloudStackSpringContext(WebContextLoaderListener.java:15)[cattle-iaas-system-0.5.0-SNAPSHOT.jar:na] at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:51)[cattle-framework-spring-module-0.5.0-SNAPSHOT.jar:na] at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:800)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:444)[jetty-servlet-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:791)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:294)[jetty-servlet-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1349)[jetty-webapp-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1342)[jetty-webapp-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:741)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:505)[jetty-webapp-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.server.Server.start(Server.java:387)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.server.Server.doStart(Server.java:354)[jetty-server-9.2.11.v20150529.jar:9.2.11.v20150529] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)[jetty-util-9.2.11.v20150529.jar:9.2.11.v20150529] at io.cattle.platform.launcher.jetty.Main.main(Main.java:145)[8cd6a40e20d8c693d8b4ac1f1d27d4b2/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_95] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_95] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_95] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_95] at io.cattle.platform.launcher.Main.run(Main.java:188)[8cd6a40e20d8c693d8b4ac1f1d27d4b2/:na] at io.cattle.platform.launcher.Main.main(Main.java:251)[8cd6a40e20d8c693d8b4ac1f1d27d4b2/:na]

    Users with the same issue

    Unknown visitor1 times, last one,
    Malcshour
    26 times, last one,