BUG: Low Open Databases Value May Cause Logreader Failure (189349)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbBug kbpending KB189349 |
|---|
|