Description |
The below error is encountered while trying to deploy version 21.2.0208.695 in Mother Parker's test environment
* *** Could not deploy package.
* Error SQL72014: .Net SqlClient Data Provider: Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'text()' because it contains a character (0x0016) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.
* 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
|