Processing Models Error

Hi,

I've dealt with a problem in Microsoft Basic Mining tutorial.

I done all steps exactly till Processing Models step.

At this point when a ran the processing progress an error occurred.

I took a screenshot of that error.

what is the problem? and how can I solve that? 

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Parallel>
    <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" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300">
      <Object>
        <DatabaseID>BasicDataMining</DatabaseID>
        <MiningStructureID>Targeted Mailing</MiningStructureID>
      </Object>
      <Type>ProcessFull</Type>
      <WriteBackTableCreation>UseExisting</WriteBackTableCreation>    </Process>

  </Parallel>
</Batch>
Processing Mining Structure 'Targeted Mailing' completed.
Start time: 3/24/2015 10:18:32 AM; End time: 3/24/2015 10:18:35 AM; Duration: 0:00:02
Processing Dimension 'Targeted Mailing ~MC-Customer Key' failed.
Start time: 3/24/2015 10:18:32 AM; End time: 3/24/2015 10:18:35 AM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:33 AM; Duration: 0:00:00
Processing Dimension Attribute 'Address Line1' completed. 12798 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[AddressLine1] AS [dbo_vTargetMailAddressLine10_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Address Line2' completed. 168 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[AddressLine2] AS [dbo_vTargetMailAddressLine20_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Bike Buyer' completed. 3 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[BikeBuyer] AS [dbo_vTargetMailBikeBuyer0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Commute Distance' completed. 6 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[CommuteDistance] AS [dbo_vTargetMailCommuteDistance0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Customer Key' failed. 10000 rows have been read.
Start time: 3/24/2015 10:18:34 AM; End time: 3/24/2015 10:18:35 AM; Duration: 0:00:00
Error Messages 2
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_vTargetMail', Column: 'AddressLine1', Value: '8011 McNutt Ave'. The attribute is 'Address Line1'. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Customer Key of Dimension: Targeted Mailing ~MC-Customer Key from Database: BasicDataMining, Record: 12749.
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_vTargetMail', Column: 'AddressLine1', Value: '8011 McNutt Ave'. The attribute is 'Address Line1'. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Customer Key of Dimension: Targeted Mailing ~MC-Customer Key from Database: BasicDataMining, Record: 12749. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while the 'Customer Key' attribute of the 'Targeted Mailing ~MC-Customer Key' dimension from the 'BasicDataMining' database was being processed.
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[CustomerKey] AS [dbo_vTargetMailCustomerKey0_0],[dbo_vTargetMail].[AddressLine1] AS [dbo_vTargetMailAddressLine10_1],[dbo_vTargetMail].[AddressLine2] AS [dbo_vTargetMailAddressLine20_2],[dbo_vTargetMail].[BikeBuyer] AS [dbo_vTargetMailBikeBuyer0_3],[dbo_vTargetMail].[CommuteDistance] AS [dbo_vTargetMailCommuteDistance0_4],[dbo_vTargetMail].[EmailAddress] AS [dbo_vTargetMailEmailAddress0_5],[dbo_vTargetMail].[EnglishEducation] AS [dbo_vTargetMailEnglishEducation0_6],[dbo_vTargetMail].[EnglishOccupation] AS [dbo_vTargetMailEnglishOccupation0_7],[dbo_vTargetMail].[FirstName] AS [dbo_vTargetMailFirstName0_8],[dbo_vTargetMail].[Gender] AS [dbo_vTargetMailGender0_9],[dbo_vTargetMail].[GeographyKey] AS [dbo_vTargetMailGeographyKey0_10],[dbo_vTargetMail].[HouseOwnerFlag] AS [dbo_vTargetMailHouseOwnerFlag0_11],[dbo_vTargetMail].[LastName] AS [dbo_vTargetMailLastName0_12],[dbo_vTargetMail].[MaritalStatus] AS [dbo_vTargetMailMaritalStatus0_13],[dbo_vTargetMail].[NumberCarsOwned] AS [dbo_vTargetMailNumberCarsOwned0_14],[dbo_vTargetMail].[NumberChildrenAtHome] AS [dbo_vTargetMailNumberChildrenAtHome0_15],[dbo_vTargetMail].[Region] AS [dbo_vTargetMailRegion0_16],[dbo_vTargetMail].[TotalChildren] AS [dbo_vTargetMailTotalChildren0_17]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
  ORDER BY [dbo_vTargetMail].[CustomerKey]
  ASC
Processing Dimension Attribute 'Email Address' completed. 18485 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[EmailAddress] AS [dbo_vTargetMailEmailAddress0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'English Education' completed. 6 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:33 AM; Duration: 0:00:00
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[EnglishEducation] AS [dbo_vTargetMailEnglishEducation0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'English Occupation' completed. 6 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[EnglishOccupation] AS [dbo_vTargetMailEnglishOccupation0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'First Name' completed. 671 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[FirstName] AS [dbo_vTargetMailFirstName0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Gender' completed. 3 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[Gender] AS [dbo_vTargetMailGender0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Geography Key' completed. 337 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[GeographyKey] AS [dbo_vTargetMailGeographyKey0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'House Owner Flag' completed. 3 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:33 AM; Duration: 0:00:00
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[HouseOwnerFlag] AS [dbo_vTargetMailHouseOwnerFlag0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Last Name' completed. 376 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[LastName] AS [dbo_vTargetMailLastName0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Marital Status' completed. 3 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:33 AM; Duration: 0:00:00
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[MaritalStatus] AS [dbo_vTargetMailMaritalStatus0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Number Cars Owned' completed. 6 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[NumberCarsOwned] AS [dbo_vTargetMailNumberCarsOwned0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Number Children At Home' completed. 7 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:33 AM; Duration: 0:00:00
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[NumberChildrenAtHome] AS [dbo_vTargetMailNumberChildrenAtHome0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Region' completed. 4 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:33 AM; Duration: 0:00:00
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[Region] AS [dbo_vTargetMailRegion0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Processing Dimension Attribute 'Total Children' completed. 7 rows have been read.
Start time: 3/24/2015 10:18:33 AM; End time: 3/24/2015 10:18:34 AM; Duration: 0:00:01
SQL queries 1
SELECT 
  DISTINCT
 [dbo_vTargetMail].[TotalChildren] AS [dbo_vTargetMailTotalChildren0_0]
  FROM [dbo].[vTargetMail] AS [dbo_vTargetMail]
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while the 'Customer Key' attribute of the 'Targeted Mailing ~MC-Customer Key' dimension from the 'BasicDataMining' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Server: The operation has been cancelled.
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_vTargetMail', Column: 'AddressLine1', Value: '8011 McNutt Ave'. The attribute is 'Address Line1'.
Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Customer Key of Dimension: Targeted Mailing ~MC-Customer Key from Database: BasicDataMining, Record: 12749.

March 22nd, 2015 6:57pm

Hi Katherine,

Thank you for your attention,

I've also added some more information about the error.I hope it can help you.

best regards,

Armin Rasoulian



Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 4:47am

"Internal error: The opeartion terminated unsuccessfully" means that SSAS encountered exceptions. It usually occurs when you have an old version of SQL Server. Could you please update your SSAS to the latest service pack and see whether the issue still happens?
March 25th, 2015 6:21am

Hi,

Yes I'm using "11.0.2100.60" version of sql server 2012 that means "RTM (no SP)" version of sql server. I will update my sql server to SP2 and check that again.

Thanks for your help Regards,

Armin Rasoulian

Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 7:48am

Hi,

I've updated it and unfortunately the issue still happens.

Now my SSAS version is : Version 11.0.5058.0

Now what can I do? 

March 25th, 2015 7:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics