Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 13491016
KB4552478 - FIX: Distribution Agent "Parameterized values for above command" log message is missing - Microsoft Support
Last update date:
11/24/2021
Affected products:
No affected products provided.
Affected releases:
build lower than 15.0.4043.16
Fixed releases:
15.0.4043.16
Description:
Applies to
All versions after Service Pack 3 (SP3) (including it) for SQL Server 2014 All versions after SP2 (including it) for SQL Server 2016 Cumulative update 3 to 19 (both inclusive) for SQL Server 2017 All versions before cumulative update 5 for SQL Server 2019
Symptoms
Assume that you use one of these SQL versions mentioned in the "Applies To" section. If you enable output verbose log for distribution agent, you will notice that the OUTPUT of the Distribution Agent contains summary information that does not include the following information: DateTime Last transaction timestamp: 0x00000033000000ff00bc00000000 Transaction seqno: 0x00000033000001500023 Command Id: 1 Partial: 0 Type: 30 Command: <<ParameterizedCommand>> DateTime sp_MSget_repl_commands timestamp returned: 0x0x0000003300000150002300000000, 1, local rowcount: 1 DateTime Parameterized values for above command(s): {{1.1000, 43659, 2}}sp_MSget_repl_commands timestamp value is: 0x0x0000003300000150002300000000
Resolution
This issue is fixed in the following cumulative updates for SQL Server: Cumulative Update 5 for SQL Server 2019 Cumulative Update 20 for SQL Server 2017 About cumulative updates for SQL Server: Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: Latest cumulative update for SQL Server 2019 Latest cumulative update for SQL Server 2017
Workaround
To work around this issue, you can define OutputVerboseLevel as part of Distribution agent profile parameters. For example, if Distribution agent is using default agent profile, create a new profile and add OutputVerboseLevel parameter with its value there. And then use that profile for distribution agent.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.
