SQL Server Errors or Failures from Error: 18840 to Error: 19032
Error: 18840, Severity: 16, Cannot locate database information in the article cache. Stop and restart SQL Server and the Log Reader Agent. If the problem persists, back up the publication database, and then contact Customer Support Services.
Error: 18842, Severity: 16, Failed to retrieve the oldest active log sequence number (LSN) from a commit record. Stop and restart SQL Server and the Log Reader Agent. If the problem persists, reinitialize all subscriptions to the publication.
Error: 18843, Severity: 16, Failed to allocate or reallocate buffer for replication command, old size %d, new size %d.
Error: 18844, Severity: 16, Invalid compensation range: begin {%08lx:%08lx:%04lx}, end {%08lx:%08lx:%04lx}. Reinitialize all subscriptions to the publication.
Error: 18845, Severity: 16, Cannot retrieve the rowset ID from log records generated from a text pointer based operation. Reinitialize all subscriptions to the publication.
Error: 18846, Severity: 16, Possible inconsistent state in the distribution database: dist_backup_lsn {%08lx:%08lx:%04lx}, dist_last_lsn {%08lx:%08lx:%04lx}. Execute “sp_repldone NULL, NULL, 0, 0, 1”, and then execute sp_replflush. Reinitialize all subscriptions to the publication.
Error: 18847, Severity: 16, Cannot retrieve the peer-to-peer database information. Contact Customer Support Services.
Error: 18849, Severity: 16, Failed to evaluate the filter procedure or computed column. Cannot find the column offset information for column ID %d, rowsetId %I64d. Stop and restart the Log Reader Agent. If the problem persists, back up the publication database and then contact Custo
Error: 18850, Severity: 16, Unexpected %s log record encountered, last FILESTREAMInfo node processed : {%d, {{%I64d, %I64d}, %I64d, %I64d, %d, %d}, %d, %ld, %I64d, %I64d, %I64d, %I64d, {%08lx:%08lx:%04lx}, %d, {{%I64d, %I64d}, %I64d, %I64d, %d, %d}, {%08lx:%08lx:%04lx}}
Error: 18851, Severity: 16, Failed to %s the replication context for TxF: {%I64d, %.*ls, %ld, %ld, %I64d, %I64d, %I64d, %I64d, {%08lx:%08lx:%04lx}, %I64d, %.*ls, {%08lx:%08lx:%04lx}}. If the problem persists, contact product support.
Error: 18852, Severity: 16, Failed to read the TXF_REPLICATION_RECORD_WRITE structure. Last error returned ‘%ld’. If the problem persists, contact Customer Support Services.
Error: 18853, Severity: 10, Replication is skipping schema version logging because the systranschemas table is not present in database ‘%d’. This is an informational message only. No user action is required.
Error: 18854, Severity: 16, One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error.
Error: 18855, Severity: 11, Can not rename the database name because it is published or it is a distribution database used by replication.
Error: 18856, Severity: 16, Agent ‘%s’ is retrying after an error. %d retries attempted. See agent job history in the Jobs folder for more details.
Error: 18857, Severity: 16, The subscription to this publication is not active yet. No user action is required.
Error: 18896, Severity: 16, Failed to compare delete and insert log record for column ID %ld with table ID %ld
Error: 19030, Severity: 10, SQL Trace ID %d was started by login “%s”.
Error: 19031, Severity: 10, SQL Trace stopped. Trace ID = ‘%d’. Login Name = ‘%s’.
Error: 19032, Severity: 10, SQL Trace was stopped due to server shutdown. Trace ID = ‘%d’. This is an informational message only; no user action is required.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.