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.

Apereo Issues | Jason Elwood | 2 years ago
  1. 0

    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}

    Apereo Issues | 2 years ago | Jason Elwood
    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.
  2. 0

    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}

    Apereo Issues | 2 years ago | Jason Elwood
    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.
  3. 0

    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}

    Apereo Issues | 2 years ago | Jason Elwood
    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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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}

    Apereo Issues | 2 years ago | Jason Elwood
    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.
  6. 0

    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}

    Apereo Issues | 2 years ago | Jason Elwood
    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.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. Spring Beans
      AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1512)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      4. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      5. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      6. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      7. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      8. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:286)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      9. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      10. org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      11. org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      12. org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      13. org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:489)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
      13 frames