Databases
StackOverflow2013
Postsdbo
POSSAS Cube reprocessing fails - then succeeds if I try again
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSSAS Cube reprocessing fails - then succeeds if I try again
    primarykey
    data
    text
    <p>So I'm basically brand new to the concept of BI, and I've inherited an existing ETL process that is a two step process:</p> <ol> <li><p>Loads the data into a database that is only used by the cube processing </p></li> <li><p>Starts off the SSAS cube processing against said database</p></li> </ol> <p>It seems pretty well isolated, but occasionally (once a week, sometimes twice) it will fail with the following exception:</p> <p>"Errors in the OLAP storage engine: The attribute key cannot be found"</p> <p>Now the interesting thing is that:</p> <ol> <li><p>The dimension having the issue is not usually the same one (i.e. there's <strong>no single dimension that consistently has this failure</strong>)</p></li> <li><p><strong>The source table</strong>, when I inspect it, <strong>does actually contain the attribute key</strong> that it says could not be found</p></li> <li><p><strong>If I then immediately reprocess</strong> the dimensions and cubes manually through SSMS, <strong>they reprocess successfully</strong> and without incident.</p></li> </ol> <p>In both the aforementioned job and when I reprocess them through SSMS, I am using "ProcessFull", so it should be reprocessing them completely.</p> <p>Has anyone run into such an issue? I'm scratching my head about it... because if it was a genuine data integrity issue, reprocessing the cube again wouldn't fix it. What on earth could be happening? I've been tasked with finding out why this happens, but I can neither reproduce it consistently nor can I point to a data integrity problem as the root cause.</p> <p>Thanks for any input you can provide!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEdgarVerona
    1. USEdgarVerona
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSSAS Cube reprocessing fails - then succeeds if I try again
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSSAS Cube reprocessing fails - then succeeds if I try again
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSSAS Cube reprocessing fails - then succeeds if I try again
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload