API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 8th, 2025
17
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.11 KB | None | 0 0
raw download clone embed print report
  1. logread.exe -Publisher mssqlsource -PublisherDB sourceDB -PublisherLogin sa -PublisherPassword 1qaz2WSX -PublisherSecurityMode 0 -Distributor mssqlsource -DistributorLogin sa -DistributorPassword 1qaz2WSX -DistributorSecurityMode 0 -EncryptionLevel 0
  2. 2025-04-08 16:16:33.217 Microsoft SQL Server Log Reader Agent 16.0.1000.6
  3. 2025-04-08 16:16:33.217 Copyright (c) 2016 Microsoft Corporation
  4. 2025-04-08 16:16:33.217
  5. 2025-04-08 16:16:33.217 The timestamps prepended to the output lines are expressed in terms of UTC time.
  6. 2025-04-08 16:16:33.217 User-specified agent parameter values:
  7. -Publisher mssqlsource
  8. -PublisherDB sourceDB
  9. -PublisherLogin sa
  10. -PublisherPassword **********
  11. -PublisherSecurityMode 0
  12. -Distributor mssqlsource
  13. -DistributorLogin sa
  14. -DistributorPassword **********
  15. -DistributorSecurityMode 0
  16. -EncryptionLevel 0
  17. 2025-04-08 16:16:33.264 Parameter values obtained from agent profile:
  18. -outputverboselevel 2
  19. -pollinginterval 5000
  20. -historyverboselevel 1
  21. -logintimeout 15
  22. -querytimeout 1800
  23. -readbatchsize 500
  24. -logscanthreshold 500000
  25. 2025-04-08 16:16:33.264 Status: 32768, code: 53044, text: 'Validating publisher'.
  26. 2025-04-08 16:16:33.264 Connecting to OLE DB mssqlsource at datasource: 'mssqlsource', location: '', catalog: 'sourceDB', providerstring: '' using provider 'MSOLEDBSQL'
  27. 2025-04-08 16:16:33.280 OLE DB mssqlsource: mssqlsource
  28. DBMS: Microsoft SQL Server
  29. Version: 16.00.1000
  30. catalog name: sourceDB
  31. user name: dbo
  32. API conformance: 0
  33. SQL conformance: 0
  34. transaction capable: 1
  35. read only: F
  36. identifier quote char: "
  37. non_nullable_columns: 0
  38. owner usage: 15
  39. max table name len: 128
  40. max column name len: 128
  41. need long data len:
  42. max columns in table: 1000
  43. max columns in index: 16
  44. max char literal len: 131072
  45. max statement len: 131072
  46. max row size: 131072
  47. 2025-04-08 16:16:33.280 OLE DB mssqlsource 'mssqlsource': select is_srvrolemember('sysadmin'), is_member ('db_owner')
  48. 2025-04-08 16:16:33.280 OLE DB mssqlsource 'mssqlsource': select db_id()
  49. 2025-04-08 16:16:33.280 Disconnecting from OLE DB mssqlsource 'mssqlsource'
  50. 2025-04-08 16:16:33.280 Connecting to OLE DB at datasource: 'mssqlsource', location: '', catalog: 'distribution', providerstring: '' using provider 'MSOLEDBSQL'
  51. 2025-04-08 16:16:33.296 OLE DB : mssqlsource
  52. DBMS: Microsoft SQL Server
  53. Version: 16.00.1000
  54. catalog name:
  55. user name: dbo
  56. API conformance: 0
  57. SQL conformance: 0
  58. transaction capable: 1
  59. read only: F
  60. identifier quote char: "
  61. non_nullable_columns: 0
  62. owner usage: 15
  63. max table name len: 128
  64. max column name len: 128
  65. need long data len:
  66. max columns in table: 1000
  67. max columns in index: 16
  68. max char literal len: 131072
  69. max statement len: 131072
  70. max row size: 131072
  71. 2025-04-08 16:16:33.296 OLE DB 'mssqlsource': {call sp_MSensure_single_instance(N'Repl-LogReader-0-sourceDB-7', 2)}
  72. 2025-04-08 16:16:33.296 Connecting to OLE DB Publisher at datasource: 'mssqlsource', location: '', catalog: 'sourceDB', providerstring: '' using provider 'MSOLEDBSQL'
  73. 2025-04-08 16:16:33.296 OLE DB Publisher: mssqlsource
  74. DBMS: Microsoft SQL Server
  75. Version: 16.00.1000
  76. catalog name: sourceDB
  77. user name: dbo
  78. API conformance: 0
  79. SQL conformance: 0
  80. transaction capable: 1
  81. read only: F
  82. identifier quote char: "
  83. non_nullable_columns: 0
  84. owner usage: 15
  85. max table name len: 128
  86. max column name len: 128
  87. need long data len:
  88. max columns in table: 1000
  89. max columns in index: 16
  90. max char literal len: 131072
  91. max statement len: 131072
  92. max row size: 131072
  93. 2025-04-08 16:16:33.296 OLE DB Publisher: mssqlsource
  94. DBMS: Microsoft SQL Server
  95. Version: 16.00.1000
  96. catalog name: sourceDB
  97. user name: dbo
  98. API conformance: 0
  99. SQL conformance: 0
  100. transaction capable: 1
  101. read only: F
  102. identifier quote char: "
  103. non_nullable_columns: 0
  104. owner usage: 15
  105. max table name len: 128
  106. max column name len: 128
  107. need long data len:
  108. max columns in table: 1000
  109. max columns in index: 16
  110. max char literal len: 131072
  111. max statement len: 131072
  112. max row size: 131072
  113. 2025-04-08 16:16:33.296 OLE DB Publisher 'mssqlsource': select @@SERVERNAME
  114. 2025-04-08 16:16:33.296 Connecting to OLE DB DISTOLE at datasource: 'mssqlsource', location: '', catalog: 'distribution', providerstring: '' using provider 'MSOLEDBSQL'
  115. 2025-04-08 16:16:33.311 OLE DB DISTOLE: mssqlsource
  116. DBMS: Microsoft SQL Server
  117. Version: 16.00.1000
  118. catalog name: distribution
  119. user name: dbo
  120. API conformance: 0
  121. SQL conformance: 0
  122. transaction capable: 1
  123. read only: F
  124. identifier quote char: "
  125. non_nullable_columns: 0
  126. owner usage: 15
  127. max table name len: 128
  128. max column name len: 128
  129. need long data len:
  130. max columns in table: 1000
  131. max columns in index: 16
  132. max char literal len: 131072
  133. max statement len: 131072
  134. max row size: 131072
  135. 2025-04-08 16:16:33.313 OLE DB DISTOLE: mssqlsource
  136. DBMS: Microsoft SQL Server
  137. Version: 16.00.1000
  138. catalog name: distribution
  139. user name: dbo
  140. API conformance: 0
  141. SQL conformance: 0
  142. transaction capable: 1
  143. read only: F
  144. identifier quote char: "
  145. non_nullable_columns: 0
  146. owner usage: 15
  147. max table name len: 128
  148. max column name len: 128
  149. need long data len:
  150. max columns in table: 1000
  151. max columns in index: 16
  152. max char literal len: 131072
  153. max statement len: 131072
  154. max row size: 131072
  155. 2025-04-08 16:16:33.313 OLE DB DISTOLE 'mssqlsource': select datasource, srvid from master..sysservers where ltrim(substring(reverse(ltrim(substring(reverse(srvname),charindex(',',reverse(srvname))+1,len(srvname)))),charindex(':',srvname)+1,len(srvname))) = N'mssqlsource' collate Latin1_General_CI_AI
  156. 2025-04-08 16:16:33.313 Status: 4096, code: 20024, text: 'Initializing'.
  157. 2025-04-08 16:16:33.313 The agent is running. Use Replication Monitor to view the details of this agent session.
  158. 2025-04-08 16:16:33.313 OLE DB DISTOLE 'mssqlsource': sp_MSget_last_transaction @publisher_id = 0, @publisher_db = N'sourceDB', @for_truncate = 0x0
  159. 2025-04-08 16:16:33.329 OLE DB DISTOLE 'mssqlsource': sp_MSquery_syncstates 0, N'sourceDB'
  160. 2025-04-08 16:16:33.329 OLE DB DISTOLE 'mssqlsource': sp_MSget_last_transaction @publisher_id = 0, @publisher_db = N'sourceDB', @for_truncate = 0x1
  161. 2025-04-08 16:16:33.329 Publisher: {call sp_repldone ( 0x00000000000000000000, 0x00000000000000000000, 0, 0)}
  162. 2025-04-08 16:16:33.329 Status: 0, code: 20011, text: 'The process could not execute 'sp_repldone/sp_replcounters' on 'mssqlsource'.'.
  163. 2025-04-08 16:16:33.329 The process could not execute 'sp_repldone/sp_replcounters' on 'mssqlsource'.
  164. 2025-04-08 16:16:33.329 Status: 0, code: 18757, text: 'Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication.'.
  165. 2025-04-08 16:16:33.329 Status: 0, code: 22017, text: 'The process could not set the last distributed transaction.'.
  166. 2025-04-08 16:16:33.329 Status: 0, code: 22037, text: 'The process could not execute 'sp_repldone/sp_replcounters' on 'mssqlsource'.'.
  167. 2025-04-08 16:16:33.329 Disconnecting from OLE DB DISTOLE 'mssqlsource'
  168. 2025-04-08 16:16:33.782 Disconnecting from OLE DB DistLog 'mssqlsource'
  169. 2025-04-08 16:16:33.782 Disconnecting from OLE DB Publisher 'mssqlsource'
  170. 2025-04-08 16:16:33.782 Disconnecting from OLE DB 'mssqlsource'
  171.  
  172.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!