Client Support
Showing results for 
Search instead for 
Do you mean 

Thesaurus Terms Shortcut Options - HP TRIM 7.02 Build 1621

Thesaurus Terms Shortcut Options - HP TRIM 7.02 Build 1621

While testing HP TRIM 7.02.1621 TRIM seems to freeze for up to 5 minutes when selecting the 'Thesaurus Terms' Shortcut menu option. The same issue happens when selecting using the following method: Search Menu - Favorites - Thesaurus Terms...this method also freezes.

 

I have added 3 Thesaurus Terms to my Favorites; I let it hang & finally they appear after a delay of over 5mins. I tested this 3 times with delays always over 3mins. I removed the Thesaurus Terms from my favorites, which also hung TRIM for 5mins when removing the terms. I tested again without any terms & the delay was still over 3mins. I believe its a build issue but again not a major issue.

4 REPLIES
HPE Expert

Re: Thesaurus Terms Shortcut Options - HP TRIM 7.02 Build 1621

Agreed, it seems to be pretty slow. I just captured the SQL issued when I opened my Favorite Thesaurus Terms (of which there are 3). I'll see if it's listed as a known issue...


00:27:55       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 2)
00:27:55       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 3)
00:27:55      15 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 4)
00:27:56       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 5)
00:27:56       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 6)
00:27:56       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 7)
00:27:56       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 8)
00:27:57       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 9)
00:27:57       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 10)
00:27:57       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 11)
00:27:57       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 12)
00:27:57       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 13)
00:27:58       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 14)
00:27:58       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 15)
00:27:58       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 16)
00:27:58       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 17)
00:27:58      15 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 18)
00:27:59       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 19)
00:27:59       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 20)
00:27:59       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 21)
00:27:59       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 22)
00:28:00       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 23)
00:28:00       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 24)
00:28:00       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 25)
00:28:00       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 26)
00:28:00      16 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 27)
00:28:01       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 28)
00:28:01       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 29)
00:28:01       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 30)
00:28:01       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 31)
00:28:01       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 32)
00:28:02       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 33)
00:28:02       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 34)
00:28:02       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 35)
00:28:02       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 36)
00:28:03      16 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 37)
00:28:03       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 38)
00:28:03       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 39)
00:28:03       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 40)
00:28:03       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 41)
00:28:04       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 42)
00:28:04       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 43)
00:28:04       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 44)
00:28:04       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 45)
00:28:04       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 46)
00:28:05       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 47)
00:28:05       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 48)
00:28:05       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 49)
00:28:05       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 50)
00:28:05      16 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 51)
00:28:06       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 52)
00:28:06       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 53)
00:28:06       0 45 Administrator    GetRecordset(main)[3 2 2 ] SELECT COUNT(*)  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30 AND  lbiItemUri = 54)


Neil

Note: Any posts I make on this forum are my own personal opinion and (unless explicitly stated) do not constitute a formal commitment on behalf of HPE.

(Please state the version of CM you're using in all posts. At any given time, HPE are supporting approx. 30+ released versions)

HPE Software Support Online (SSO): https://softwaresupport.hpe.com/
HPE Expert

Re: Thesaurus Terms Shortcut Options - HP TRIM 7.02 Build 1621

Hmm...doesn't seem to be a known issue yet. I'll send it to product engineering to have a look at. Thanks for pointing this out!

 

Neil


Neil

Note: Any posts I make on this forum are my own personal opinion and (unless explicitly stated) do not constitute a formal commitment on behalf of HPE.

(Please state the version of CM you're using in all posts. At any given time, HPE are supporting approx. 30+ released versions)

HPE Software Support Online (SSO): https://softwaresupport.hpe.com/
HPE Expert

Re: Thesaurus Terms Shortcut Options - HP TRIM 7.02 Build 1621

OK it's being addressed under change request QCCR2D40267 - but don't be surprised if we don't see the fix until the next TRIM 7 service pack.

 

As a workaround (which worked like a charm for me) try going into system options under the "Object Cache" tab called "Optimise performace for large numbers (e.g. over 1000) of the these object types:" and select "Thesaurus". This changed the SQL to what's displayed below and was HEAPS faster in my test database.

 

SELECT  uri,tmSearchKey  FROM TSTHESAURU WITH (NOLOCK)   WHERE (uri IN(SELECT lbiItemUri  FROM TSLABELITE WITH (NOLOCK)   WHERE (lbiLabelUri=2 AND  lbiItemType = 30))) ORDER BY  tmSearchKey  ASC

 

Neil


Neil

Note: Any posts I make on this forum are my own personal opinion and (unless explicitly stated) do not constitute a formal commitment on behalf of HPE.

(Please state the version of CM you're using in all posts. At any given time, HPE are supporting approx. 30+ released versions)

HPE Software Support Online (SSO): https://softwaresupport.hpe.com/
Honored Contributor

Re: Thesaurus Terms Shortcut Options - HP TRIM 7.02 Build 1621

That's awesome Neil, thanks :smileyhappy:

 

//Add this to "OnDomLoad" event