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.
If this were Oracle I'd say that the scheduled job to refresh the text
indexes isn't running, I suspect there's an equivalent in SQL Server I'm
just not as familiar with it. You could try this to verify
http://technet.microsoft.com/en-us/library/bb326034(v=sql.105).aspx and if
it solves the issue look in to how the text indexes are supposed to get
refreshed on SQL Server.
Chris.
On Fri, Sep 6, 2013 at 12:43 PM, <therron@pcci.edu> wrote:
> **
>
>
> Maximo 6.2.6, SQL Server
>
> I have this happen every once in a while, and I haven't been able to pin
> down the cause of it. I lived with it, until it has made me really angry
> this morning.
>
> I'm searching Item Master in the Description field. I search for "well
> nut" and it comes up with zero results. So I assume there are none of
> these parts in the database, so I start adding them.
>
> I got interrupted, went on to something else, and came back to it. I
> again search for "well nut" and I again get zero results! I end up
> searching another way (Classification) and I find the ones I entered today.
> . .and a bunch that were entered YEARS ago (that I've now made duplicate
> entries for).
>
> Why did my search fail?
>
>
This looks like it may be more specific for you...
http://www-01.ibm.com/support/docview.wss?uid=swg21624359
Chris.
On Fri, Sep 6, 2013 at 12:43 PM, <therron@pcci.edu> wrote:
> **
>
>
> Maximo 6.2.6, SQL Server
>
> I have this happen every once in a while, and I haven't been able to pin
> down the cause of it. I lived with it, until it has made me really angry
> this morning.
>
> I'm searching Item Master in the Description field. I search for "well
> nut" and it comes up with zero results. So I assume there are none of
> these parts in the database, so I start adding them.
>
> I got interrupted, went on to something else, and came back to it. I
> again search for "well nut" and I again get zero results! I end up
> searching another way (Classification) and I find the ones I entered today.
> . .and a bunch that were entered YEARS ago (that I've now made duplicate
> entries for).
>
> Why did my search fail?
>
>
Could it be that older records work but at some point indexing stopped being updated? If you create a new lock nut then search does that new record show up or just the older (indexed) ones?
On Sep 6, 2013, at 3:01 PM, <therron@pcci.edu> wrote:
> I just tried these searches, and all seem to work fine (at least they return results as I expected):
>
> lock nut
>
> hex nut
>
> wing nut
>
> speed nut
>
> weld nut
>
> coupling nut
>
> panel nut
>
>
>
> So full-text indexing seems to be working fine; but it chokes on the word "well."
>
>
>
> It has happened before on other words (and if I recall correctly, I experienced it in Work Order Tracking), I just can't think of which words those were at the moment. It's been awhile since I encountered it last.
>
>
>
>
>
> Travis Herron
>
>
>
> --- In MAXIMO@yahoogroups.com, <maximo@yahoogroups.com> wrote:
>
> This looks like it may be more specific for you... http://www-01.ibm.com/support/docview.wss?uid=swg21624359
>
> Chris.
>
>
> On Fri, Sep 6, 2013 at 12:43 PM, <therron@...> wrote:
> Â
> Maximo 6.2.6, SQL Server
>
> I have this happen every once in a while, and I haven't been able to pin down the cause of it. I lived with it, until it has made me really angry this morning.
>
> I'm searching Item Master in the Description field. I search for "well nut" and it comes up with zero results. So I assume there are none of these parts in the database, so I start adding them.
>
> I got interrupted, went on to something else, and came back to it. I again search for "well nut" and I again get zero results! I end up searching another way (Classification) and I find the ones I entered today. . .and a bunch that were entered YEARS ago (that I've now made duplicate entries for).
>
> Why did my search fail?
>
>
>
Prior to SQL Server 2008 the full text indexes were part of the file system, in 2008 they are a logical object, if you upgraded a previous 2005 instance they would potentially still exist as a file system component.
As Chris has said the process of updating them could be “intermittent” or “stopped” completely. IF you are seeing new entries show up after a “period of time” then they are still running but the update interval is probably longer then you’d like. IF they have stopped (no new items showing up) then you need to have your DBA restart/rebuild them.
The process that your needing to check should be the “Full-text gatherer”. The full-text gatherer works with the full-text crawl threads. It is responsible for scheduling and driving the population of full-text indexes, and also for monitoring full-text catalogs.
R/
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Chris Lawless
Sent: Friday, September 06, 2013 2:26 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Description search fails at odd times. . .
Could it be that older records work but at some point indexing stopped being updated? If you create a new lock nut then search does that new record show up or just the older (indexed) ones?
On Sep 6, 2013, at 3:01 PM, <therron@pcci.edu<mailto:therron@pcci.edu>> wrote:
I just tried these searches, and all seem to work fine (at least they return results as I expected):
lock nut
hex nut
wing nut
speed nut
weld nut
coupling nut
panel nut
So full-text indexing seems to be working fine; but it chokes on the word "well."
It has happened before on other words (and if I recall correctly, I experienced it in Work Order Tracking), I just can't think of which words those were at the moment. It's been awhile since I encountered it last.
Travis Herron
--- In MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>, <maximo@yahoogroups.com<mailto:maximo@yahoogroups.com>> wrote:
This looks like it may be more specific for you... http://www-01.ibm.com/support/docview.wss?uid=swg21624359
Chris.
On Fri, Sep 6, 2013 at 12:43 PM, <therron@...<mailto:therron@...>> wrote:
Â
Maximo 6.2.6, SQL Server
I have this happen every once in a while, and I haven't been able to pin down the cause of it. I lived with it, until it has made me really angry this morning.
I'm searching Item Master in the Description field. I search for "well nut" and it comes up with zero results. So I assume there are none of these parts in the database, so I start adding them.
I got interrupted, went on to something else, and came back to it. I again search for "well nut" and I again get zero results! I end up searching another way (Classification) and I find the ones I entered today. . .and a bunch that were entered YEARS ago (that I've now made duplicate entries for).
Why did my search fail?
Can someone send me some examples of the setup they used to connect Maximo to WebSphere MQ.
Looking for WebSphere setup as well as the End Point application for a JMS handler.
I appreciate the help.
Thank you,
Lonnie Stone
lonnie_s_stone@yahoo.com
The word "well" is a system stopword in SQL Server 2008, it is probably there in 2005 too. Any stopword does not get indexed and any search for them will fail.
It is easy to modify in 2005 as stopwords are in a text file in the SQL Server instance directory. Simply open the text file, remove the word, and force an index re-population.
SQL Server 2008 is more involved as the system stoplist is built into the database. You have to create your own stoplist. Then for each full-text indexed table, open the properties and change the stoplist to your custom one, then force a re-population. You could write a script to do this too.
For a list of system stopwords (1033 = English):
SELECT *
FROM [MAXIMO3].[sys].[fulltext_system_stopwords]
where language_id = 1033
Hi all
This is blog post i made trying to explain how to add a new tab with a new row function and some java customizationany feed back will be appreciated.
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments.html
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments_9.html
Thanks in advance
-- Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
No code of any type is needed just add the required fields get your key fields then any other fields you require to copy to your source table
I think you will need to re-start your application server you don't need to do orgid or siteid as the framework will fill them in for you
insert into appfielddefaults (app,defaultvalue,objectname,attributename,appfielddefaultsid) values
('COMPANY',':OWNEROBJECT.COMPANY','COMPDEPARTMENT','COMPANY',1)
Your joins don't look correct either you need to join from COMPANY to COMPDEPARTMENT
Not as shown in your screen shot
Rgds Ian
BPD Zenith Ltd
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ramy M. Raslan
Sent: 09 September 2013 15:26
To: maximo yahoogroups
Subject: [MAXIMO List] Maximo Add new row Customization in Company Application
Hi all
This is blog post i made trying to explain how to add a new tab with a new row function and some java customization
any feed back will be appreciated.
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments.html
http://crazyjavadeveloper.blogspot.com/2013/09/companies-application-new-departments_9.html
Thanks in advance
--
Regards,
- Ramy Mohamed Raslan
Cell phone: +20102 4640 011
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************