BUG: Low Open Databases Value May Cause Logreader Failure

ID: Q189349

The information in this article applies to:

Microsoft SQL Server version 6.5

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 : SSrvAdmin kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug