How to perform a reindex for RELM database in LQE?

Just in case this crops up again... you need to edit the data source that you want to reindex in LQE, so typically that will be https://servername:9443/lqe/web and select Data Sources from the left pane.

Click on the pencil icon beside the data source to rebuild, and that will open its properties.
There are 3 options available: Reindex / Remove / Pause Indexing.
In this case, the first option would attempt to reindex the data source.

I hope that helps,

John

Hi Krzysztof,

Thanks for your response. Here are some additional details:

a. OS for the severs:
Linux 2.6.18-238.el5

b. Focal Point:
6.5.2.3 Build ID FP6523-I20130618_0917

c. Database system and version:
Oracle Database 11g Release 11.1.0.0.0

d. App server (e.g. Websphere or Tomcat):
Apache Tomcat/6.0.35

The client sees the following exception in the Show Details screen on RELM GUI.

CRLQE0489E Rollback detected. Data source may have been rolled back.
Encountered an entry older than the last processed. Last Processed:
{Kind=CREATION; Identifier=urn:com.qctfp-tst.qualcomm.com:-1:2013-11-
22T00:14:27.576Z:1010127; Order=1385079267576; Changed=
https://qctfp-

tst.qualcomm.
com/fp/resources/workspaces/121/modules/327/elements/1010127}.
Encountered: {Kind=MODIFICATION; Identifier=urn:com.qctfp-tst.qualcomm.
com:-1:2013-11-22T00:10:37.761Z:1009834; Order=1385079037761;
Changed=
https://qctfp-tst.qualcomm.

com/fp/resources/workspaces/121/members/1009834}
com.ibm.team.jis.lqe.espresso.trsparser.RollbackDetectedException:
CRLQE0489E Rollback detected. Data source may have been rolled back.
Encountered an entry older than the last processed. Last Processed:
{Kind=CREATION; Identifier=urn:com.qctfp-tst.qualcomm.com:-1:2013-11-
22T00:14:27.576Z:1010127; Order=1385079267576; Changed=
https://qctfp-

tst.qualcomm.
com/fp/resources/workspaces/121/modules/327/elements/1010127}.
Encountered: {Kind=MODIFICATION; Identifier=urn:com.qctfp-tst.qualcomm.
com:-1:2013-11-22T00:10:37.761Z:1009834; Order=1385079037761;
Changed=
https://qctfp-tst.qualcomm.

com/fp/resources/workspaces/121/members/1009834}
 at com.ibm.team.jis.lqe.espresso.trsparser.TRS$ChangeLogHandle.
getChangeEntries(TRS.java:277)
 at com.ibm.team.jis.lqe.espresso.tasks.ChangeLogTask.call
(ChangeLogTask.java:152)
 at com.ibm.team.jis.lqe.espresso.tasks.ChangeLogTask.call
(ChangeLogTask.java:69)
 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
 at java.util.concurrent.FutureTask.run(FutureTask.java:138)
 at java.util.concurrent.
ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301
(ScheduledThreadPoolExecutor.java:98)
 at java.util.concurrent.
ScheduledThreadPoolExecutor$ScheduledFutureTask.run
(ScheduledThreadPoolExecutor.java:206)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:886)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:736)

I cannot attach the image here but will send you an email.


The client was advised of the following steps:

Steps to copy data from the production environment to the non-production environment.
1) pause the RELM data source indexing.
2) Stop the Focal point services.
3) Complete the DB refresh on Focal point.
4) Bring up the Focal Point services.
5) Resume the RELM data source indexing. - if a rollback error is
encountered, a REINDEX will be required.

With regards to the above context, how can the cient perform a REINDEX in RELM as pointed out in step 5.

Many thanks,
Pritesh...