| Description |
Build Version: 17.1.0126.323
Error when upgrading db in Advance Installer:
!pastedImage_d90631_0.png!
{noformat}1/26/2018 2:50:40 PM Error SQL72014: .Net SqlClient Data Provider: Msg 8120, Level 16, State 1, Procedure vyuPREmployeeW3, Line 22 Column 'vyuPREmployeeW2.strLocality' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
1/26/2018 2:50:40 PM Error SQL72045: Script execution error. The executed script:
ALTER VIEW [dbo].[vyuPREmployeeW3]
AS
SELECT vyuPREmployeeW2.intYear AS intYear,
CAST (MAX(CAST (ysnThirdPartySickPay AS INT)) AS BIT) AS ysnThirdPartySickPay,
COUNT(1) AS intW2Count,
SUM(dblAdjustedGross) AS dblAdjustedGross,
SUM(dblFIT) AS dblFIT,
SUM(dblTaxableSS) AS dblTaxableSS,
SUM(dblSSTax) AS dblSSTax,
SUM(dblTaxableMed) AS dblTaxableMed,
SUM(dblMedTax) AS dblMedTax,
SUM(dblTaxableSSTips) AS dblTaxableSSTips,
SUM(dblAllocatedTips) AS dblAllocatedTips,
SUM(dblDependentCare) AS dblDependentCare,
SUM(dblNonqualifiedPlans) AS dblNonqualifiedPlans,
ISNULL(tblDefferedCompensation.dblDefferedCompensation, 0) AS dblDefferedCompensation,
0 AS dblThirdPartyIncomeTax,
SUM(dblTaxableState) AS dblTaxableState,
SUM(dblStateTax) AS dblStateTax,
SUM(dblTaxableLocal) AS dblTaxableLocal,
CASE WHEN (ISNULL(strLocality, '') <> ISNULL(strLoc
1/26/2018 2:50:40 PM Error SQL72014: .Net SqlClient Data Provider: Msg 8120, Level 16, State 1, Procedure vyuPREmployeeW3, Line 22 Column 'vyuPREmployeeW2.strLocality2' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
1/26/2018 2:50:40 PM Error SQL72045: Script execution error. The executed script:
ALTER VIEW [dbo].[vyuPREmployeeW3]
AS
SELECT vyuPREmployeeW2.intYear AS intYear,
CAST (MAX(CAST (ysnThirdPartySickPay AS INT)) AS BIT) AS ysnThirdPartySickPay,
COUNT(1) AS intW2Count,
SUM(dblAdjustedGross) AS dblAdjustedGross,
SUM(dblFIT) AS dblFIT,
SUM(dblTaxableSS) AS dblTaxableSS,
SUM(dblSSTax) AS dblSSTax,
SUM(dblTaxableMed) AS dblTaxableMed,
SUM(dblMedTax) AS dblMedTax,
SUM(dblTaxableSSTips) AS dblTaxableSSTips,
SUM(dblAllocatedTips) AS dblAllocatedTips,
SUM(dblDependentCare) AS dblDependentCare,
SUM(dblNonqualifiedPlans) AS dblNonqualifiedPlans,
ISNULL(tblDefferedCompensation.dblDefferedCompensation, 0) AS dblDefferedCompensation,
0 AS dblThirdPartyIncomeTax,
SUM(dblTaxableState) AS dblTaxableState,
SUM(dblStateTax) AS dblStateTax,
SUM(dblTaxableLocal) AS dblTaxableLocal,
CASE WHEN (ISNULL(strLocality, '') <> ISNULL(strLoc
1/26/2018 2:50:40 PM Message SQL0: An error occurred while the batch was being executed.
1/26/2018 2:50:40 PM Message SQL73036: Updating database (Failed)
1/26/2018 2:50:41 PM Install function Error: Could not deploy package.{noformat}
|