" Unique Key error adding training in web
Q: When I try to add a new training from the web interface, I get an error message:
Violation of UNIQUE KEY constraint 'Cert_Num'. Cannot insert duplicate key in object 'dbo.tblCerts'
A: This message means that you are trying to add a new training with the same number as an existing training. Each training requires a unique training number. You can use a different number, or locate the existing record and edit that number. Note: Even if you deleted the other training record, you still will not be able to use the same number.
To locate the existing record, you may need to look in your active/inactive training list or your deleted training list.
1. From the menu bar, select "Training > Search Training".
2. Type in the training number and click "Go". Matching training records will be displayed
If the record is found:
If this is the training you are trying to add, you can simply use this training record. If it is marked as "inactive", you can change it to "active". If this is a separate training, you will need to use a different number for one of the records.
If the training is NOT found:
1. From the menu bar, select "Training > Restore Deleted Training".
2. Click on the title of the training with the same number as the one you are trying to add.
3. Click "Restore".
If this is the same training as the one you are trying to add, you can simply begin using it.
If this is not the training you want to add, please follow there steps:
1. From the menu bar, select "Training".
2. Click on the title of the training you restored above.
3. Edit the training number to something different (for example, "XXXX-Inactive").
4. Save changes.
5. Click "Delete Training" and "Delete". Now you may add the new training.
Tags: Duplicate record error, unique key, duplicate key.
Violation of UNIQUE KEY constraint 'Cert_Num'. Cannot insert duplicate key in object 'dbo.tblCerts'
A: This message means that you are trying to add a new training with the same number as an existing training. Each training requires a unique training number. You can use a different number, or locate the existing record and edit that number. Note: Even if you deleted the other training record, you still will not be able to use the same number.
To locate the existing record, you may need to look in your active/inactive training list or your deleted training list.
1. From the menu bar, select "Training > Search Training".
2. Type in the training number and click "Go". Matching training records will be displayed
If the record is found:
If this is the training you are trying to add, you can simply use this training record. If it is marked as "inactive", you can change it to "active". If this is a separate training, you will need to use a different number for one of the records.
If the training is NOT found:
1. From the menu bar, select "Training > Restore Deleted Training".
2. Click on the title of the training with the same number as the one you are trying to add.
3. Click "Restore".
If this is the same training as the one you are trying to add, you can simply begin using it.
If this is not the training you want to add, please follow there steps:
1. From the menu bar, select "Training".
2. Click on the title of the training you restored above.
3. Edit the training number to something different (for example, "XXXX-Inactive").
4. Save changes.
5. Click "Delete Training" and "Delete". Now you may add the new training.
Tags: Duplicate record error, unique key, duplicate key.