Home > Uncategorized > Mining Structure: Issue while Processing when DataSource is OLAP Cube

Mining Structure: Issue while Processing when DataSource is OLAP Cube

 

When processing SSAS Data Mining Structure which is based on a Cube (DataSource is Used as Cube) in such a case Analysis Services uses service Startup Account while processing Mining Structure.

image

If Analysis Services Startup Account doesn’t have Full Permission on OLAP Cube then processing will fail with below mentioned error:

Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: The UseTransaction and MasterTransaction request properties are reserved for database administrators..
Errors in the OLAP storage engine: An error occurred while processing the ‘Internet ~1 ~MG’ partition of the ‘Internet ~1 ~MG’ measure group for the ‘Customer Clusters ~MC’ cube from the Adventure Works DW 2008R2 database.
Server: The operation has been cancelled.
Errors in the OLAP storage engine: An error occurred while processing the ‘~CaseDetail ~MG’ partition of the ‘~CaseDetail ~MG’ measure group for the ‘Customer Clusters ~MC’ cube from the Adventure Works DW 2008R2 database.

To work around this issue –
Ensure that <ServiceAccountIsServerAdmin> Property in msmdsrv.ini file is set to 1 (True)
Default – Location of msmdsrv.ini file (C:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config)
Or
Create a Role in Database – Grant Full Control to this Role and Add Service Account Member of this Role

About these ads
Categories: Uncategorized
  1. October 18, 2012 at 10:42 am

    Thanks. It’s realy usefull.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: