Problem Note 65846: Publishing a profiling project in SAS® Size Profiling generates the message "ERROR: An error occurred updating profiles with new and closed stores"
 |  |  |  |  |
In SAS Size Profiling, publishing a profiling project might generate errors similar to the following in the stored-process server log:
ERROR: An error occurred updating profiles with new and closed stores.
ERROR: A lock is not available for GSY.RMVSTR_XXXXXX.DATA.
ERROR: Lock held by process 518.
ERROR: File GSY.EXCLUDED_STORES_XXXXXX.DATA does not exist.
ERROR: A lock is not available for GSY.RMVSTR_XXXXXX.DATA.
ERROR: Lock held by process 518.
ERROR: File GSY.EXCLUDED_STORES_XXXXXX.DATA does not exist.
To work around this issue, cancel the publishing process and republish the project after the files in the SAS-datamart-location/dm/geo_synchtemp location are deleted.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Linux for x64 | 3.41 | 3.41 | 9.4 TS1M4 | 9.4 TS1M4 |
A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#65846A fix for this issue for SAS Size Optimization 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W19.html#65846| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-04-21 11:39:15 |
| Date Created: | 2020-04-14 11:43:23 |