Knowledge Base

BUG: Low Open Databases Value May Cause Logreader Failure

Article ID: 189349

Article Last Modified on 10/16/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q189349

BUG #: 18152 (SQLBUG_65)

SYMPTOMS

If replication is installed, you may see the following error in the errorlog:

98/07/09 14:26:02.93 spid14 Error : 14151, Severity: 20, State: 1
98/07/09 14:26:02.93 spid14 Replication-LogReader: Task
'MACHINENAME_dbname' failed. The replicated transaction (5634, 1) no
longer exists in the log. Unable to execute sp_repldone on
'MACHINENAME'.

This failure can also be seen in the Last Run Status column for the LogReader task in the Manage Scheduled Tasks window in SQL Enterprise Manager.

CAUSE

The 'open databases' configuration parameter is set lower than the number of recovered databases.

WORKAROUND

To work around this problem, increase the 'open databases' parameter to a number greater than the number of recovered databases. To do this, do either of the following:

Use the sp_configure stored procedure. For the syntax, see the SQL Server Books Online.

-or-
Perform the following steps:
1. Start SQL Enterprise Manager.
2. Right-click the server name and click Configuration on the shortcut menu.
3. On the Configuration tab, change the value for 'open databases'.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: SEM repl

Keywords: kbbug kbpending KB189349