...
| Info | ||
|---|---|---|
| ||
Caused By: Error executing SQL ALTER TABLE [dbo].[mv_directory_person] ADD CONSTRAINT [pk_id_materialized] PRIMARY KEY ([id]): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.mv_directory_person' and the index name 'pk_id_materialized'. |
| Code Block |
|---|
SQL to RetartRestart the Object Creation Both Databases - drop table mv_directory_person SQL Server - delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000130.xml' and id = 'update for new installs directory_person view' - delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000130.xml' and id = 'create mv directory_person view and pop msql' PostgreSQL - delete from databasechangelog where filename = 'org/jasig/ssp/database/changesets/000130.xml' and id = 'create mv directory_person view and pop postgresql' |
...