Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dimension key errors despite having selected Ignore Errors Expand / Collapse
Author
Message
Posted Monday, February 28, 2011 6:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 6:20 AM
Points: 24, Visits: 201
Hi,

We have been noticing weird behavior with one of our cubes which has been running fine for the past few years. The cube partitions get processed through a SSIS package which is then scheduled through a SQL Server job.

For the past few days, we have noticed that the processing of a particular partition is failing because of dimension key errors. What's surprising is that the package has been configured to Ignore Errors.

We also tried processing the partition manually through SSMS, but we get the same error.

Not sure if this info is of any use, but the dimensions get processed before the partitions do.

Please find below the output from SSIS:

SSIS package "Test.dtsx" starting.
Error: 0xC1000007 at Process CUBENAME cube, Analysis Services Execute DDL Task: Internal error: The operation terminated unsuccessfully.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '101907'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '489'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: PARTITIONNAME, Record: 113200.
Error: 0xC1010000 at Process CUBENAME cube, Analysis Services Execute DDL Task: The following system error occurred: Unspecified error
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'PARTITIONNAME' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Error: 0xC11C0002 at Process CUBENAME cube, Analysis Services Execute DDL Task: Server: The operation has been cancelled.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '68570'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '6462'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2011_Q12, Record: 90000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2011_Q12' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '51893'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '431'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2006, Record: 69842.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2006' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '46136'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '1870'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2010_Q12, Record: 80000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2010_Q12' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '223690'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '1504'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2009_Q12, Record: 90000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2009_Q12' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '145572'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '982'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2008_Q34, Record: 98327.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2008_Q34' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '40623'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '901'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2007_Q34, Record: 50000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2007_Q34' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '34173'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '1504'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2009_Q34, Record: 64623.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2009_Q34' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '132035'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '1606'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2008_Q12, Record: 80000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2008_Q12' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '4598'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '901'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP Partition: CUBENAME_2007_Q12, Record: 60000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'CUBENAME_2007_Q12' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Warning: 0x811F0001 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'FACT_TABLE', Column: 'CUST_KEY', Value: '273173'; Table: 'FACT_TABLE', Column: 'COLUMN', Value: '1870'. The attribute is 'ATTRIBUTE'.
Warning: 0x811F0003 at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: ATTRIBUTE of Dimension: Customer from Database: DATABASE, Cube: CUBENAME, Measure Group: MEASUREGROUP, Partition: CUBENAME_2010_Q34, Record: 190000.
Error: 0xC11F000E at Process CUBENAME cube, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'PARTITION_NAME_2' partition of the 'MEASUREGROUP' measure group for the 'CUBENAME' cube from the DATABASE database.
Task failed: Process CUBENAME cube
SSIS package "Test.dtsx" finished: Success.
Post #1070453
Posted Thursday, March 3, 2011 8:22 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
Is the SSIS package configured to ignore errors, or is the error handling of the cube itself configured to ignore them?

I've found that changing the error handling of dimensions to default and then custom, followed by careful examination of the settings there can help a lot.

Are you processing dimensions, then measures, then the cube as a whole in that order? I've found that you have to process dimensions first to get them up to speed before you process the data or you can get those kinds of errors too.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1072596
Posted Friday, March 4, 2011 8:14 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 815, Visits: 2,031
I don't have mine configured to ignore errors, but as you have a bunch of these, I would beat that it IS ignoring the errors in the sense that it continues. But there's still a problem and it's letting you know.

You don't provide enough information for me to know for sure, but you are probably either trying to process the cubes and dimensions in the same same or you are not processing the dimension at all. It would be nice if you could use a single step to process both the dimensions and the cubes. These need to be two steps, however, with the dimensions that could have changed processed first, followed with another processing step with that processes the cubes.

This would be nice fix in a future version as I can't think for the life of me why it would ever be better to process the cubes ahead of the dimensions.



Post #1073359
Posted Thursday, March 24, 2011 1:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 6:20 AM
Points: 24, Visits: 201
Hi,

Sorry for replying late, but I've been traveling.

Thanks for the replies. We noticed that this was happening because of some connectivity issues with the Oracle data source. Took us a few days to notice this. It eventually turned out to be a problem with the DNS server, and once this got fixed, everything started working fine again.

Once again, thanks for replying! Have a good one!
Post #1083555
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse