Team System Developer Center > Visual Studio Team System Forums > Team Foundation Server - General > Error: The Team System cube either does not exist or has not been processed
Ask a questionAsk a question
 

AnswerError: The Team System cube either does not exist or has not been processed

  • Tuesday, February 28, 2006 9:35 PMFan Ye Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    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.

    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?

Answers

All Replies

  • Wednesday, March 01, 2006 1:55 PMFan Ye Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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,
  • Wednesday, March 01, 2006 9:36 PMBill Essary MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer

    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

  • Monday, June 18, 2007 3:40 PMDanHaligas Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    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.

  • Monday, June 18, 2007 6:14 PMDanHaligas Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer