SSAS 2008 backup/restore fails with a GetOverlappedResult 'Insufficient system resources exist to co

Posted by Anant Aneja on Stack Overflow See other posts from Stack Overflow or by Anant Aneja
Published on 2010-05-06T13:16:03Z Indexed on 2010/05/06 13:18 UTC
Read the original article Hit count: 585

Filed under:

ssas

|

2008

|

olap

|

olap-cube

Hi,

On my SSAS 2008 instance if a backup/restore of any database is made to/from a UNC path I get an error :

The following system error occurred from a call to GetOverlappedResult for Physical file: '\server\share\OLAPDB.abf', Logical file: '' : Insufficient system resources exist to complete the requested service. . Server: The operation has been cancelled. (Microsoft.AnalysisServices)

Creating/copying/moving a file on the share of any size on the share using explorer or the command prompt works.

The most useful link I could find is : http://www.tech-archive.net/Archive/Development/microsoft.public.win32.programmer.kernel/2004-07/0475.html

Can anyone shed more light on what could be causing this error ?

(I've posted the same question on the SSAS forums - just a heads up)

© Stack Overflow or respective owner

Related posts about ssas

SSAS Maestro Training in July 2012 #ssasmaestro #ssas

as seen on SQL Blog - Search for 'SQL Blog'
A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world. In 2011 Microsoft organized two rounds of… >>> More
SSAS – Synchronisation performance

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation… >>> More
Query Logging in Analysis Services

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
On a project I work on, we capture the queries that get executed on our Analysis Services instance (SQL Server 2008 R2) and use the table for helping us to build aggregations and also we aggregate the query log daily into a data warehouse of operational data so we can track usage of our Analysis databases… >>> More
SSAS: distribution of measures over percentage

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 … >>> More
Preserving Language across inline Calculated Members in SSAS

as seen on Stack Overflow - Search for 'Stack Overflow'
Problem: I need to retrieve the language of a given cell from the cube. The cell is defined by code-generated MDX, which can have an arbitrary level of indirection as far as calculated members and sets go (defined in the WITH clause). SSAS appears to ignore the Language of the specified members when… >>> More

Related posts about 2008

SQL Server 2008 Vs Sql Server 2008 R2 in web-development

as seen on Stack Overflow - Search for 'Stack Overflow'
This will give many opportunities in Web-development transition from Sql Server 2008 to Sql Server 2008 R2: 1.If database in one instance of SQL Server. 2.a) if in the server PC have 1 processor b) if in the server PC have 4 processors >>> More
Creating an ASP.NET Database using MS SQL 2008 in Visual Web Developer 2008

as seen on ASP Free - Search for 'ASP Free'
This article illustrates how to create a database in ASP.NET. We ll be using Microsoft SQL Server 2 8 and developing it in Visual Web Developer Express 2 8. Given the importance of databases to most websites nowadays you should find this information useful when building just about any website… >>> More
Introducing SQL Server 2008 and 2008 R2 Integration Services

as seen on Internet.com - Search for 'Internet.com'
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics… >>> More
Installing and configuring SQL Server 2008 and 2008 R2 Integration Services

as seen on Internet.com - Search for 'Internet.com'
Marcin Policht shows you how to install and configure SQL Server 2008 and 2008 R2 Integration Services. >>> More
Windows Server 2008 / SQL 2008 Licensing for Authenticated Web Application

as seen on Server Fault - Search for 'Server Fault'
Hello, I'm trying to crunch some numbers to see what the software costs involved are for hosting an application we are developing. Users will not be anonymous - they will need to log in. SQL Server 2008: SQL Server licensing is easy - it will be licensed per-processor. No real fuss there. The… >>> More