MSDN Community Forums

Hello everyone,

I'm encountering persistent errors when trying to process a specific measure group in my SQL Server Analysis Services (SSAS) cube. The error message is somewhat generic: "The processing process was aborted." I've checked the SSAS logs and found more detailed information pointing to a potential issue with a calculation or a data source view.

Here's the specific error from the event log:

                Errors in the OLAP storage engine: The attempt to load a record into the dimension named '[Product]' failed. The key value '[ABC-123]' was not found in the lookup table. The current batch has been aborted.
                

This is quite strange as the dimension '[Product]' does contain this key. I've tried refreshing the dimension, but the error persists. Has anyone encountered a similar issue? Any suggestions on how to debug this further?

Hi Jane,

This is a common but frustrating error. It often happens when there's a mismatch between the data in your fact tables and the dimension tables, or if there's an issue with the dimension key mapping in the cube definition.

Here are a few things you can try:

• Check the Data Source View (DSV): Ensure the relationships between your fact table and the dimension table in the DSV are correctly defined and that there are no missing links.
• Verify Dimension Key Integrity: In SQL Server Management Studio (SSMS), connect to your SSAS instance, browse the dimension, and specifically look for the key `[ABC-123]`. If it's truly there, try to re-process just the dimension in full mode.
• Check for Orphaned Records: It's possible that the fact table has a record pointing to `[ABC-123]` but this key doesn't exist in the actual source table for the '[Product]' dimension, or it was deleted after the dimension was last processed. Try running a query against your source data to find facts that link to non-existent product keys.
• Dimension Attribute Relationships: Sometimes, issues with attribute relationships within the dimension can cause processing failures. Double-check these in the dimension designer.

Could you share the specific measure group and any calculations involved if these steps don't help?

Thanks Sam, that's very helpful!

I've gone through your suggestions:

1. The DSV relationships look correct.
2. I double-checked the '[Product]' dimension in SSAS, and the key `[ABC-123]` is indeed present. I performed a full process on the dimension, and it succeeded without errors.
3. This is where I found something interesting. I ran a query in my source database like this:

                           SELECT COUNT(*) FROM FactSales fs
                           WHERE NOT EXISTS (SELECT 1 FROM DimProduct dp WHERE fs.ProductID = dp.ProductID);
                           

   This query returned 0 records. So, it doesn't seem like orphaned records in the fact table.
4. I reviewed the attribute relationships for the '[Product]' dimension. The 'Product' attribute is the key, and it has other attributes like 'Product Name', 'Category', etc. They seem correctly set up.

After re-processing the dimension fully, I attempted to process the measure group again, and the error is still occurring. The error message from the event log remains the same. Could it be an issue with the specific measure group's data? It's a sales fact table.