Error: The Team System cube either does not exist or has not been processed
When I tried to open any report, I always got the error message like this:
- An error has occurred during report processing. (rsProcessingAborted)
- Query execution failed for data set 'IterationParam'. (rsErrorExecutingCommand)
- The Team System cube either does not exist or has not been processed.
- Query execution failed for data set 'IterationParam'. (rsErrorExecutingCommand)
I followed the warehouse troubleshooting guide and ran the sql query in the step 2, the result is like this:
Last Cube Processing
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(0 row(s) affected)
LastVCWHWrite
-----------------------
2006-02-28 16:13:36.237
(1 row(s) affected)
LastWITWHWrite
-----------------------
2006-02-28 16:13:34.923
(1 row(s) affected)
WH Revisions
------------
31
(1 row(s) affected)
WIT Revisions
-------------
31
(1 row(s) affected)
WH Changeset
------------
10
(1 row(s) affected)
VC Changeset
------------
10
(1 row(s) affected)
Warehouse Identity Id
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
39
(1 row(s) affected)
Integration Identity Id
-----------------------
39
(1 row(s) affected)
Warehouse Structure Id
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
17
(1 row(s) affected)
Integration Structure Id
------------------------
17
(1 row(s) affected)
Obviously the cube was never processed successfully. Therefore I manually called warehousecontroller.asmx to force a rebuild. After it was done, I noticed there were one warning message and one error message in the application log of the event viewer, both are event 3000.
The first one is the warning message:
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 2/28/2006 9:13:53 PM
Machine: SPRI11D12051
Application Domain: /LM/W3SVC/2/Root/Warehouse-4-127856129804963882
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 5344
Thread Id: 4444
Account name: [domainname]\[username]
Detailed Message: Processing OLAP failed
Exception Message: MdxScript(Team System) (64, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (66, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (68, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (70, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (72, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (74, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (76, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (78, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (4, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (10, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (16, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (18, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (4, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (10, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (16, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (18, 1) The END SCOPE statement does not match the opening SCOPE statement.
(type OperationException)
Exception Stack Trace: at Microsoft.AnalysisServices.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.CommitTransaction()
at Microsoft.AnalysisServices.Server.CommitTransaction()
at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
The second one is the error message:
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 2/28/2006 9:13:54 PM
Machine: SPRI11D12051
Application Domain: /LM/W3SVC/2/Root/Warehouse-4-127856129804963882
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 5344
Thread Id: 4444
Account name: [domainname]\[username]
Detailed Message: Cube processing runtime error: \r\nMicrosoft.AnalysisServices.OperationException: MdxScript(Team System) (64, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (66, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (68, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (70, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (72, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (74, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (76, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (78, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (4, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (10, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (16, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (18, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (4, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (10, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (16, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (18, 1) The END SCOPE statement does not match the opening SCOPE statement.
at Microsoft.AnalysisServices.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.CommitTransaction()
at Microsoft.AnalysisServices.Server.CommitTransaction()
at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.RunCubeProcess()
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Could someone give me any hints?
- An error has occurred during report processing. (rsProcessingAborted)
Answers
I think you were on the right track with the warehouse troubleshooting guide. Skip to the section called "OLAP Schema can become out of sync." That describes how to rebuild the OLAP schema and cube.
The warehouse troubleshooting guide can be found here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1
following these steps finally solved it
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=317697&SiteID=1
All Replies
- Could someone help me here please? It is obvious that the cube was never processed because of the exception. But I am not sure why,
I think you were on the right track with the warehouse troubleshooting guide. Skip to the section called "OLAP Schema can become out of sync." That describes how to rebuild the OLAP schema and cube.
The warehouse troubleshooting guide can be found here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1
Same issue here and have tried everything in the forums. We use english regional settings so that is not the issue??? We are running sp1. If i right click on the cube in sql server and try to process it i get the same errors. I have rebuilt the cube using setupwarehouse which ran successfully, but I still get the following when running http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx?op=Run
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 6/18/2007 2:40:18 PM
Machine: ATLTFS01
Application Domain: /LM/W3SVC/3/Root/Warehouse-2-128266495959817500
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4428
Thread Id: 4884
Account name: DOMAIN\XXXXX
Detailed Message: Create OLAP failed
Exception Message: MdxScript(Team System) (64, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (66, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (68, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (70, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (72, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (74, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (76, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (78, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (4, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (10, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (16, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (18, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (3, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (5, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (9, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (11, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (4, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (6, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (8, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (10, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (12, 48) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (14, 1) The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (16, 46) The '[Str]' function does not exist.
The END SCOPE statement does not match the opening SCOPE statement.
MdxScript(Team System) (18, 1) The END SCOPE statement does not match the opening SCOPE statement.
(type OperationException)
Exception Stack Trace: at Microsoft.AnalysisServices.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.CommitTransaction()
at Microsoft.AnalysisServices.Server.CommitTransaction()
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccount, Boolean dropDB, Boolean processCube)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
following these steps finally solved it
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=317697&SiteID=1


