February 12, 2012 at 9:18 pm
Hi all,
Am trying to troubleshoot a full cube job that's been failing intermittently. The steps of the job is as below.
Is SalesDW the Analysis Services database? Is this database always on where the cube is created? I check under the Database tab and cannot find any database named SalesDW?:blush:
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">
<Object>
<DatabaseID>SalesDW</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Batch>
This full cube job has been failing in most cases with the following errors:
Error:
<Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully."
Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" />
<Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully."
Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" />
<Error ErrorCode="3239182364" Description="Errors in the high-level relational engine.
The following exception occurred while the managed IDbCommand interface was being used:
A transport-level error has occurred when receiving results from the server.
(provider: TCP Provider<c/> error: 0 - The semaphore timeout period has expired.)."
Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034318" Description="Errors in the OLAP storage engine:
An error occurred while processing the '<partition name>' partition of the '<measure group>' measure group for the '<cube name>' cube from the SalesDW database."
Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" />
<Error ErrorCode="3239837702" Description="Server: The current operation was cancelled because another operation in the transaction failed."
Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" />
I tried setting the registry based on what's recommended in the URL below. It has worked for a day and then it is starting to fail again. Is the fix recommended below supposed to be done on the Analysis Services server or on the source database?
http://blogs.msdn.com/b/mssqlisv/archive/2008/05/27/sql-server-intermittent-connectivity-issue.aspx
The error seems to be a timeout settings of sort but don't know where there is a timeout settings set in SQLServer.
Any advise much appreciated. Thanks in advance.
February 14, 2012 at 1:41 pm
The cube can reside on a different server, yes.
If you connect to Analysis Services on the server that the data lives on, you can see if that's where the cube lives, too. The cube lives in Analysis Services, you can't see it from the "normal" SQL DB engine interface.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply