So, I've been working to get my reports working again and have been able to after rebuilding OLAP. I have my own process template that was working perfectly fine for the past 6 months. In fact, all of the current reports/projects were built from the same exact templates.
However, now when I create a new project it appears they are not being created correctly or something is failing. After creating a new project, I attempted to manually process the warehouse and received this error on the "Code Churn" group:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: Code_x0020_Churn, Column: Changeset, Value: 380. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Changeset of Dimension: Changeset from Database: TfsWarehouse, Cube: Team System, Measure Group: Code Churn, Partition: Code Churn, Record: 36663. 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 processing the 'Code Churn' partition of the 'Code Churn' measure group for the 'Team System' cube from the TfsWarehouse database.
I can confirm the following:
- I have verified that the passwords are set
- I have rebuilt the warehouse, as this is often the suggested fix
- The OLAP and ReportDS appear to be working for existing reports
- When I check the status of the Warehouse it reads "Running Adapters"
I could use some help. :(