The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

kRunCacheManager for single request

Highlighted
manaschandra
Super Collector

kRunCacheManager for single request

 

Hi All,
 
Is it possible to run kRunCacheManager from execution step for only current request?
 
Requirement is, executing update statement from execution step which is updating table component data. But after executing the step I am not seeing the updated data immediately on the request. Hence added another execution step which is clearing table component cache. Once table component cache clear execution step I can see the updated data in my request. But the only disadvantage with this step is , it clears the cache of all table components available on all the requests in the system and performance will degrade.
 
Looking for a solution so that it clears only current requests table component cache.
 
Regards,
8 REPLIES
muratakbar
Occasional Contributor

Re: kRunCacheManager for single request

Hi,

 

Flushing caches doesn't work for only one request.

Another and easier option is to set LAST_UPDATE_DATE and LAST_UPDATED_BY columns. In this way you don't have to run kRunCacheManager.sh

 

Regards,

Murat Akbar

manaschandra
Super Collector

Re: kRunCacheManager for single request

Thanks for the reply akbar.

 

Last_updated_by and last_update_date is already there in my update statement. Still unable to see updated data on my request.

muratakbar
Occasional Contributor

Re: kRunCacheManager for single request

Did you also updated those columns for KCRT_REQUEST_DETAILS?

manaschandra
Super Collector

Re: kRunCacheManager for single request

Yup, i even tried with updating kcrt_requests, kcrt_request_details an kcrt_req_header_details as well, eventhough it is not required as i am executing my function from workflow.

 

No luck.

muratakbar
Occasional Contributor

Re: kRunCacheManager for single request

As a last check please be sure that you update LAST_UPDATE_DATE with SYSDATE. You know value should be later than last cache reset value.

Mohit_Agrawal
Frequent Visitor

Re: kRunCacheManager for single request

Hi..

 

We are also updating various parameters via execution steps and all the updated immediately without running the kRunCacheManager.sh with another execution step. You can try updating the parameters as shown below:

 

UPDATE kcrt_request_details
SET parameter1 = ''
visible_parameter1 ='',
last_update_date = SYSDATE
WHERE request_id = id and batch_number = 6;
   
UPDATE kcrt_requests
SET entity_last_update_date = SYSDATE
WHERE request_id = id;

COMMIT;

 

Thanks!!

Mohit Agrawal

Gerardo Gamez
Super Collector

Re: kRunCacheManager for single request

Hi,

 

I only run this query:

 

update kintana.kcrt_request_details
set last_update_date = last_update_date + 0.0001
where request_id in (123456);

 

update kintana.kcrt_requests
set last_update_date = last_update_date + 0.0001
where request_id in (123456);

 

update kintana.kcrt_req_header_details
set last_update_date = last_update_date + 0.0001
where request_id in (123456);

 

COMMIT;

 

And the requests indicated are affected with a flush.

 

Regards.

Gerardo

Oscar_Pereira
Frequent Visitor

Re: kRunCacheManager for single request

Hi All,

 

There is a parameter that can be set to remove the caching of Table Component entries in the clients and fetch the results directly from the database.
 
Execute the following changes on all PPM nodes:
 
1) Stop PPM
2) Open PPM_Home/conf/tune.conf
3) Update the following parameter to have a value of 0:
com.kintana.core.server.TABLE_ENTRY_CACHE_SIZE = 0
4) Run kUpdateHtml.sh
5) Run kRunCacheManager.sh command from /bin folder with the option to clear all cache within PPM.
6) Restart PPM
7) Test the Table Component caching behavior
 
Regards
Oscar Pereira
 
//Add this to "OnDomLoad" event