Error on installing 18.32.1226.520

Issue No: GRN-1383
Created 12/26/2018 4:11:42 PM
Type Bug-QC
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3
Description *Database:* 01 01:57:10 PM - Warning SQL72015: The column [dbo].[tblSMUserSecurityMenuFavorite].[intUserSecurityId] is being dropped, data loss could occur. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[tblEMEntityCredential] might introduce run-time errors in [dbo].[vyuPOSGetLoggedIn]. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[fnAESDecryptASym] might introduce run-time errors in [dbo].[uspEMImportEmployees]. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[fnAESEncryptASym] might introduce run-time errors in [dbo].[uspEMImportEmployees]. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[fnAESEncryptASym] might introduce run-time errors in [dbo].[uspEMImportCustomerEFTInfo]. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreateCustomerInvoice] might introduce run-time errors in [dbo].[uspARImportInvoiceCSV]. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreatePrePayment] might introduce run-time errors in [dbo].[uspARImportPayments]. 01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARPostInvoice] might introduce run-time errors in [dbo].[uspTRProcessToInvoice]. 01:57:10 PM - Error SQL72014: .Net SqlClient Data Provider: Msg 8134, Level 16, State 1, Line 9 Divide by zero error encountered. 01:57:10 PM - Error SQL72045: Script execution error. The executed script: 01:57:10 PM - PRINT 'BEGIN POST DEPLOYMENT'; 01:57:10 PM - IF NOT EXISTS (SELECT TOP 1 1 01:57:10 PM - FROM sys.certificates 01:57:10 PM - WHERE name = 'i21EncryptionCert') 01:57:10 PM - BEGIN 01:57:10 PM - EXECUTE (' 01:57:10 PM - CREATE CERTIFICATE i21EncryptionCert 01:57:10 PM - ENCRYPTION BY PASSWORD = ''neYwLw+SCUq84dAAd9xuM1AFotK5QzL4Vx4VjYUemUY='' 01:57:10 PM - WITH SUBJECT = ''i21 Encryption Certificate'' 01:57:10 PM - '); 01:57:10 PM - END 01:57:10 PM - IF NOT EXISTS (SELECT TOP 1 1 01:57:10 PM - FROM sys.symmetric_keys 01:57:10 PM - WHERE name = 'i21EncryptionSymKey') 01:57:10 PM - BEGIN 01:57:10 PM - EXECUTE (' 01:57:10 PM - CREATE SYMMETRIC KEY i21EncryptionSymKey 01:57:10 PM - WITH ALGORITHM = AES_256 01:57:10 PM - ENCRYPTION BY CERTIFICATE i21EncryptionCert 01:57:10 PM - '); 01:57:10 PM - END 01:57:10 PM - IF NOT EXISTS (SELECT TOP 1 1 01:57:10 PM - FROM sys.asymmetric_keys 01:57:10 PM - WHERE name = 'i21EncryptionASymKeyPwd') 01:57:10 PM - BEGIN 01:57:10 PM - EXECUTE (' 01:57:10 PM - CREATE ASYMMETRIC KEY i21EncryptionASymKeyPwd 01:57:10 PM - WITH ALGORITHM = RSA_2048 01:57:10 PM - ENCRYPTION BY PASSWORD = ''neYwLw+SCUq84dAAd9xuM1AFotK5QzL4Vx4VjYUemUY='' 01:57:10 PM - '); 01:57:10 PM - END 01:57:10 PM - IF FINISH RUNNING SCRIPTS FOR DEV183001