Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-336735 - Upgrade Legacy Fuels Prod and TE Environment to 22.1.0321.3038|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-336735]
* *** Could not deploy package.
* Error SQL72014: .Net SqlClient Data Provider: Msg 2714, Level 16, State 6, Line 8 There is already an object named 'TempEntityMenuFavorite' in the database.
* 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
!pastedImage_3_26_2024__15_18_43_64.png|height=247,width=553!
|