question

ReiniellLiwanag-8105 avatar image
0 Votes"
ReiniellLiwanag-8105 asked Cathyji-msft commented

error in SQL 2019 upgrade

Hello,

Im trying to upgrade my SQL from 2016 to 2019 when I encountered the error. I also tried the Repair feature to resolve it.


Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061527938
Start time: 2021-03-31 04:41:49
End time: 2021-03-31 04:47:39
Requested action: Repair

Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for Replication: Use the following information to resolve the error, and then try the setup process again.


Machine Properties:
Machine name: ODB03
Machine processor count: 4
OS version: Microsoft Windows Server 2016 Datacenter (10.0.14393)
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2016 SSMS 1033 Standard Edition 13.0.16106.4 No Yes
SQL Server 2016 Client Tools Connectivity 1033 Standard Edition 13.0.14500.10 No Yes
SQL Server 2016 Client Tools Backwards Compatibility 1033 Standard Edition 13.0.14500.10 No Yes
SQL Server 2016 Client Tools SDK 1033 Standard Edition 13.0.14500.10 No Yes
SQL Server 2016 Data Quality Client 1033 Standard Edition 13.2.5026.0 No Yes
SQL Server 2016 Integration Services 1033 Standard Edition 13.2.5882.1 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER SQL Server Replication 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Data Quality Services 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSAS15.MSSQLSERVER Analysis Services 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 Data Quality Client 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 Integration Services 1033 Standard Edition 15.0.2000.5 No Yes

Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation location: H:\x64\setup\
Installation edition: Standard

User Input Settings:
ACTION: Repair
AGTDOMAINGROUP: <empty>
AGTSVCACCOUNT: .\SQLServices
AGTSVCPASSWORD: <empty>
AGTSVCSTARTUPTYPE: Automatic
ASCONFIGDIR: Config
ASSVCACCOUNT: NT Service\MSSQLServerOLAPService
ASSVCPASSWORD: <empty>
ASTELSVCACCT: NT Service\SSASTELEMETRY
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: Automatic
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210331_044148\ConfigurationFile.ini
CTLRSTARTUPTYPE: Manual
CTLRSVCACCOUNT: NT Service\SQL Server Distributed Replay Controller
CTLRSVCPASSWORD: <empty>
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FAILOVERCLUSTERGROUP: <empty>
FAILOVERCLUSTERNETWORKNAME: <empty>
FTSVCACCOUNT: NT Service\MSSQLFDLauncher
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: false
INSTANCENAME: MSSQLSERVER
ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service
ISMASTERSVCPASSWORD: <empty>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <empty>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <empty>
ISSVCACCOUNT: NT Service\MsDtsServer150
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: NT Service\SSISTELEMETRY150
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: Automatic
ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service
ISWORKERSVCCERT: <empty>
ISWORKERSVCMASTER: <empty>
ISWORKERSVCPASSWORD: <empty>
ISWORKERSVCSTARTUPTYPE: Automatic
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCPASSWORD: <empty>
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210331_044148\ConfigurationFile.ini

Detailed results:
Feature: Data Quality Services
Status: Passed

Feature: Full-Text and Semantic Extractions for Search
Status: Passed

Feature: Database Engine Services
Status: Passed

Feature: SQL Server Replication
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x851F947E
Error description: There was an error executing the Replication upgrade scripts. See the SQL Server error log for details.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4034.2&EvtType=0x21F8068D%400xC652C608%401311%4038014&EvtType=0x21F8068D%400xC652C608%401311%4038014

Feature: Analysis Services
Status: Passed

Feature: SQL Browser
Status: Passed

Feature: SQL Writer
Status: Passed

Feature: Distributed Replay Controller
Status: Passed

Feature: Integration Services
Status: Passed

Feature: SQL Client Connectivity SDK
Status: Passed

Feature: SQL Client Connectivity
Status: Passed

Feature: Data Quality Client
Status: Passed

Feature: Setup Support Files
Status: Passed

Rules with failures or warnings:

Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210331_044148\SystemConfigurationCheck_Report.htm

The following warnings were encountered while configuring settings on your SQL Server. These resources / settings were missing or invalid so default values were used in recreating the missing resources. Please review to make sure they don’t require further customization for your applications:

Service SID support has been enabled on the service.
Service SID support has been enabled on the service.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ReiniellLiwanag-8105,

Any update for this thread? Did you find any useful error information from error log and SQL setup detail log ? Could please you share the information for us to analysis?

According to your summary log, you have install one SQL 2016 instance, one SQL 2019 instance. Did you want to upgrade the SQL 2016 to SQL 2019 ?

0 Votes 0 ·

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

See the SQL Server error log for details.

As the message says, review the SQL Server ErrorLog and also the installation log for more details

View the SQL Server error log in SQL Server Management Studio (SSMS)
Viewing the SQL Server Error Log

View and Read SQL Server Setup Log Files


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.