[SOLVED] KB5015143 & KB5014365 fails with error 0x80070643

[Maxstar]

Do you have another SQL server running to check if the (PolyBase) services exist?

 

[Gratiskeder]

I've checked a lot of other servers now and none of them have any services with "PolyBase" in the name.
I don't think i personally have seen that service on a server before, as I can remember.

 

[Maxstar]

Okay, then data virtualisation is not being used on this server. Introducing data virtualization with PolyBase - SQL Server

SQL Server Setup has encountered the following error:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Error code 0x84B10001.

Maybe, we can find some more info in the following logfile: %Program Files%\Microsoft SQL Server\130\Setup Bootstrap\Log

 

[Gratiskeder]

There's a lot og logs going way back here.
I have taken everything from today and the summary. If you need more then please let me know.

 

[Maxstar]

I am going to ask some advise on this, but it is vacation time so it can take some time before I come back to you.

 

[Gratiskeder]

Perfectly fine. I won't run any where for now.

 

[Maxstar]

Hi,

I found the following link which describes the same error message, but for Server 2012: SQL Error – Index (zero based) must be greater than or equal to zero and less than the size of argument list

Are you able to run Windows Update with Process Monitor enabled? So we can take a look at the ProcMon trace to see what happens.

Step#1 - Capture Process Monitor Trace
1. Download and run Process Monitor. Leave this running while you perform the next steps.
2. Try updating the system just like you have in the past.
3. Stop Process Monitor as soon as it fails. You can simply do this by clicking the square (CTRL +E) on the toolbar as shown below.



4. Select the File menu...Save... and save the file to your desktop. This is likely the default location. The name (unless changed) will be LogFile.PML. This is fine.
5. Zip up the LogFile.PML and upload it to WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free and provide the link.

 

[Gratiskeder]

Here you go - Logfile.zip

 

[Maxstar]

Hi,

Please perform the following steps to check if these registry keys are present.

HKLM\SOFTWARE\Microsoft\Fusion\PublisherPolicy\Default\v4.0_policy.13.0.Microsoft.SqlServer.Chainer.Setup.resources_en_89845dcd8080cc91
HKLM\SOFTWARE\Microsoft\Fusion\PublisherPolicy\Default\policy.13.0.Microsoft.SqlServer.Chainer.Setup.resources_en_89845dcd8080cc91

• Click the Start button and in the search box, type Command Prompt
• When you see Command Prompt on the list, right-click on it and select Run as administrator.
• Copy and paste the following command line and press Enter.

reg export "HKLM\SOFTWARE\Microsoft\Fusion\PublisherPolicy\Default" "%userprofile%\desktop\regexp.txt"

• When finished, a logfile called regexp.txt is saved on your desktop.
• Post the logfile as attachment in your next reply.

 

[Gratiskeder]

Here you go

 

[Maxstar]

Can you please attach a REG export from another SQL server as well?

 

[Gratiskeder]

Here

 

[Maxstar]

Hi,

• Click the Start button and in the search box, type Command Prompt
• When you see Command Prompt on the list, right-click on it and select Run as administrator.
• Copy and paste the following command line and press Enter.

reg export "HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Microsoft SQL Server SQLServer2016" "%userprofile%\desktop\regexp.txt"

• When finished, a logfile called regexp.txt is saved on your desktop.
• Post the logfile as attachment in your next reply.

 

[Gratiskeder]

Here you go

 

[Maxstar]

Thanks, can you please perform the same steps for the following key.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

 

[Gratiskeder]

Another one

 

[Maxstar]

Please run the following command to restore an empty value:

reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130" /v CollectorParameters /t REG_SZ /d " MSSQL13.MSSQLSERVER" /f

Afterwards, run this command to check the restored value: copy and paste the result in your next post.

reg query "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130"

 

[Gratiskeder]

Runned successfully,

C:\Windows\system32>reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130" /v CollectorParameters /t REG_SZ /d " MSSQL13.MSSQLSERVER" /f
The operation completed successfully.

C:\Windows\system32>reg query "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130"

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130
    CustomerFeedback    REG_DWORD    0x1
    EnableErrorReporting    REG_DWORD    0x1
    SharedCode    REG_SZ    C:\Program Files\Microsoft SQL Server\130\Shared\
    VerSpecificRootDir    REG_SZ    C:\Program Files\Microsoft SQL Server\130\
    ErrorReportingDir    REG_SZ    C:\Program Files\Microsoft SQL Server\130\Shared\ErrorDumps\
    CollectorParameters    REG_SZ     MSSQL13.MSSQLSERVER
    TimeOfReporting    REG_DWORD    0xf0

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\13.0
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\Bootstrap
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\ConfigurationState
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\Machines
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\Replication
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SQLServer2016
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SSIS
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\Tools
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\UpgradeIncompleteState

 

[Maxstar]

Great, please try to install the updates and let me know the result.

 

[Gratiskeder]

Still the same,

Error 0x80070643

TITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Error code 0x84B10001.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xDBFE1571%25400x3FB6F251

------------------------------
BUTTONS:

OK
------------------------------