Search Server: Developers and Customization Forum

Unknown hard error and soft error in search server log

Wed, 25 Nov 2009 19:14:08 Z

Hi all,

These error messages appeared in our search server log. Does anyone have a clue of what could be causing them?

Timestamp                  Process                TID       Area                       Category                       EventID    Level         Message     Correlation
11/25/2009 08:45:12.59     w3wp.exe (0x0084)   0x104C    Search Server Common       MS Search Query Processor     0    Medium     HardError added: 0x80070079 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1053
11/25/2009 08:45:12.59     w3wp.exe (0x0084)   0x104C    Search Server Common     MS Search Query Processor     0    Medium     HardError added: 0x80070002 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1053
11/25/2009 08:45:12.59     w3wp.exe (0x0084)   0x104C    Search Server Common       MS Search Query Processor     0    Medium     SoftError added: 0x80041605 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070
11/25/2009 08:45:12.59     w3wp.exe (0x0084)   0x104C    Search Server Common       MS Search Query Processor     0    Medium     SoftError added: 0x8004161a - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070
11/25/2009 08:45:12.59     w3wp.exe (0x0084)     0x104C    Search Server Common     MS Search Query Processor     0    Medium     SoftError added: 0x80041606 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070
11/25/2009 08:45:12.59     w3wp.exe (0x0084)     0x104C    Search Server Common       MS Search Query Processor     0    Medium     SoftError added: 0x80044101 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070
11/25/2009 08:45:12.59     w3wp.exe (0x0084)     0x104C    Search Server Common       MS Search Query Processor     0    Medium     SoftError added: 0x80041607 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070
11/25/2009 08:45:12.59     w3wp.exe (0x0084)     0x104C    Search Server Common       MS Search Query Processor     0    Medium     SoftError added: 0x80041619 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070
11/25/2009 08:45:12.59     w3wp.exe (0x0084)     0x104C    Search Server Common       MS Search Query Processor     0    Medium     SoftError added: 0x80041602 - File:d:\office\source\search2\ytrip\tripoli\icommand\qpcache.cxx Line:1070

Best Regards,
Ivan Clay

Returning a URL other than the indexed one

Fri, 27 Nov 2009 04:16:14 Z

I am developing a custom protocol handler for Search Server and Desktop Search.

When running under Search Server, I want to use my custom protocol handler and private URLs (myprotocol://server/whatever) for indexing, but set the indexed items so that when they are queried from the standard Search Server web pages (i.e. Default.aspx, Results.aspx) they display a different URL (e.g. http://someserver.com/somethingelse?morestuff). Is it possible to do this? I've tried the following so far:

- indexing a property using the Shell schema property System.ItemUrl, with the new HTTP value

- indexing a property using the Search Server property "ows_URL", with the new HTTP value

The first approach resulted in every item being crawled with a warning "Content for this URL is excluded by the server because a no-index attribute", displaying the HTTP url. I tried adding specifically the stem of the HTTP url as an included crawl rule, with no effect.

In the second approach everything indexed correctly, but the returned URLs are still the indexed (i.e. myprotocol) ones.

So, is there any way of doing what I want here?

Thanks
Grant

Search Indexer seems to hang when indexing

Wed, 25 Nov 2009 02:53:51 Z

We have a strange problem when indexing a large data set under Search Server Express, using our own custom search protocol handler. Everything runs fine, until, usually, 20480 items have been indexed, and then everything stops. The CPU usage is zero, and all running crawls indicate that they are still running. The administration pages all still respond. But no further indexing is seen (indicated by the crawl logs). If we give the OSearch service a slap around the head (stop and restart), it then carries on from exactly where it appeared to hang, for another, you guessed it, 20480 items. At which point it hangs again. A couple of times we have seen indexing hang after 10240 items instead of 20480. But the numbers are exact.

If a crawl from a different crawl source (e.g. the default SharePoint source) is running, it appears to hang also. If we try to stop the running crawls their status changes to Stopping, and never changes from that.

Monitoring the resource usage of the protocol host processes show that our protocol is not consuming any resources. The same protocol handler is used with Desktop Search, and there it has no problems indexing more than 20k items.

There are no relevant entries in the Application Event Log.

Are there any known issues or strange behaviour that regularly take place after multiples of 10k items have been indexed? We are utterly stumped here, and this is looking like a show stopper.

Problem with MS Search Server 2008 Express, when I use Contains predicate

Mon, 23 Nov 2009 18:46:20 Z

Hello all,

I am facing a problem with Microsoft Search Server 2008 Express. I built a customized search application using Microsoft Search Server Express. In this application I used the “Like” predicate to filter the path managed property.

Following instructions found in MS forums about the 64 character limitation associated to the Like predicate ( http://social.microsoft.com/Forums/en-US/Offtopic/thread/12ea7757-7ca7-42b8-9ed2-59acd00d283d ), we changed the code to use the “Contains” predicate. Now it returns several results in development environment, but none in production environment.

The query is as follows:

SELECT Rank, Title, Path, HITHIGHLIGHTEDSUMMARY, FileExtension, Created, Size FROM SCOPE() WHERE isDocument=1 AND "scope"='Geral' AND FREETEXT(DEFAULTPROPERTIES,'pdf') AND (CONTAINS(Path, 'file://xxxxx/xxxxxx/x/x/')) ORDER BY Rank DESC'

We checked the Sharepoint log, and observed that the query is composed by an SQL part and a Tripoli part. The SQL part of the query returns thousands of candidates, but the Tripoli part brings zero candidates. So the join does not bring any results. Also, no error or exception appears in the log, even in verbose mode.

Any ideas of what could be the problem?

Besides, I have the following questions:

1. Is it recommended to use wildcard (*) to match subfolders using the Contains predicate?

2. There are some differences between the test and production environments. One of them is regarding Culture/Language. We developed the application in Windows XP, tested it in a Windows 2003 Server (Portuguese PT-BR) and the production environment is Windows 2003 Server (English EN-US). Should this language configuration difference be a cause for no result being returned?

Best Regards,

Ivan Clay

literal string seach on OCR documents different results in SSE 2008 and SPS2003

Wed, 09 Sep 2009 18:43:47 Z

I have an existing search solution that was built on Sharepoitn 2003, that searches a file share of pdf documents that have been OCR'd. In that system a literal string search for "Sample collection date/Time 08-Aug-2009" will correctly return the document(s) that I am looking for.

I have a search server express 2008 setup to crawl the same file shares. In this install the same search returns no results.

Any ideas on if the crawl/index/search settings can be manipulated to return the same resutls in both?

Locating Domain Controller

Thu, 19 Nov 2009 14:08:47 Z

Hi all,

I have a domain controller on Windows 2008 as dc.win2k8.com.
I made my WinXP 64 bit to join that domain, which is completed successful.

Now i have an application which want to create a user on the domain-controller. something like

newuser.exe <domain name> <user> <password>

which internally uses DsGetDcName function as:

status = DsGetDcName(NULL,
domainname,
NULL,
NULL,
DS_FORCE_REDISCOVERY,
&domainControllerInfo);

When this gets executed, I always get:

status == ERROR_NO_SUCH_DOMAIN

I run this as :
newuser.exe dc test testingPWD123
or
newuser.exe dc.win2k8.com test testingPWD123

Note: When i ran the same executable on the DC itself it run fine..

Please help..

Thanks.

Filter result by lang

Wed, 18 Nov 2009 15:30:36 Z

Hi

my request is this one :

<QueryPacket xmlns=""urn:Microsoft.Search.Query"">
<Query>
<SupportedFormats><Format>urn:Microsoft.Search.Response.Document:Document</Format></SupportedFormats>
<Context>
<QueryText type=""MSSQLFT"" language=""{1}"">{0}</QueryText>
</Context>
<Range>
<StartAt>{2}</StartAt>
<Count>{3}</Count>
</Range>
<EnableStemming>true</EnableStemming>
<TrimDuplicates>true</TrimDuplicates>
<IgnoreAllNoiseQuery>true</IgnoreAllNoiseQuery>
<ImplicitAndBehavior>true</ImplicitAndBehavior>
<IncludeRelevanceResults>true</IncludeRelevanceResults>
<IncludeSpecialTermResults>true</IncludeSpecialTermResults>
<IncludeHighConfidenceResults>true</IncludeHighConfidenceResults>
</Query>
</QueryPacket>

so {1} is replaced with the appropiated value but it doesn't work. I find this : http://msdn.microsoft.com/en-us/library/ms466955.aspx but it's not realy clear. Is this paramater only use for keyword? what can id do?

regards

IncludeSpecialTermResults returns no Best Bets

Wed, 18 Nov 2009 01:48:27 Z

I've recently started working with the Microsoft Search Server 2008 Express web service and am having an issue with the Best Bets and IncludeSpecialTermResults.

When I do a search for a given term in the Search Center, the two Best Bets I've created come up before the results.

When I have IncludeSpecialTermResults set to true in the QueryEx request I make using the web service, the SpecialTermResults always returns a row count of 0 - regardless of Search Term - so if I search for the previous term which showed Best Bets on the out-of-the-box Search Center, it still returns no results in the SpecialTermResults table.

Has anyone else encountered this issue? Or is it a configuration thing somewhere I'm missing.

Thanks,
Marty

store procedure for executing ssis package

Tue, 17 Nov 2009 14:27:18 Z

hi ..

can any one please help me with the syntax for executing ssis pacakage by writing a store procceudre in sql server . and parallely the store procedure should have a variable which should take the values which i am specifing and use it as a variable values in the contorl flow......

thanks a lot in advance.

Does anyone know if there is a limitation for the file path size in MS Search Server 2008 Express?

Fri, 13 Nov 2009 19:06:55 Z

Hello all,

I work in a project to develop a search application using MS Search Server 2008 Express as the search engine.

The application is already being tested, but we detected a problem that impacts the results returned by the application.

We were able to generate a trace analysis of the process using SQL PROFILER tool. We discovered that the query string sent by the search engine to the database was being trucated after the 64th caracter,like in the example below:

real file path search: N'file://168.201.168.10/server/university/campus/files/search/1/0/%';

returned file path search: N'file://168.201.168.10/server/university/campus/files/search/1/0/'

Note that, in the example above, the last character ('%'), that occupies the 65th string position, was discarded.

Does anyone know if there is a limitation for the file path size in MS Search Server 2008 Express?

Best Regards,

Stop SQL Server doing an unneccessary clustered index insert on a view

Tue, 10 Nov 2009 14:59:00 Z

Hi

I have a large table (between 74 and 88million rows) which is the middle table (Table B) of a many to many relationship. I have a view that builds a unified picture of the data contained in the these tables. The view has a clustered index defined against it.

Table A on the left hand side of my large table is the core table in my database. Table C is the table that contains the normalised data items. When I insert a new record into table C the task takes a long time to complete (5mins on a very very good server). This is because SQL server rebuilds part of the clustered index on the view (I can see a clustered index insert in the actual execution plan). This is despite the new row in Table C not being referenced in Table B. Inserting rows into Table A and Table B takes milliseconds as I would expect. The database is not partitioned.

This is an annoymised version of the tables creation script. I've left the columns that aren't used in so you can see the full structure of the tables.

CREATE TABLE [dbo].[TableA] (
[TableAId] [INT] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ,
[TableAIdGUID] [uniqueidentifier] NOT NULL,
[ImportantId] [INT] NOT NULL ,
[DateCreated] [datetime] NOT NULL ,
[OtherId2] [int] NOT NULL ,
[TableATypeId] [int] NOT NULL ,
[Active] [bit] NOT NULL ,
[AuditUser] [NVARCHAR] (20) NULL ,
[AuditTime] [datetime] NULL
)
GO

CREATE TABLE [dbo].[TableB] (
[TableBId] [INT] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ,
[TableBGUID] [uniqueidentifier] NOT NULL,
[TableAId] [INT] NOT NULL ,
[TableCId] [INT] NOT NULL ,
[Tag] [NVARCHAR] (50) NULL ,
[Order] [tinyint] NOT NULL ,
[DateCreated] [datetime] NOT NULL ,
[Date1] [datetime] NULL ,
[Date2] [datetime] NULL ,
[LastUpdated] [datetime] NOT NULL ,
[Active] [bit] NOT NULL ,
[AuditUser] [NVARCHAR] (20) NULL ,
[AuditTime] [datetime] NULL
)
GO

CREATE TABLE [dbo].[TableC] (
[TableCId] [INT] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ,
[TableCIdGUID] [uniqueidentifier] NOT NULL,
[TableCTypeId] [int] NOT NULL ,
[TableCValue] [NVARCHAR] (255) NOT NULL ,
[Frequency] [float] NOT NULL DEFAULT 1,
[TableCValue2] [NVARCHAR] (255) NULL ,
[AuditUser] [NVARCHAR] (20) NULL ,
[AuditTime] [datetime] NULL
)
GO

CREATE VIEW [dbo].[vwTables]
WITH SCHEMABINDING ,ENCRYPTION
AS

SELECT dbo.[TableB].TableBId,
dbo.[TableB].TableAId,
dbo.TableA.ImportantId,
dbo.TableC.TableCValue,
dbo.TableC.TableCValue2,
dbo.TableC.TableCTypeId,
dbo.TableA.TableATypeId
FROM dbo.[TableB] INNER JOIN
dbo.TableC ON dbo.[TableB].TableCId = dbo.TableC.TableCId INNER JOIN
dbo.TableA ON dbo.[TableB].TableAId = dbo.TableA.TableAId
WHERE (dbo.[TableB].Active = CAST(1 AS BIT)) AND (dbo.TableC.TableCValue<>'') and (dbo.TableC.TableCValue is not null)
GO

CREATE UNIQUE CLUSTERED INDEX [IX_vwTables] ON [dbo].[vwTables]
(
[TableCValue] ASC,
[TableCTypeId] ASC,
[TableBId] ASC,
[ImportantId] ASC
)
GO

ALTER TABLE [dbo].[TableB] ADD
CONSTRAINT [FK_TableB_TableC] FOREIGN KEY
(
[TableCId]
) REFERENCES [dbo].[TableC] (
[TableCId]
),
CONSTRAINT [FK_TableB_TableA] FOREIGN KEY
(
[TableAId]
) REFERENCES [dbo].[TableA] (
[TableAId]
)
GO

CREATE NONCLUSTERED INDEX [IX_TableA_Nonclustered] ON [dbo].[TableA]
(
[ImportantId] ASC,
[TableAId] ASC,
[TableATypeId] ASC,
[Active] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_TableA_OtherId2] ON [dbo].[TableA]
(
[AuditTime] ASC,
[OtherId2] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_TableB_NonClustered] ON [dbo].[TableB]
(
[TableAId] ASC,
[TableBId] ASC,
[Active] ASC
)
GO

CREATE NONCLUSTERED INDEX [IX_EntityAttributes_NonClustered_2] ON [dbo].[TableB]
(
[TableBId] ASC,
[TableAId] ASC,
[TableCId] ASC,
[Tag] ASC,
[Active] ASC
)
GO

Does anyone know why SQL Server decides it needs to rebuild part of the index when I insert into TableC and not TableA or TableB and how I can prevent it from doing so.

Thanks in advanced.

Search results depends on sequence of words

Fri, 06 Nov 2009 17:19:31 Z

We have few 100 items within a SharePoint List. We use SSE for indexing this list. We try to implement some kind of wildcard functionality by using the SSE Search WebService. http://<server>/_vti_bin/search.asmx. We get some results but somehow they are unpredictable.

For Example:

We have the following data

1 2009 cb1fc11bc79d - 12-10- 2009
2 UNITTEST - 12-10-2009
3 Lorem Ipsum, Lorem met Ipsum Dolar - Related to xxx
4 Related to xxx - Lorem Ipsum, Lorem met Ipsum Dolar

Searched for: like '%2009%'
Row 1 is returned

Searched for: like '%met%'
Row 3 is returned

We use this query (simplified) to search.
<QueryText type="MSSQLFT" language="en-us">select title from scope() where title like '%met%'
</QueryText>

We miss row 2 and 4, while they contain the exact same data only in a different sequence.

Can someone please help?

Thanks
Rene

Use the Company property in Advanced Search?

Thu, 22 Oct 2009 15:15:37 Z

I've added the Search web part to my SharePoint site, and I've noticed that in the Advanced Search section, if I select "Word Document" from Result Type, the Property drop-down exposes two extra values - "Company" and "Manager". I've added these as columns to various of my Document Libraries but if I enter a search to find documents that contain Company = <search string> (where <search string> can be a single letter, which I know ought to return a collection of documents). So I'm a bit confused - how can I get this to work? My site needs to classify the documents by Company (there will eventually be about 100,000 documents in it) and the users need to search for documents sent to a particular company, so....

Any thoughts?

Thanks

Edward

Search Server 14 Express - installation doesn't start

Mon, 31 Aug 2009 13:03:06 Z

Hi guys!

I just tried to install the new "Search Server 14 Express Edition" (Technical Preview!)on a new virtual machine with Win2003 Server (latest patches installed) but after deflating the archives only the installation gui appears but when I click either "install software prerequisites" or "install search server" nothing happens.

I configured the server as an "application server" and installed wss3.0, .net 3.5, and the Windows Workflow Foundation manually (since these were prereqs for the Search Server).
WSS3.0 works fine so the IIS is configured correctly. ;-)

I had the same problems with Search Server 2008 Express too, so I thought somebody may throw an idea into my direction...

Anyone with ideas whats going wrong?

Thanks in advance!

Frank

why to use VS2008 to develop for wince 5.0

Fri, 16 Oct 2009 11:55:17 Z

I just started development for wince 5.0 using embedded vc++ 4.0, i want to use c++ api. Then i noticed that in visual studio 2008, there is a feature to create projects for wince.

My question is: what is the difference when using embedded vc++ 4.0 or VS2008 to develop for wince? What advantages/disadvantages in both? How i have to decide which one to use?

Help is appreciated.

ssas

Thu, 15 Oct 2009 15:40:19 Z

can i create one hierarchy from two or more dimension tables ?????

Federated Search on File Servers and Exchange Server Public Folders

Thu, 08 Oct 2009 06:10:32 Z

Hi,

I want to use Federated Search webparts to show up search results from File Share and Exchange Server Publich Folders.
I have few questions in this regard:
a) Do I need to write Federated Search Connector or will I have to create content sources in MS Search Server for above mentioned data sources?
b) How to write .FLD files for configuring federated search for FileShare and Exchange Server Publich Folders?
c) How to configure security for above data sources so that only data valid for currently logged in user is visible?

I will be grateful for any guidance in this regard.

Thanks,
Gaurav

crawled properties from my asp pages not available on my search.asmx search result

Wed, 07 Oct 2009 19:27:47 Z

I have my crawled propeties scanned and indexed on my Search Express 2008. I can even see those asp pages are reported being using in Search Admin > metadata properties but those crawled properties aren't available on my search result from search.asmx QueryEx

for example: I have an asp page has the following meta tag, and I've mapped those crawled properties to managed properties and also did full crawl.
<meta name="ExpiryDate" content="3/28/2010">
<meta name="Contact" content="William Smith">
<meta name="dc.date.created" content="2/2/2004">
<meta name="dc.date.modified" content="5/8/2009">

when I have my QueryEX

select title, path, fileextension, HitHighlightedSummary, created, enddate, FileName, size, rank, author, write, sitename
from scope()
where freetext('testing')
and sitename = 'http://intranet'
and (fileextension = 'HTML' or fileextension = 'HTM' or fileextension = 'ASP' or fileextension = 'DOC' or fileextension = 'XLS' or fileextension = 'PDF' )
order by rank desc

XML result (see .doc has enddate, created and wirte but none for asp page)

- <RelevantResults diffgr:id="RelevantResults266" msdata:rowOrder="265">

<TITLE>Monday, May 12, 2008</TITLE>

<PATH>http://intranet/content/bulletin/08-05-eng/media0512.asp</PATH>

<HITHIGHLIGHTEDSUMMARY><ddd/> story of the 1980 <c0>Banff</c0> maulings from a grizzly's perspective</HITHIGHLIGHTEDSUMMARY>

<FILENAME>media0512.asp</FILENAME>

- <AUTHOR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<string>Denise Guindon</string>

</AUTHOR>

<SITENAME>http://intranet</SITENAME>

</RelevantResults>

- <RelevantResults diffgr:id="RelevantResults268" msdata:rowOrder="267">

<TITLE>Ecological Monitoring and Reporting Working Plan 2004-05</TITLE>

<PATH>http://intranet/content/eco-re/orig/banff 08-09 workplan_e.doc</PATH>

<HITHIGHLIGHTEDSUMMARY><ddd/> aerial survey of <c0>Banff</c0> (every 5 years), with implications for caribou, moose, and carnivore populat <ddd/> Institute <c0>Banff</c0> Springs Snail 0 0 Monitor snail population and habitat attributes Completed Fores <ddd/> y 2 3 3 3 1 3 3 3 <c0>Banff</c0> Springs Snail - Species at Risk</HITHIGHLIGHTEDSUMMARY>

- <ENDDATE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

</ENDDATE>

<FILENAME>banff 08-09 workplan_e.doc</FILENAME>

- <AUTHOR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<string>Stephen McCanny</string>

<string>Stephanie Wong</string>

</AUTHOR>

<SITENAME>http://intranet</SITENAME>

</RelevantResults>

it returns only those .doc, .ppt and .xls has "created","write" and "enddate", none of those from any asp pages.

is there anything I have to enable ?

Is it possible? Combining Database Content Source and File System Content Source...

Wed, 12 Aug 2009 20:08:18 Z

Hello everyone,

I was wondering if there was a way in Search Server Express to combine results from the file system and a database? We are thinking of creating an application (small DMS I guess) that will have files stored on the file system that we want to crawl and then having meta-data stored for each document in a database that we also want to crawl, but the search results to direct people to the documents the meta-data is for.. The documents are PDF files, AutoCad files, and various image format files.

Thanks in advanced,

Greg

Cannout install "MS SQL Server 2008 Developer"

Mon, 21 Sep 2009 01:48:15 Z

Yesterday, I downloaded the MS SQL Server 2008 Developer in my company PCs, and wanted to install it; however, the installation was failed as the checker mentioned "Performance counter registry hive consistency" is failed. What can I do?

Besides, my computer os is Window Vista(TM) Business SP1 (chinese version). The most interesting thing is that when I install it in a PC with English version, it works. Thus, I would also like to question if it is the problem of language setting of the OS. Thank you.

retrive all child node in sqlserver 2005

Fri, 25 Sep 2009 03:54:16 Z

Hi,

Have a xml file data as below

<TEST<ARGS><ARG>500</ARG><ARG>BSB</ARG><ARG>SO:99</ARG><ARG>20</ARG></ARGS></TEST>

Want to retrieve ARG values and store into a database table. Is anyone help me how to write a store procedure for this.

Thanks in advance

Problems with META TAG PROPERTY MAPPINGS

Mon, 25 Feb 2008 14:24:37 Z

Hello,

I'm search after a solution how to display the keywords of a searched web site via XML search query. I mean the keywords in the meta tag of my html web site:

When putting 'keyWords' in the SQL select query I got NO results, that means the 'keywords' column is always empty!

So what is the problem?!

Thanks for reply!!

Regards from Germany,

Steven***

Week Startdate and enddate by Week number in MDX

Mon, 07 Sep 2009 09:59:26 Z

Hi,

I have a cube with the Server Time Dimension. Our client wants a report that will give the measure values week by week. When I started the development of the report, In the Dropdown I have to give the Week Numbers to select, So that By those weeks we will pull the data.

In the label part of the report parameter (the Dropdown Values), I have given the Week numbers Ex: Week 15.
But they cannot understand the what is the month or what is the daterange that weeknumber is belongs to.. So I tried to display the Report parameter label as Week Number - Startdate of the Week - End Date of the week
Ex: Week 15- 04/05/2009 -04/11/2009

I have tried so many ways but i didnt get the script can anyone please give me solution for this.

Contains/Freetext multiple column specification

Mon, 21 Apr 2008 22:13:51 Z

I have searched (ironically given this is search server) high and low for reasonable documentation on search server and have come up snake eyes. In particular the proper definition for CONTAINS and FREETEXT with regards to multiple properties/columns.

SQL specifies that multiple columns as something like this:

CONTAINS( (column1,column2,column3,etc), 'searchterm' )

Using that form in the search server query results in an error.

Anyone know where I can find the correct documentation for this?

Thanks.

Search server 2008 and Fedora-commons repository

Wed, 16 Sep 2009 10:07:28 Z

Hello all,

I am investigating different methods for creating a search and browse interface for a fedora-commons digital repository (version 3.x).
The basic requirements are that the search interface should be customisable, should support faceted search and of-course work with fedora.

Has anyone tried using this for anything other than Office share point?

Many thanks in advance.

Nigel

Active Directory Services : Check if the password complexity is enabled or disabled in the Local(stand alone) machine in c#

Mon, 02 Feb 2009 16:34:11 Z

Hi,

I am working on a scenario where I would need to check if the password policy is enabled/disabled and based on the value retrieved on the server side I need to perform my validation on the client side. Using directory services I am able to get the values for PasswordAge, Password length and password history but am not able to retrieve password complexity.If someone has done this already kindly let me know how to do it.

Regards,
Senthil

Senthil Kumar M

Using WebService, Feed Click-Through back to search server ( QueryService.RecordClick(string) )

Thu, 15 Jan 2009 01:18:00 Z

Hi folks,

I've been searching for 1/2 the afternoon on some documentation on the method

public void RecordClick(string clickInfoXml)

What I need to do is feed the clickthroughs back to the search server. I'm using the webservice to pull results to my public web server that my search server is crawling. My issue is that I want to log the clickthroughs on the searches performed. I figured that would help us refine our search. Well, honestly, I hoped that would allow MSSE to refine it's own results.

I can't find documentation anywhere, save a wrox book that tells me "there is a bug with the method that prevents you from using the method as intended.".

Does anyone have a lead on this? I'm stumped.

Mark

Search Server MSG-Header (From,To...) iFilter

Wed, 02 Sep 2009 13:53:46 Z

How could I get access to these values. I´ve written an SQL Statement like this ("SELECT Title, Path, Author, Filename FROM Scope() WHERE FREETEXT ('", queryText, "') AND FileName LIKE '%", fileExtension, "' ORDER BY Rank DESC" ... and it works! Now I want to read out the Msg-Headerdata ... I think i know, how to configure the Search Server, but i dont´t know why the SearchServer doesn´t indexing the Fields like From or To (i already installed the iFilter from Microsoft).

Could you help me?

Search Query Report shows 'No Scope'

Mon, 20 Apr 2009 07:14:56 Z

Hi,

I am making use of the Search Server 2008 express.
When I try to access the 'Queries Report' under "Usage Reports" from the Search Administration, it shows a pie diagram with the search scopes being used.

I am also getting one section in the pie diagram that says "No Scope".
Can someone please tell me what does this "No Scope" in the pie diagram mean?
How can we get rid of this, if we don't want the pie diagram to show something like this?

customize the page of MSSE

Fri, 20 Jun 2008 08:49:34 Z

I want to customize the page of MSSE inculding the search page and result page. Could you please tell me how to do in detail? Thanks! Actually, I design search page by sharepoint designer without Search Box web part, using form submit as the search box. For result page, I design it by designer with Core result and other web parts, also inclduing the search box in top and bottom of page just like Google's page. It can work but the keywords typed in search box of first page can't be transferred to the search box on result page. What is the professional way to customize the page? create customized search box web part by VS.NET? Can you show me the detail solutions? Thanks again.

Printto

Fri, 21 Aug 2009 06:04:52 Z

How to print in c# with confirmation that printout is actually coming and also control the printer...

Noob Questions on Search

Sat, 15 Aug 2009 11:27:58 Z

Before I ask my questions, you have to forgive me as I don't know much about this technology.

Here is my requirement. My organization has an archive of old mails (we keep 7 years of emails in an archival system because of compliance reasons). my organization wants to make this email archive search-able. This archive of email is terribly large (several terabytes).

We need a search technology which gives us the follow functionality.

1. When a user searches for emails, he/she sees his own emails (not somebody else). How can we implement security so that user is able to search only emails which he/she is allowed to see?

Although we want to use Microsoft technology we don't know what should we really use

2. Is the search server 2008 alive-an-active project? (or has it been killed in favor of MOSS or FAST Search)

3. Does the search server 2008 have any support and roadmap?

Can you give me any guidance on how can I meet the requirements of my organization?

Trouble Connecting Federated Connector

Sat, 15 Aug 2009 04:05:23 Z

I am having difficulty connecting a simple federated connector that I wrote to query a database based on the sample adventureworks sample. I am trying to add the federated location to Search Server 2008 express, but when I query I don't get any results.

I put the connector in a folder at '<local drive>\program files\common files\microsoft shared\web server extensions\12\template\layouts'. When I go to 'http://localhost/_layouts/<folder name>/<federated connector name>.aspx?q=test' I get a XML RSS feed back with seemingly good data (See below).

The connector is the same as the adventureworks example except I modified eventID for vendor, and changed the query. Here is the XML/RSS feed method

    private string GetResultsXML(string queryTerm)
    {
        using (SqlConnection connect = new SqlConnection(connectionString))
        {
            connect.Open();
            // Define query for EventID from EventDetail Table
            string strCommand = string.Format("select eventID,Description,Sponsor from EventDetail WHERE EventID like '%{0}%'", queryTerm);
            SqlCommand command = new SqlCommand(strCommand, connect);
            SqlDataReader sqlReader = command.ExecuteReader();
            StringBuilder resultsXML = new StringBuilder();
            resultsXML.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
            resultsXML.Append("<rss version=\"2.0\">");
            resultsXML.AppendFormat("<channel><title><![CDATA[CEVARS Query For: {0}]]></title><link/><description/><ttl>60</ttl>", queryTerm);
            while (sqlReader.Read())
            {
                resultsXML.AppendFormat("<item><title><![CDATA[{0}]]></title><link><![CDATA[{3}?eventID={0}&f=htm]]></link><description><![CDATA[{1} sponsored by:{2}]]></description></item>", sqlReader[0], sqlReader[1], sqlReader[2], Request.Path, query);

            }

            resultsXML.Append("</channel></rss>");
            return resultsXML.ToString();
        }
    }

The query results looks like this when running the file directly from the virtual directory:

<?xml version="1.0" encoding="utf-8" ?>
<rss version="2.0">
   <channel>
      <title>
         <![CDATA[ query results for: test]]>
      </title>
      <link />
      <description />
      <ttl>60</ttl>
      <item>
         <title>
            <![CDATA[ test ]]>
         </title>
         <link>
            <![CDATA[ /_layouts/<folder name>/<federated connector name>.aspx?eventID=test   ]]>
         </link>
         <description>
            <![CDATA[ this is a test event ]]>
         </description>
      </item>

(aditional items not shown, but same format as above)

   </channel>
</rss>

In the SQL connection scheme I am have the DB owner user name and password:
"Data Source=<database URL>;Initial Catalog=<database name>;Persist Security Info=True;User ID=<database owner username>;Password=<database owner password>;"

I setup the federated location as follows:
Trigger - Always (I also tried using the following pattern and changing the location to q={query} for "test(?<query>.*)"
Location - http://localhost/_layouts/<folder name>/<federated connector name>.aspx?q={searchTerm}
More Results - http://localhost/_layouts/<folder name>/<federated connector name>.aspx?q={searchTerm}&f=htm
Formatting - default
Restricted Usage - No restrictions
Credentials - NTLM (using server's local administrator username and password)

Any help would be greatly appreciated. Thanks in advance.

Printing a form produced by VB 2008?

Thu, 13 Aug 2009 12:47:49 Z

Hi,
As a ex VB5 user I need to rewrite my existing programe to produce a filled out Character Sheet for use in my Role play game.

2008 is great for getting the variables but I am stuck as there seems to be no way to construct the form which was printed as a TXT file to be used by any printer.

Printer.Print does not work, any ideas of what I should read to understand printing in 2008 VB express?

Thanks,

--Bob

Accessing SearchServer WebServices with PHP

Sun, 09 Aug 2009 15:04:04 Z

Hi, I'm trying to access search.asmx QueryEx webservice of SearchServer via PHP with nusoap and curl installed.
I have done some coding but the response is always the same (equal to access search.asmx?wsdl via webbrowser)
My PHP code is like this:

$auth = "domain\user:password";
$wsdl = 'http://localhost/_vti_bin/search.asmx?WSDL';

$client = new nusoap_client($wsdl);
$client->setCredentials("","","ntlm");
$client->setCurlOption(CURLOPT_USERPWD, $auth);
$param = array('queryXml' => '');
$result = $client->call('QueryEx', $param);
print_r($result);

My queryXml var has this value:

<?xml version="1.0" encoding="utf-8" ?>
<QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000">
<Query>
<SupportedFormats>
<Format>urn:Microsoft.Search.Response.Document.Document</Format>
</SupportedFormats>
<Context>
<QueryText language="en-US" type="MSSQLFT">
<![CDATA[SELECT "DAV:href" , "DAV:displayname", "DAV:getlastmodified"
 FROM Non_Portal_Content..Scope() 
 WHERE FREETEXT(\'TEXT TO SEARCH\') 
 ORDER BY "urn:schemas.microsoft.com:fulltextqueryinfo:rank" DESC]]>
</QueryText>
</Context>
<Range><StartAt>1</StartAt><Count>500</Count></Range>
</Query></QueryPacket>

Can someone help me with this?
Thanks in advance.

ASP Web Service

Thu, 06 Aug 2009 16:06:01 Z

I've just been handed this task to connect our intranet site to have search capabilities using the MS Search Server. We used Google-mini in the past but they just decided to go with Search server instead of buying a new google-mini for lack of support. Google mini used the xmldom object in which we easily called a the search server with all parameters and then loaded the xsl file to the dom object to get the results. How can I acquire the search results from the MS search server and load them onto my sites page? Thanks in advance.

Bing

Sat, 25 Jul 2009 10:53:35 Z

This for all the pep's that relly don't like Bing web service. It just sometimes just don't give wat you are looking for or looking up Ijust don't like Bing's service at all it S....... It was better before Bing came along it was faster then now it give me some thing's that I'm not looking for and it send's me to some other place that I'm not even looking for well if this is Bing WELL BING BETTER GET WITH THE PROGRAME OR GET OUT OF THE PROGRAME. FROM:HAWAII,AND ALOHA.

I can not open the backup device

Wed, 22 Jul 2009 09:17:23 Z

I tried to take sql server 2008 database backup from the server which has the following feature

server: windows server 2008 os

to the client which has the following feature:

client:windows xp service pack 3 os

through lan network but i couldnt achieve it and i am getting the following error

****Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'AstrovedFullDatabase(\prabha\Rajniprabha\AstroBak.bak)'. Operating system error 5(failed to retrieve text for this error. Reason: 15105). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.****

can anyone help me?

How to add child controls in grid in windows mobile application

Mon, 20 Jul 2009 12:35:47 Z

hi,
i am new windows mobile application,

How to child add controls in grid in windows mobile application

I can't backup my MDF file

Mon, 20 Jul 2009 10:35:34 Z

HHi! I'm a newbie here and hope you guys can help me. Lately I've been having trouble with sql. I have an up and running application but the problem is I can't backup my MDF file that I use as database. Here's my code to interact to the database file:

By the way I am using Visual Studio 2008 and MS SQL 2005 Express

Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClient

Public Class DataBaseStuff
Implements IDisposable

'Class level variables that are available to classes that instantiate me
Public SQL As String

Public Connection As SqlConnection
Public Command As SqlCommand
Public DataAdapter As SqlDataAdapter
Public DataReader As SqlDataReader

Private disposed As Boolean = False

Public Sub New()
Connection = New SqlConnection("Server=.\SQLExpress;" & _
"AttachDbFilename=C:\Lending System\ Data\LendingSystem.mdf;" & _
"Trusted_Connection=Yes;" & _
"User Instance=True;" & _
"Initial Catalog = LendingSystem.mdf")
End Sub

' IDisposable
Private Overloads Sub Dispose(ByVal disposing As Boolean)
If Not Me.disposed Then
If disposing Then
' TODO: put code to dispose managed resources
If Not DataReader Is Nothing Then
DataReader.Close()
DataReader = Nothing
End If
If Not DataAdapter Is Nothing Then
DataAdapter.Dispose()
DataAdapter = Nothing
End If
If Not Command Is Nothing Then
Command.Dispose()
Command = Nothing
End If
If Not Connection Is Nothing Then
Connection.Close()
Connection.Dispose()
Connection = Nothing
End If
End If

' TODO: put code to free unmanaged resources here
End If
Me.disposed = True
End Sub

#Region " IDisposable Support "
' This code added by Visual Basic to correctly implement the disposable pattern.
Public Overloads Sub Dispose() Implements IDisposable.Dispose
' Do not change this code. Put cleanup code in Dispose(ByVal disposing As Boolean) above.
Dispose(True)
GC.SuppressFinalize(Me)
End Sub

Protected Overrides Sub Finalize()
' Do not change this code. Put cleanup code in Dispose(ByVal disposing As Boolean) above.
Dispose(False)
MyBase.Finalize()
End Sub
#End Region

Public Sub OpenConnection()
Try
Connection.Open()
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub

Public Sub CloseConnection()
Connection.Close()
End Sub

Public Sub InitializeCommand()
If Command Is Nothing Then
Try
Command = New SqlCommand(SQL, Connection)
'See if this is a stored procedure
If Not SQL.ToUpper.StartsWith("SELECT ") _
And Not SQL.ToUpper.StartsWith("INSERT ") _
And Not SQL.ToUpper.StartsWith("UPDATE ") _
And Not SQL.ToUpper.StartsWith("DELETE ") Then
Command.CommandType = CommandType.StoredProcedure
End If
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End If
End Sub

Public Sub AddParameter(ByVal Name As String, ByVal Type As SqlDbType, ByVal Value As Object)

Try
Command.Parameters.Add(Name, Type).Value = Value
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
End Sub

End Class

here's are my stored procs:

ALTER PROCEDURE BackupDataBase

AS
BACKUP DATABASE LendingSystem
TO DISK = 'C:\Lending System\Backup\LendingSystem.bak'
WITH NAME = 'LendingSystem-Full Database Backup',
SKIP,
NOUNLOAD,
STATS = 10

ALTER PROCEDURE DetachDatabase

AS
Exec
sp_detach_db 'LendingSystem'

ALTER PROCEDURE RestoreDatabase

AS
RESTORE DATABASE [LendingSystem]
FROM DISK = 'C:\Lending System\Backup\LendingSystem.bak'
WITH FILE = 4,
NORECOVERY, NOUNLOAD, REPLACE, STATS = 10

as you can see my database file resides in C:\Lending System\Data and I "simply" (but not simple) copy the file into another directory, i.e: C:\Lending System\Backup for backup purposes. The thing is I can do the backup the stored procedure above but I can't restore it it says it is currently in use. I can't detach it neither.

Thinking that I could do some tricks I tried using a second MDF file as my link to do the backup...somehow I want to detach and copy the MDF file...

Say I' ll be having this:

Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClient

Public Class DataBaseStuff
Implements IDisposable

'Class level variables that are available to classes that instantiate me
Public SQL As String

Public Connection As SqlConnection
Public Command As SqlCommand
Public DataAdapter As SqlDataAdapter
Public DataReader As SqlDataReader

Private disposed As Boolean = False

Public Sub New()
Connection = New SqlConnection("Server=.\SQLExpress;" & _
"AttachDbFilename=C:\Lending System\ Data\DatabaseBridge.mdf;" & _