Microsoft KB Archive/189349

= BUG: Low Open Databases Value May Cause Logreader Failure =

Article ID: 189349

Article Last Modified on 10/16/2003

-

APPLIES TO


 * 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:


 * Start SQL Enterprise Manager.
 * Right-click the server name and click Configuration on the shortcut menu.
 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.