Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..
284 views

Regen is too slow in version 9.30, 9.31 . . .

Hello experts, This is a long pending issue in our environment where we are trying to run Regen on probsummary, incidents & rootcause table. As of now,it is in Asynchronous mode & we have stopped IRQEUE process. Even raised the shared memory to higher range. To isolate this activity, we created a separate environment which is meant for running Regen only & then copy all scirexpert records to Prod environment. But it is taking more than a week to get completed foir a single table for both RTE versions 9.30 & 9.31. Database size is 302GB. I have attached sm.ini file. This is something urgent & hope experts will be having suggetion to fix this issue.
0 Likes
4 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Regen is too slow in version 9.30, 9.31 . . .

It's possible to execute an I.r refer on a non-production environment then replace the production IR index. After taking the database copy you need to suspend I.r indexing on Prod, then complete the new indexes m, migrate them to prod, and the re-enable indexing to index the records from the interim period.  I think there are instructions in the SM Help Sever.

 

note that you may also want to remove the journal led history fields from the IR Key (e.g. Update.action in probsummary). A as it can significantly improve performance.

 

if you have Knowledge Management, you have the option to index tickets using the KM index, which removes the need to use IR indexing (and provides a much more sophisticated search capability).

----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...
0 Likes
Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..

Re: Regen is too slow in version 9.30, 9.31 . . .

We are following the same instructions. Problem here is Regen is never ending & we are not sure whether it will able to give correct indexes as it failed in previous try. We have 4 fields defined as a part of IR Key which includes Title, Descripotion, Journal Updates & Solution for probsummary table. We are not using knowledge management as fo now.
0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Regen is too slow in version 9.30, 9.31 . . .

Have a look at this. It may help.  Title:   IR regen after upgrading the system from SM7.10 to SM7.11  
Document ID:   KM868376. Summary:   How to run Ir Regen on test and move the scirexpert file to production.

0 Likes
Highlighted
Valued Contributor.. Valued Contributor..
Valued Contributor..

Re: Regen is too slow in version 9.30, 9.31 . . .

Somehow we were able to complete for Probsummary & ran vrir utility successfully. But its not same for incident table. Regen got completed on Incident table but vrir is failing on it.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.