Clear Server Cache button in ATLAS does not work

[konstjar]

Expected behaviour

ATLAS has "Clear Server Cache" button on Configuration page. Expected that endpoint is present and it clears all in-memory cache and truncates "cdm_cache" table in application database. Maybe anything else?

Actual behavior

Clicking it request goes to WebAPI/cache/clear endpoint that does not exist. 404 comes as response.
API Documentation does not show the endpoint too: http://webapidoc.ohdsi.org

Steps to reproduce behavior

1. Enable authentication in ATLAS/WebAPI
2. Open Configuration page with "admin" role
3. Click "Clear Server Cache" button

[chrisknoll]

Possible dupe of OHDSI/Atlas#2847.

[anthonysena]

For reference, we're referring to this button:

The proposed behavior should be: clear all results from the WebAPI cdm_cache and achilles_results_cache tables. This would work across all cached data sources configured in WebAPI. Perhaps we rename this button "Clear WebAPI cache"?

Question: should this only clear the cached data in the WebAPI database and/or the CDM(s) results table(s)?

For this button:

We'd clear the table that holds the achilles_record_count and re-build and re-cache this information in the WebAPI database? Perhaps we need to rename this "refresh record count cache"?

[anthonysena]

Noting the WebAPI endpoints for the buttons above:

• Clear Server Cache: WebAPI/cache/clear
• Data Source Refresh: WebAPI/cdmresults/<sourceKey>/refreshCache