Microsoft KB Archive/171331: Difference between revisions
m (Text replacement - ">" to ">") |
m (Text replacement - """ to """) |
||
Line 89: | Line 89: | ||
The problem occurs because the group_limited_access_plan is in a state in which the count of the entries in group_limited_access_plan does not match the number of rows returned by the query: | The problem occurs because the group_limited_access_plan is in a state in which the count of the entries in group_limited_access_plan does not match the number of rows returned by the query: | ||
<pre class="fixed_text"> | <pre class="fixed_text"> "select t.c_group_description, p.i_group_id, i_account_id, i_owner_id | ||
from group_limited_access_plan p, group_type t | from group_limited_access_plan p, group_type t | ||
where p.i_group_id = t.i_group_id order by p.i_group_id | where p.i_group_id = t.i_group_id order by p.i_group_id ". | ||
</pre> | </pre> | ||
This situation should never occur through the use of the administrative tools that ship with Microsoft Membership Server. | This situation should never occur through the use of the administrative tools that ship with Microsoft Membership Server. | ||
Line 100: | Line 100: | ||
== RESOLUTION == | == RESOLUTION == | ||
To resolve this problem, make the following changes to the stored procedure | To resolve this problem, make the following changes to the stored procedure "sp_enum_access_plans":<br /> | ||
<br /> | <br /> | ||
Change | Change | ||
<pre class="fixed_text"> | <pre class="fixed_text"> "select count(*) from group_limited_access_plan" | ||
</pre> | </pre> | ||
to | to | ||
<pre class="fixed_text"> | <pre class="fixed_text"> "select count(*) from group_limited_access_plan p, group_type t | ||
where p.i_group_id = t.i_group_id | where p.i_group_id = t.i_group_id" | ||
</pre> | </pre> | ||
Latest revision as of 11:05, 21 July 2020
Article ID: 171331
Article Last Modified on 9/30/2003
APPLIES TO
- Microsoft Commercial Internet System 1.0 Service Pack 2
This article was previously published under Q171331
SYMPTOMS
Microsoft Membership Agent may not start and may return the following error messages in the Event Viewer logs.
In the system log you will get the following error message:
In the application log you will get the following error messages:
If you started the Membership Agent from the command prompt, you will also get the following error message:
CAUSE
The problem occurs because the group_limited_access_plan is in a state in which the count of the entries in group_limited_access_plan does not match the number of rows returned by the query:
"select t.c_group_description, p.i_group_id, i_account_id, i_owner_id from group_limited_access_plan p, group_type t where p.i_group_id = t.i_group_id order by p.i_group_id ".
This situation should never occur through the use of the administrative tools that ship with Microsoft Membership Server.
RESOLUTION
To resolve this problem, make the following changes to the stored procedure "sp_enum_access_plans":
Change
"select count(*) from group_limited_access_plan"
to
"select count(*) from group_limited_access_plan p, group_type t where p.i_group_id = t.i_group_id"
Keywords: kbusage KB171331