Cadet 1st Class
Cadet 1st Class
895 views

Changing table component rows directly at the DB level does not show up on UI

Jump to solution

Hi guys, 

 

Hope someone can give me a tip on the following issue:

 

We update rows in a table component on a request form using PL/SQL procedure. The updates go ok, we set last_update_date, last_updated_by and entity_last_update_date in kcrt_requests and knta_parameter_set_context table. We also set last_updated_by and last_update_date in kcrt_request_details and kcrt_table_entries to make the changes to show in UI.

 

But the changes do not show up in UI unless we run a cache manager to clear cache 8.

 

Please share ideas/tips on how to make the changes show up without cache manager run.

 

Thanks,

Dmitry

Share Knowledge
0 Likes
1 Solution

Accepted Solutions
Cadet 1st Class
Cadet 1st Class

Hi Dmitry,

 

Looks like this has come up in the past.

 

See:

http://support.openview.hp.com/selfsolve/document/KM1403926

"Table Component Updates via PL/SQL are not reflected unless you clean the application cache?"

 

The OPTION #4 looks like the one most related to the desired functionality, which is basically to disable the Table Component caching.

 

-Mike

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

View solution in original post

3 Replies
Cadet 1st Class
Cadet 1st Class

Hi Dmitry,

 

Looks like this has come up in the past.

 

See:

http://support.openview.hp.com/selfsolve/document/KM1403926

"Table Component Updates via PL/SQL are not reflected unless you clean the application cache?"

 

The OPTION #4 looks like the one most related to the desired functionality, which is basically to disable the Table Component caching.

 

-Mike

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

View solution in original post

Vice Admiral
Vice Admiral

Yes - as Mike said, disabling the TC caching should make your db updates show up immediately.  

0 Likes
Cadet 1st Class
Cadet 1st Class

Thank you Mike, this is what we were looking for.

 

Share Knowledge
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.