Red Gate forums :: View topic - Searching problems
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Aardvark
Aardvark forum

Searching problems

Search in Aardvark forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
rbailey



Joined: 19 Oct 2005
Posts: 12

PostPosted: Thu Aug 17, 2006 2:55 pm    Post subject: Searching problems Reply with quote

Hi,

I am having a problem using the search for issues by date.

No matter what combination of date format or separators I try, it either returns no results at all or what appears to be every result.

The "or in the last n days" option always states no matching results found.
This is something that has never worked for us, and is becoming more and more of a problem as the number of bugs stored increases.

Does anyone know how to solve this issue please?

Thanks,

Richard.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Tue Aug 22, 2006 8:57 pm    Post subject: Reply with quote

Hi Richard,

I suspect that the SQL Server's full-text catalogs may be to blame there, since the searches use FTX queries. You can try rebuilding the catalog by locating it in the Aardvark database (in Enterprise Manager). Right-click each of the three full-text catalogs and select 'Rebuild', then 'Start full population'. Once that's done, check the SQL Server Agent under Management, and make sure there is an Aardvark job for full-text incremental population. Make sure that job has no errors in its' history, that it will run successfully by right-clicking it and selecting 'run now', and that it has a valid schedule.

If the jobs don't exist at all, open the Aardvark program folder, open the SQL subfolder, and run jobs.sql to create the Aardvark jobs on the server.
Back to top
View user's profile Send private message
rbailey



Joined: 19 Oct 2005
Posts: 12

PostPosted: Wed Aug 23, 2006 10:25 am    Post subject: No luck Reply with quote

Hi Brian,

I rebuilt the catalogs and repopulated them, but the problem still remains.
The job is all present and correct also. There doesn't appear to be any errors in the history either.

Any more suggestions?

Thanks,

Richard.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Wed Aug 23, 2006 12:37 pm    Post subject: Reply with quote

What version? It may have been a bug that got fixed.

The whole search mechanism depends on fulltext so I have no clue what else it could be.
Back to top
View user's profile Send private message
rbailey



Joined: 19 Oct 2005
Posts: 12

PostPosted: Wed Aug 23, 2006 12:56 pm    Post subject: Version information Reply with quote

Aardvark is version 2.00, with the database version 2.00.

Aardvark is installed on Windows Server 2003 SP1.
The SQL server is running on a separate server.
SQL Sever Standard Edition 2000 SP3.

Is it possible the database could have become damaged?
Do you think something like creating a backup to an XML file, creating a new database and importing the data back in could help?
Back to top
View user's profile Send private message
rbailey



Joined: 19 Oct 2005
Posts: 12

PostPosted: Wed Aug 23, 2006 6:19 pm    Post subject: bugsschema2.xml? Reply with quote

I just noticed that I can't open any of our backed up XML data because the schema file is not available.

http://apps.red-gate.com/schema/bugsschema2.xml

Can I get a copy of this file from somewhere?

Thanks,

Richard.
Back to top
View user's profile Send private message
rbailey



Joined: 19 Oct 2005
Posts: 12

PostPosted: Fri Aug 25, 2006 10:49 am    Post subject: XML Schema Reply with quote

Hi Brian,

Is there any news on the availability of the above schema file?

Thanks,

Richard.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Fri Aug 25, 2006 12:42 pm    Post subject: Reply with quote

Hi Richard,

Sorry, but we don't have a copy of it any more since Aardvark's been discontinued. The apps server has been decommissioned long ago and I suspect this file has died with it. It's not with the original source code, either.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group