OLAP Cube failed - invalid column name...

  • Thread starter Ncrease MSProject consultant
  • Start date
N

Ncrease MSProject consultant

This is the message I'm getting in PWA 'Current Cube Status'...
(-2147221386) Invalid column name 'RES_IS_ACTIVE'.;42S22

MS Project Pro 2002, MS Project Server 2002

I do no know what table this column is in.? I went into enterprise manager
and browsed the SQL - nothing. I had my dba create a script to querry the
SQL - nothing.

Is it possible one of my users created this column? If so, How do I fix it
so I can successfully build my OLAP.


Thanks
 
N

Ncrease MSProject consultant

Thanks Gerard but that doesn't seem to be the answer.

It is somehow see the column 'Res_Is_Active' and is declaring the name
invalid. I can't find it anywhere in any table though?! and it seems to have
appeared all of a sudden because none of my peopled added the column.

Help!!
 
Top