Locking while processing a dimension in SSAS2008
Jesse O
been experiencing locked files while running a Process Update on a dimension
with Process Affected Objects selected. This doesn't happen when the Process
Affected Objects option is NOT selected. It'll happen several times a day.
From what I understand the dimensional process is attempting to rebuild
aggregations and is failing immediately when it can't get a lock on the
appropriate files. We've experienced this behavior across all databases;
it's just not one.
I've disabled the Flight Recorder, disabled Lazy Processing and the
CommitTimeout is set to 15000. It's a very beefy server, 16 way/64GB of RAM.
The box isn't breaking a sweat.
I'm at a loss...any ideas?
Error within the Management Studio dialog box:
File system error: The following error occurred while opening the file
'\\?\D:\SSAS2008\Data\Distribution Hourly.0.db\Distribution
Info.0.cub\vFact_HourlyInstallSummaryCurrent.0.det\D_20091024.0.prt\5.Date.Year.agg.rigid.map'.
Errors in the OLAP storage engine: An error occurred while processing the
indexes for the D_20091024 partition of the
vFact_HourlyInstallSummaryCurrent measure group of the Distribution Info
cube from the Distribution Hourly database.
Event Viewer Error:
The file '\\?\D:\SSAS2008\Data\Distribution Hourly.0.db\Distribution
Info.0.cub\vFact_HourlyInstallSummaryCurrent.0.det\D_20091024.0.prt\5.Date.Year.agg.rigid.map'
could not be opened. Please check the file for permissions or see if other
applications locked it.
Jesse O
Classiarius
> Anyone?
>
> :)
>
> "Jesse O" <jespe...@hotmail.com> wrote in message
Use the NOLOCK hint on your data source, *if you can*. I've done this
to our data warehouse DB (it's read-only anyway) and SSAS processes
faster w/o the use of needless locks.
Jesse O
within SSAS....
Thank you!
"Classiarius" <class...@gmail.com> wrote in message
news:a00cfdc4-a5db-451f...@k4g2000yqb.googlegroups.com...
Epan
Thanks.