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.

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

    Automated exception search integrated into your IDE

  5. 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.
  6. 0

    When we try to deploy against SQLServer 2012 we run afoul of https://liquibase.jira.com/browse/CORE-1141. Either need to upgrade Liquibase to pick up that patch or figure out how to implement the same thing with a local override of that {{DropDefaultValueGenerator#generateSql()}}. If we start this at the beginning of a new minor release, we should at least attempt the Liquibase update and give it soak. And will need to make sure everything continues to work for upgrade and clean install scenarios, esp where the db to be upgraded was created with the "legacy" Liquibase version. If we start this mid-stream such that we can't give it extensive soak time, we should look at the latter option (override {{DropDefaultValueGenerator}}). For either approach, we need to make doubly sure that jTDS is returning the {{productVersion}} we expect from both 2008 and 2012. I believe there have historically been problems with that, specifically for 2005. And if it's not returning the correct version, the CORE-1141 patch isn't going to help us.

    Apereo Issues | 3 years ago | Dan McCallum
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[person_demographics] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t.id AND d.type='D' AND t.type='U' AND c.name='ability_to_benefit' AND t.name='person_demographics': Incorrect syntax near the keyword 'select'.: Caused By: Error executing SQL ALTER TABLE [dbo].[person_demographics] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t.id AND d.type='D' AND t.type='U' AND c.name='ability_to_benefit' AND t.name='person_demographics': Incorrect syntax near the keyword 'select'.: Caused By: Incorrect syntax near the keyword 'select'.

  1. abrazeneb 8 times, last 4 months ago
1 unregistered visitors
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. 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()
  2. jTDS
    JtdsStatement.execute
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)[jtds-1.2.4.jar:1.2.4]
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)[jtds-1.2.4.jar:1.2.4]
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)[jtds-1.2.4.jar:1.2.4]
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)[jtds-1.2.4.jar:1.2.4]
    5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)[jtds-1.2.4.jar:1.2.4]
    6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)[jtds-1.2.4.jar:1.2.4]
    7. net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)[jtds-1.2.4.jar:1.2.4]
    8. net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)[jtds-1.2.4.jar:1.2.4]
    8 frames
  3. Liquibase Core
    SpringLiquibase.afterPropertiesSet
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)[liquibase-core-2.0.3.jar:na]
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)[liquibase-core-2.0.3.jar:na]
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)[liquibase-core-2.0.3.jar:na]
    4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)[liquibase-core-2.0.3.jar:na]
    5. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1075)[liquibase-core-2.0.3.jar:na]
    6. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1059)[liquibase-core-2.0.3.jar:na]
    7. liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)[liquibase-core-2.0.3.jar:na]
    8. liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)[liquibase-core-2.0.3.jar:na]
    9. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)[liquibase-core-2.0.3.jar:na]
    10. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)[liquibase-core-2.0.3.jar:na]
    11. liquibase.Liquibase.update(Liquibase.java:113)[liquibase-core-2.0.3.jar:na]
    12. liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:244)[liquibase-core-2.0.3.jar:na]
    12 frames
  4. org.jasig.ssp
    ExtendedSpringLiquibase.afterPropertiesSet
    1. org.jasig.ssp.util.liquibase.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:67)[ExtendedSpringLiquibase.class:na]
    1 frame
  5. Spring Beans
    AbstractAutowireCapableBeanFactory.initializeBean
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)[spring-beans-3.2.8.RELEASE.jar:3.2.8.RELEASE]
    2 frames