How to extend RDNG or DB timeout for long running query?
We have extended an artifact type with 15 artifact attributes and associated attribute data types. A specific query that uses 13 of the attributes (4 attributes are searching for a specific value and 9 are attribute "does not exist" criteria) times out after 2 minutes (120000 ms). Other similar queries process successfully.
We can create the timeout at the RDNG UI (Browse Artifacts, Filter by Attribute) or via the RM API (the real consumer). RDNG throws an error in the UI and rm.log and while doing problem determination, we landed at:
This question is not about how to restructure the query. The question is how to extend the timeout.
We have tried multiple tests by incrementally changing RM Advanced properties (with appropriate server restarts) all set to 5 minutes (300000 ms) but the query still times out at 2 minutes.
Change RM Core Component query.client.timeout to 300000 from 3000 (default)
Change RM Core Component connection.timeout to 300000 from 120000 (default)
Change RM Core Component RDMCacheExpiration to 300000 from 120000 (default)
Change Jazz Foundation Services Default Expiration (millis) to 300000 from 120000 (default)
Change Jazz Foundation Services timeout to 300000 from 120000 (default)
Looking for suggestions on other settings to adjust or root causes.
|
One answer
To my experience, adjusting these 2 properties usually allow a long running query to complete.
Comments
Daniel Senko
commented Feb 07 '17, 8:52 a.m.
Diana, thank you for the quick response! I failed to add the we are running v5.0.2 on Linux.
I do not recognize this property below. Is this available in v5.0.2 and/or under a different property?
2. RM Client Component --Timeout for DNG WebUI communications (ms) (default 120000)
No this property was introduced in 6.0 per https://www-01.ibm.com/support/docview.wss?uid=swg21962999
|
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.