Solved

Index Services query not working on Windows Server 2008 R2 (64 bit)

Posted on 2012-04-13
12
3,268 Views
Last Modified: 2012-04-23
We are moving our web server from a Windows 2003 Server (32 bit) running IIS 6 to a Windows 2008 Server (64 bit) running IIS 7.
We had a knowledge base that we called Infobase that used Index Services and an old ASP web page (query.asp) that used Server.CreateObject("ixsso.Query") to query the indexed directory.
In moving this to the new server, the query.asp page no longer works.
Our Infobase web site is setup using its own Application Pool that has "Enable 32-bit Applications" = False so I do not think that it is a 64 vs 32 bit issue.
I also tried creating an IndexQuery.aspx page following the Microsoft KB 820105 but that does not work either.
When I look at the catalog in "Computer Management" - "Indexing Service" everything seems correct.

Any ideas what might be causing this to not work?
0
Comment
Question by:SCI-Support
  • 7
  • 5
12 Comments
 
LVL 13

Expert Comment

by:Felix Leven
ID: 37845052
Have you installed the "“IIS 6 management Capability Feature” on IIS-7 (add to the Server role) ?
0
 

Author Comment

by:SCI-Support
ID: 37845190
If you meant "IIS6 Management Compatibility" then, Yes, that Role Service is Installed.
How is that pertinent?
0
 
LVL 13

Expert Comment

by:Felix Leven
ID: 37845245
"Application Development," checked "ASP" (Classic) and Not only asp.net (New) ?

To maintain Backwards compatibility to iis6 you Need to enable more Features in iis 7.x
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:SCI-Support
ID: 37845332
Application Development has both ASP.NET installed and ASP installed.
All other ASP websites are running fine on this server.

I am thinking it must be a problem with Indexing Services since I can't get a query page to work regardless of whether I try the old query.asp page or the IndexQuery.aspx page.
See my original post for complete details.  It pretty much spells out the situation.

I notice that Windows 2008 Server no longer has a tree entry to "Query the Catalog" in the Computer Management utility under Indexing Services.

Does anybody actually have an ASP or ASP.NET page that successfully queries a catalog on a Windows 2008 R2 Server (64 bit) ?
0
 
LVL 13

Expert Comment

by:Felix Leven
ID: 37846030
0
 

Author Comment

by:SCI-Support
ID: 37852307
I have pretty much tried all of the things you suggest from those articles.
In "Computer Management", the catalog shows that the Size is 5MB and Total Docs is 723 (which is approximately correct), Docs to Index is 0, Deferred for Indexing is 0, Word Lists is 2, Saved Indexes is 5 and Status is Started.

Although the directory tree that is being indexed is NOT within a WWW Server tree, I tried setting up a Virtual Directory under the web site that I want to query the index from and then chaning the catalog properties under the "Tracking" tab to set the WWW Server to my web site instance and checkmarked "Inherit above settings from Service".  However, none of that made any difference.
0
 

Author Comment

by:SCI-Support
ID: 37858775
As I test this further, I have determined that I will get matching Index Service query results but only for .TXT file types.  Even though Index Services says it has indexed 700+ documents (which are mostly either .HTM or .DOC or .PDF), for some reason neither the old ASP object - i.e. Server.CreateObject("ixsso.Query") - or the ASP.NET OleDB object - using the Provider=MSIDXS - will find matching results unless the file is a .TXT file.

I have installed the Microsoft Filter Pack from http://www.microsoft.com/download/en/details.aspx?id=17062
but that did not seem to make any difference.

Any ideas on what to try next?
0
 
LVL 13

Expert Comment

by:Felix Leven
ID: 37858833
If the Content of a Filetype is Not indexed you Need to get an ifilter for that filetype.

http://en.m.wikipedia.org/wiki/IFilter
0
 

Author Comment

by:SCI-Support
ID: 37861585
MrGraves, please READ what I wrote before responding.
I already installed the Microsoft Filter Pack.

If you know of a specific iFilter pack that will make the Microsoft Indexing Service index .HTM and .DOC and .PDF when apparently the Filter Packs from Microsoft and Adobe do NOT do this, then PLEASE give me the links to where I CAN download those filter packs from.

Giving me a wiki link that describes what an iFilter is not helpful in any way.
0
 
LVL 13

Expert Comment

by:Felix Leven
ID: 37861720
http://www.ifilter.org/Links.htm

Sorry I have no more ideas to solve your problem, lest' see if other experts can help.
0
 

Accepted Solution

by:
SCI-Support earned 0 total points
ID: 37862789
I finally figured out the problem!
At some point in setting up and configuring the Microsoft Indexing Service, the main folder that was being indexed got its Security settings changed so that every file in the folder had an Administrator "lock" icon on it.

I deleted the Index and the folder tree, and reset up the Index.
Now the folder that is being indexed no longer is "locked" to Administrator access only.
All index query searches are once again working.

No idea how the Admin security settings got changed, but problem solved.
0
 

Author Closing Comment

by:SCI-Support
ID: 37880010
The moral of this story is to always check the security settings on any folders being indexed.
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question