It's all about the answers!

Ask a question

Why no consistency in search results on a clustered env?


iRAM Administrator (3152156135) | asked Jul 06 '10, 12:42 p.m.
Why there is no consistency in search results on a clustered (2 nodes, with 4 ports on each) environment? Whenever we perform the search on different instances, the results are different.

10 answers



permanent link
Rogério Ramos da Silva (3352827) | answered Mar 04 '11, 4:44 p.m.
What version of RAM are you using? The most likely cause of this problem is that one of your clusters nodes encountered an error during indexing. An example error would be if the database was momentarily not accessible by one of the nodes. In this case, some assets could be skipped and not added to the index. There have been fixes within the last year that have resolved this issue.

https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/24782
https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/42766

The first fix (24782) was added to RAM 7.2.0.2 helps to ensure that the index matches on all nodes. If an asset encounters an error during indexing, it is added to a queue and indexed at a later time. The second fix (42766) will be available in RAM 7.5.0.2 and allow you to see any assets that encountered an error during indexing. With this fix even assets that encountered errors are still added to the index.


The RAM version is 7.5.0.1. As the env. has a appliance to make a load balance amongst two webservers, sometimes is no possible fire a rebuild index action in a problematic node, it's necessary access it IP by IP and rebuild the indexes.

How can the admin to identify and handle these kind of trouble? It is unsure if this incident will not occurs again.

We are going to the new release (7.5.0.2), and the fix 42766 left us so curious.

permanent link
Sheehan Anderson (1.2k4) | answered Feb 25 '11, 11:33 a.m.
JAZZ DEVELOPER
What version of RAM are you using? The most likely cause of this problem is that one of your clusters nodes encountered an error during indexing. An example error would be if the database was momentarily not accessible by one of the nodes. In this case, some assets could be skipped and not added to the index. There have been fixes within the last year that have resolved this issue.

https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/24782
https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/42766

The first fix (24782) was added to RAM 7.2.0.2 helps to ensure that the index matches on all nodes. If an asset encounters an error during indexing, it is added to a queue and indexed at a later time. The second fix (42766) will be available in RAM 7.5.0.2 and allow you to see any assets that encountered an error during indexing. With this fix even assets that encountered errors are still added to the index.

permanent link
Rogério Ramos da Silva (3352827) | answered Feb 25 '11, 8:19 a.m.
Every server "box" use its own index ... for scalability reasons.

With time (minutes) ... these indexes will be identical.


Hi Dr Gili,

I met a problem on equality these "boxes". For days I had my cluster's nodes with different information, the faceted filters shown different qtys and even filters, the solution was rebuild the index.
How can I check why it occurs? How ensure that sincronization works as expected?

permanent link
Gili Mendel (1.8k56) | answered Jul 07 '10, 6:22 p.m.
JAZZ DEVELOPER
Every server "box" use its own index ... for scalability reasons.

With time (minutes) ... these indexes will be identical.

permanent link
Gili Mendel (1.8k56) | answered Jul 07 '10, 6:21 p.m.
JAZZ DEVELOPER
See: http://publib.boulder.ibm.com/infocenter/ramhelp/v7r2m0/topic/com.ibm.ram.web.doc/topics/t_create_url_assetactivities.html?resultof=%22%75%72%6c%22%20%22%72%65%70%6f%72%74%22%20

And do a report on Delete Activity for a specific asset or any asset.

permanent link
Rich Kulp (3.6k38) | answered Jul 07 '10, 10:28 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
On 7/7/2010 5:53 AM, iraadminJazz wrote:
richkulpwrote:
On 7/6/2010 12:53 PM, iraadminJazz wrote:
How to find out the details of a deleted asset if we know only its
external id and dont know the community to which it belongs to?


Hi,

If it is deleted there are no details. It is gone. So there is no
information on it. Delete means delete, go away.

Rich


But at least we can find out that who had deleted that asset and at
what date and time? For e.g. if we know the community name, we can
generate an audit of the deleted assets.


The only thing maintained is a delete metric activity. But there is
nothing other than the date/time of deletion that can be queried to
return the metric. The external id is stored encoded into the metric but
there is no way to explicitly retrieve that metric for a particular
external id. You would have to query all delete metrics for a time range
to determine the external id. That can be expensive since you would need
to rehydrate all delete metrics within a time range, unless the time
range is narrow.

Within the delete metric itself is the information you are looking for:

1) User doing deletion
2) Asset name
3) Asset guid
4) Asset version


Rich

permanent link
iRAM Administrator (3152156135) | answered Jul 07 '10, 5:46 a.m.
On 7/6/2010 12:53 PM, iraadminJazz wrote:
How to find out the details of a deleted asset if we know only its
external id and dont know the community to which it belongs to?


Hi,

If it is deleted there are no details. It is gone. So there is no
information on it. Delete means delete, go away.

Rich

But at least we can find out that who had deleted that asset and at what date and time? For e.g. if we know the community name, we can generate an audit of the deleted assets.

permanent link
Rich Kulp (3.6k38) | answered Jul 06 '10, 1:23 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
On 7/6/2010 12:53 PM, iraadminJazz wrote:
How to find out the details of a deleted asset if we know only its
external id and dont know the community to which it belongs to?


Hi,

If it is deleted there are no details. It is gone. So there is no
information on it. Delete means delete, go away.

Rich

permanent link
iRAM Administrator (3152156135) | answered Jul 06 '10, 12:49 p.m.
How to find out the details of a deleted asset if we know only its external id and dont know the community to which it belongs to?

permanent link
iRAM Administrator (3152156135) | answered Jul 06 '10, 12:45 p.m.
Does individual user's "My Dashboard" results also comes from Indexer?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.