The Rule Manager PRF Files Cause the ASP to Fail with an OLE DB Error (257680)
The information in this article applies to:
- Microsoft Site Server 3.0
This article was previously published under Q257680 SYMPTOMS
When you create a new rule file with the Microsoft Site Server Rule Manager, the associated Active Service Pages (ASP) page may fail to install and you receive the following error message:
Microsoft OLE DB Provider for Indexing Service (0x80070057)
The parameter is incorrect.
/folder/MyRuleFile.prf, line 268
CAUSE
This error message occurs because the OLE DB Provider is indicating that the SELECT statement contains too many columns.
The design of content management is to create content sources that have content types containing attributes. The Membership Directory contains a list of all the attributes assigned to a content source in the mustContain attribute. Each time an attribute is added to a content type, all of the associated content sources are appended to the mustContain attribute. This list grows as you install content management.
Microsoft Site Server Rule Manager copies the mustContain attributes to the select_list. The select_list is a list of all the columns requested in the SELECT statement contained in the PRF file. Microsoft Index Server 2.0 allocates only 16k bytes of memory for each row. This is the limit in the number of columns you can request in a SELECT statement. If there are too many attributes in the mustContain attribute list, your query fails.
RESOLUTION
To resolve this problem, add any attribute to a content type that you return in an ASP query page.
WORKAROUND
The following are three possible work arounds for this problem: - Open the Site Server Service Admin (MMC), select Membership Directory Manager, click ou=Admin, click ou=Other, click ou=ContentClasses, and then click cn=<ContentSource Name>. Double-click Properties. A full list of attributes, including the must-contain attribute, is displayed. Edit the list so that it is less than 55 attributes. Each time you use the Rule Manager, only the attributes you selected are added to the PRF file.
- Indexing Service (TripoliSource) and Site Server Search (netLibrarySource) are two possible types of content sources. This information is located in the metabase by viewing ou=ContentClasses. If you use Index Server 2.0, the column limit is approximately 55 attributes. If you use Indexing Service included in Windows 2000, the column limit is approximately 600 attributes. If you use Site Server Search, the column limit is approximately 32 attributes on both Windows NT 4.0 and Windows 2000 computers. All attribute limits depend on the size of each column.
- Manually edit the SELECT statement in the PRF file to remove the columns that you do not need returned in the ASP query page.
STATUSMicrosoft has confirmed that this is a problem in Microsoft Site Server. MORE INFORMATION
| Modification Type: | Major | Last Reviewed: | 4/29/2000 |
|---|
| Keywords: | kbbug KB257680 |
|---|
|