Altering Index Failed


Author
Message
Melvin Xuereb
Melvin Xuereb
StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)StrataFrame Novice (103 reputation)
Group: Forum Members
Posts: 29, Visits: 128
Hi,

I have created a new profile in the DDT and imported a database structure into the profile.

All the tables, SPs and Views were all imported successfully. Just to test the deployment package, I clicked 'deploy to server', created a package and followed the steps to deployment on the same database from which the structure was imported (there weren't any changes yet).

While deploying the package, and indexes were being dropped and re-created, one of them failed as can be seen in the attachment.

The Index has a unique constraint, and all data in that column is Unique.

Could you please suggest?



On another note, I tried to deploy the same package on a database which does not exists through the DDT - which database was created successfully with no errors.

Your help will be greatly appreciated.

Thanks,
Melvin
Attachments
Deployment.png (153 views, 28.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search