You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Access It! Universal.NET > Cannot insert duplicate key row in object 'dbo.Cards' with unique index 'IX_Cards_PINNumber_NE0'.
Cannot insert duplicate key row in object 'dbo.Cards' with unique index 'IX_Cards_PINNumber_NE0'.
print icon

Symptoms

With Access It! Universal.NET v5.1.0.2 when adding a second card the error Cannot insert duplicate key row in object 'dbo.Cards' with unique index 'IX_Cards_PINNumber_NE0' occurs.

Cause

The option to require unique pins is incorrectly turned on the AIUniversal database.

Resolution

  1. Launch Database Configuration Utility (Start | All Programs | Access It! Universal.NET | Server Utilities)
  2. Click Connect
  3. Select Data Manager
  4. Paste the script from the More Information section into the top box.
  5. Click Execute
  6. Close Database Configuration Utility

More Information

USE [AIUniversal]
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Cards]') AND name = N'IX_Cards_PINNumber_NE0')
DROP INDEX [IX_Cards_PINNumber_NE0] ON [dbo].[Cards] WITH ( ONLINE = OFF )


scroll to top icon