October 23, 2012 at 1:31 pm
Hi All,
I have a request to look into....see below for details.
"The Search functionality in (database name/application) QA is not working correctly. Index tables are not refreshed when new activities are added into the system via the GUI, and cannot be found using search. In the past, this has been caused by having 2 instances of the database in play."
What can you make up from this request?
I looked at Fulltext search and is up and running. Dev, Staging and Prod is fine.....only issue is in QA. Not sure how to proceed or what to ask. Please advise.
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.
October 23, 2012 at 2:14 pm
You should start by going back to whoever wrote this and have them provide whatever additional details they may have regarding the alleged "2 instances of the database". To me it kinda sounds like they've actually had 2 seperate copies of the database and no functioning form of replication or log shipping between them so that updates made in one place were not reflected in the other.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 23, 2012 at 2:18 pm
SQLCrazyCertified (10/23/2012)
"The Search functionality in (database name/application) QA is not working correctly. Index tables are not refreshed when new activities are added into the system via the GUI, and cannot be found using search...SueTons.
Shooting in the dark here (and ignoring the 2 server comment in the ticket), but FullText index not refreshing sounds like the index has not gone through a Population process after the new data has been inserted. This could be either because it has not been setup or scheduled to run. Details here
... but I could be well off.
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
October 23, 2012 at 3:35 pm
Actually, if we're talking about full-text search catalogs and that's what is not refreshing, than yes, I'd say that's probably it and I'm probably the one who was off. 😛
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 23, 2012 at 4:27 pm
Vegard Hagen (10/23/2012)
Actually, if we're talking about full-text search catalogs and that's what is not refreshing, than yes, I'd say that's probably it and I'm probably the one who was off. 😛
After further research, it could be due to catalog updates/crawl time.
SueTons.
Regards,
SQLisAwe5oMe.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply