IX_OrderGroupNote_OrderGroupId Index issue in database schema upd

London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

Home / Forums / Developers (Main Products) Forum / Customized Commerce 13 and earlier versions /

IX_OrderGroupNote_OrderGroupId Index issue in database schema update script version 7.0.7

valdis

Vote:

Oringal statement:

IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_OrderGroupNote_OrderGroupId')
DROP INDEX IX_OrderGroupNote_OrderGroupId ON [dbo].[OrderGroupNote]
CREATE NONCLUSTERED INDEX [IX_OrderGroupNote_OrderGroupId]
    ON [dbo].[OrderGroupNote]([OrderGroupId] ASC);

GO

Not working very well on SQL Azure. Need to add "." between "sys" and "indexes":

IF EXISTS (SELECT name FROM sys.indexes WHERE name = 'IX_OrderGroupNote_OrderGroupId')
DROP INDEX IX_OrderGroupNote_OrderGroupId ON [dbo].[OrderGroupNote]
CREATE NONCLUSTERED INDEX [IX_OrderGroupNote_OrderGroupId]
    ON [dbo].[OrderGroupNote]([OrderGroupId] ASC);

GO

Production site was down while trying to find this issue :)

#142758

Dec 22, 2015 0:03

Magnus Rahl

Vote:

Thanks for reporting it, I'll register a bug and make sure it is fixed ASAP.

#142759

Dec 22, 2015 7:38

Quan Mai

Vote:

Hi,

Thank you for your feedback. We'll look into this problem.

Regards,

#142760

Dec 22, 2015 7:42

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.