| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-271143 - Run automation on Latest 20.1 build for MCP|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-271143]
Steps:
1. Go to i21 server > Find environment
2/ Upgrade into latest PROD
Issue:
* *** Could not deploy package.
* Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 0, Procedure uspARCustomerAgingAsOfDateReport, Line 376 Invalid object name '##ARPOSTEDPAYMENT'.
* 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
{color:#000000}Acceptance:{color}
{color:#000000}Should successfully upgraded.{color}
|