This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 84%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZP%3C/text%3E%3C/svg%3E)
Hello,
I use MS SQL Server 2022 with Analysis Services. I see a lot of errors in the log:
The file '<ccon>NLevelDecodeStore_<GUID>.tmp</ccon>' could not be deleted. Please check the file for permissions.
The file '<ccon>PropStore_<GUID>.tmp</ccon>' could not be deleted. Please check the file for permissions.
The file '<ccon>PropStore_<GUID>idx.tmp</ccon>' could not be deleted. Please check the file for permissions.
etc.
The Temp folder has all the privileges it needs. The service account running Analysis Service has all the privileges. I also see that the tmp files are created when the service starts and deleted when it stops, so it looks like it has permissions to work with those files.
Any idea what could be wrong?
Thanks
Zbynek
I don't work with Analysis Services, so I don't know any details here. However, when it comes to permissions, have you checked if the files might be marked as readonly?
No, there isn't read-only checked in file properties, and the "attrib" command only says "A".
No, it has only "A" attribute.
There was one more message in the log, "Software usage metrics failed to start."
I found the article below, applied the workaround and restarted the server. The message "Software usage metrics failed to start." is still there, but other errors seem to have disappeared. We'll see in a few days, but it looks promising.
https://learn.microsoft.com/en-us/troubleshoot/sql/analysis-services/error-1032-application-log
nope, it's back