KB4552478 - FIX: Distribution Agent "Parameterized values for above command" log message missing after SQL Server 2017 and 2019 upgrade

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise Core on WindowsSQL Server 2017 Enterprise on Windows

Symptoms


Assume that you upgrade SQL Server (Cumulative Update 3 for Microsoft SQL Server 2017 or later versions) to support dynamic loading of the Distribution Agent. After the upgrade, you notice that the OUTPUT of the Distribution Agent parameters 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

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This issue is fixed in the following cumulative updates for SQL Server:
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:

Workaround


To work around this issue, you can defineOutputVerboseLevel as part of Distribution agent profile parameters. For example, if Distribution agent is using default agent profile, create a new profile andadd OutputVerboseLevel parameter. The value given inside the profile is not considered since the value mentioned in the command line parameter gets thepriority.

References


Learn about the terminology that Microsoft uses to describe software updates.