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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Hi All,
SSAS DB synchronization failed with error: "Synchronization Database Error: The connection eiter timed out or was lost"
When checked MSSQLServerOLAPService service was stopped and it logged below error in application log(event viewer):
The description for event id 22 from source mssqlserverolapservice cannot be found. Either the component that raises this event isnot installed on your local computer or the installation is corrupted. you can install or repair the component on the local computer. If the event originated on another computer....
file system error: the following error occurred during a file operation:The process cannot access the file because it is being used by another process.. (\?\F:\OLAP\Data\ESS MOLAP ISSUMT.381.db\EAL.2167.cub\kjsd.det\sdsds.2152.prt\2258.fact.data)
And msmdsrv.log file logged below error:
(2/9/2020 3:51:55 AM) Message: (Source: \?\E:\OLAP\Log\msmdsrv.log, Type: 3, Category: 256, Event ID: 0xC1000016)
Since this issue is intermittent(approx once in a month), couldn't use profiler till now.
Does any of you think using SQL profiler will capture more detail.
please help with any advise /solution
![](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(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
The 'another process' is most probably not a part of the MSSQL suite so won't be accessible through the Profiler. The usual suspects are antivirus or file indexing processes, and they need to be tracked at the OS level. Note that the file with which the error occurred is a .fact.data, and these are the largest.
Many Thanks @Alexei Stoyanovsky for your response,
Is it possible that 2 synchronization jobs starting at approx same time for different SSAS DB under one same SSAS instance would have triggered this problem?
Any thought on this?
I'd say this depends on whether the two syncs proceed at the same time thus consuming server's resources. If the culprit is a constantly active background process, and since you know the issue is intermittent, it looks like sometimes said process doesn't release its lock fast enough for the sync to go ahead. The chance for that can well increase with the size of the file and with server's general load level.
However, it is also possible, for example, that the locking process simply has some quirk that sometimes makes it hold the lock too long depending on some obscure set of circumstances.
![](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(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
I don't believe this is caused by 2 sync jobs since the error explicitly states that the file is in use by another process. Like Alexei said, this is most often caused by things like AV or search indexers and the OLAP data folder should be excluded from both of these processes. And the file in question is for fact data in one of your databases. A sync process on another database would be accessing files in a different folder.
![](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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
If this is intermittently happening, would it possible for us to know the trigger or time ? So that you could trace it .
But as the error info, it could be the db is being processed and blocking by other job or task.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi,
Have you resolved this issue ?
We 'd be happy to know any feedback, and see if we could offer more help?