Skip to content
English
Sign in
Contact us
  • There are no suggestions because the search field is empty.

📄How to Fix the Error - Post Splitting Multi Venue "Cannot Duplicate key in object 'dbo.KeyListItem' The Duplicate key value is etc" 

In short: Delete the Keylists from Keymaps, Delete the Keylist, re-create Keylist with Product Profile, and add Keylist button back to Keymap.

1

Run Smartcontroller

  Run Smartcontroller
 
2

You will see Duplicate Key Errors 

You will see Duplicate Key Errors

 
3

If you see errors such as these: The numbers in the error are: Keylist ID (such as 11790 in this example) Followed by Product Number, and size. The important thing here is the Keyllist ID

If you see errors such as these: The numbers in the error are: Keylist ID (such as 11790 in this example) Followed by Product Number, and size. The important thing here is the Keyllist ID.

 
4

In Backoffice, Open Product Profiles

In Backoffice, Open Product Profiles
 
5

Open Product Keymaps

 Open Product Keymaps
  
6

Click View/Edit Keylists

 Click View/Edit Keylists
 
7

Find the Keylist ID/s that appear in the Smartcontroller errors) Find the Keylist ID/s that appear in the Smartcontroller errors)

8

Click Delete Keylist.

 Click Delete Keylist.
 
9

This will then show us which Keymap/s we need to remove the Keylist from as part of the solution).

 This will then show us which Keymap/s we need to remove the Keylist from as part of the solution).
10

Open the Keymap/s indicated in the previous step.

  Open the Keymap/s indicated in the previous step.
11

Locate the Keylist/s in question. (Be sure to copy and Override Text names to add back in) Take a screenshot if need be).

 Locate the Keylist/s in question. (Be sure to copy and Override Text names to add back in) Take a screenshot if need be).
12
13

Save the Keymap but leave it open as we need to add the Keylist button/s

 Save the Keymap but leave it open as we need to add the Keylist button/s
 
14

Go back to the Keymap List Tab

  Go back to the Keymap List Tab
 
15

Click View/Edit Keylists

 Click View/Edit Keylists
 
16

And Delete the Keylist ID in Question. (It will allow us now it has been removed from the Keymap).

 And Delete the Keylist ID in Question. (It will allow us now it has been removed from the Keymap).
17

Click on the Product Profiles Tab

  Click on the Product Profiles Tab
 
18

Click Re-Create Keylists

   Click Re-Create Keylists
 
19

Go back to the Keymap you removed the Keylist from

 Go back to the Keymap you removed the Keylist from
 
20

Add the Keylist button back on. Right Click

  Add the Keylist button back on. Right Click
 
21

Set as Keylist

 Set as Keylist 
 
22

Select the Keylist you deleted which will now be re-create

 Select the Keylist you deleted which will now be re-create 
 
23

Correct the button Colour Override name if required

 Correct the button Colour Override name if required
 
24

Save. Repeat for all Keylists in the Smartcontroller errors.

 Save. Repeat for all Keylists in the Smartcontroller errors.
 
25

Close Smartcontroller

 Close Smartcontroller
 
  
26

Upon restarting Smartcontroller errors will be cleared. Upon restarting Smartcontroller errors will be cleared.