Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-230723 - Bugs discovered by iRely team during Round-1 of testing|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-230723]
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-229214 - Revieweing 19.1 Build|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-229214]
EOC DB: [ftp://ftp.i21server.com:2121/Rajat/EOCirely01.zip]
Tried to upgrade to 19.12.0401.223.
Found below error:
Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Procedure uspSMAuditLog, Line 75 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dbo.tblSMLog_dbo.tblEMEntity_intEntityId". The conflict occurred in database "EOCirely191001", table "dbo.tblEMEntity", column 'intEntityId'.
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
Press any key to continue . . .
|