This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Greetings fellow Maximo users,
I am hoping someone can help this novice out. We have been experiencing a search issue in Maximo. New records are not searchable; while older records (old being defined as anything approx >=45days) are, but any mods to these records will not be. We believe that this can be rectified by rebuilding the indexes, but do not know the exact process by which to do this. Could someone enighten me as to how to complete this? Thanks in advance.
Server: SQL
Server OS: Windows 2003 5.2
Maximo: v6.2.6
Your text based indexes are not being rebuilt - in Oracle it's a procedure that's ran every 5 min - not sure for SQL Server how that's done in 6 but I'll bet it something similar...
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Zeroxpectations
Sent: Friday, July 06, 2012 10:15 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] INDEX REBUILD
Greetings fellow Maximo users,
I am hoping someone can help this novice out. We have been experiencing a search issue in Maximo. New records are not searchable; while older records (old being defined as anything approx >=45days) are, but any mods to these records will not be. We believe that this can be rectified by rebuilding the indexes, but do not know the exact process by which to do this. Could someone enighten me as to how to complete this? Thanks in advance.
Server: SQL
Server OS: Windows 2003 5.2
Maximo: v6.2.6
Try checking to see if "Full Text" searching is enabled in your environment?
select FULLTEXTSERVICEPROPERTY ( 'IsFulltextInstalled' )
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Will Hampton
Sent: Friday, July 06, 2012 10:26 AM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] INDEX REBUILD
Your text based indexes are not being rebuilt - in Oracle it's a procedure that's ran every 5 min - not sure for SQL Server how that's done in 6 but I'll bet it something similar...
R/
Will
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Zeroxpectations
Sent: Friday, July 06, 2012 10:15 AM
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] INDEX REBUILD
Greetings fellow Maximo users,
I am hoping someone can help this novice out. We have been experiencing a search issue in Maximo. New records are not searchable; while older records (old being defined as anything approx >=45days) are, but any mods to these records will not be. We believe that this can be rectified by rebuilding the indexes, but do not know the exact process by which to do this. Could someone enighten me as to how to complete this? Thanks in advance.
Server: SQL
Server OS: Windows 2003 5.2
Maximo: v6.2.6
Should have put all of this in one email...
By Default in SQL Server Maximo should have created the Full Text indexes in Automatic or Incremental mode (Automatic is what I see on the Workorder Full Text index properties (Open Microsoft SQL Server management Studio, goto table WorkOrder, right click, point to Full Text, select Properties, verify index is "Enabled" and set to either "Automatic" (default I believe) or Incremental)).
Thanks much for the info. When we first experienced the search issue we were instructed by IBM to disable the MS Search function so as to avoid a conflict with Maximo's DB searching capabilities........perhaps some other changes were made that I was unaware of thus causing our current issue. Thanks again for your help.
________________________________
From: Will Hampton <will.hampton@exxtremeconsulting.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, July 6, 2012 11:49 AM
Subject: RE: [MAXIMO List] INDEX REBUILD
Should have put all of this in one email...
By Default in SQL Server Maximo should have created the Full Text indexes in Automatic or Incremental mode (Automatic is what I see on the Workorder Full Text index properties (Open Microsoft SQL Server management Studio, goto table WorkOrder, right click, point to Full Text, select Properties, verify index is "Enabled" and set to either "Automatic" (default I believe) or Incremental)).