Description |
Customer: Freedom Oil
Database: testTE
Applied Version: 19.1.0819.837
[ftp://qc.irely.com/Databases/freedom]
Error Log:
Error SQL72014: .Net SqlClient Data Provider: Msg 2627, Level 14, State 1, Line 133 Violation of UNIQUE KEY constraint 'UC_tblSMTransaction_intScreenId_intRecordId'. Cannot insert duplicate key in object 'dbo.tblSMTransaction'. The duplicate key value is (828, 0).
Error SQL72045: Script execution error. The executed script:
PRINT 'BEGIN POST DEPLOYMENT';
IF NOT EXISTS (SELECT TOP 1 1
FROM sys.certificates
WHERE name = 'i21EncryptionCert')
BEGIN
EXECUTE ('
CREATE CERTIFICATE i21EncryptionCert
ENCRYPTION BY PASSWORD = ''neYwLw+SCUq84dAAd9xuM1AFotK5QzL4Vx4VjYUemUY=''
WITH SUBJECT = ''i21 Encryption Certificate''
');
END
IF NOT EXISTS (SELECT TOP 1 1
FROM sys.symmetric_keys
WHERE name = 'i21EncryptionSymKey')
BEGIN
EXECUTE ('
CREATE SYMMETRIC KEY i21EncryptionSymKey
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE i21EncryptionCert
');
END
IF NOT EXISTS (SELECT TOP 1 1
FROM sys.asymmetric_keys
WHERE name = 'i21EncryptionASymKeyPwd')
BEGIN
EXECUTE ('
CREATE ASYMMETRIC KEY i21EncryptionASymKeyPwd
WITH ALGORITHM = RSA_2048
ENCRYPTION BY PASSWORD = ''neYwLw+SCUq84dAAd9xuM1AFotK5QzL4Vx4VjYUemUY=''
');
END
IF
|