Answered Data Cube Deployment error.

  • lunes, 23 de julio de 2012 17:59
     
     

    I am receiving the error below in the Operations Manager event log of the Data Warehouse.  How do I "back up the AS DB, delete all cubes defined in MP manually from the AS DB and restart deployment"?

    Log Name:      Operations Manager
    Source:        Data Warehouse
    Date:          7/20/2012 1:38:35 AM
    Event ID:      33557
    Task Category: None
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      Datawarehouse.site.com
    Description:

    Message : Deployment of a management pack with cubes cannot complete deployment.  The cube name SystemCenterChangeAndActivityManagementCube with id SystemCenterChangeAndActivityManagementCube already exists in the Analysis Services DB.  Please back up the AS DB, delete all cubes defined in MP manually from the AS DB and restart deployment.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Data Warehouse" />
        <EventID Qualifiers="32768">33557</EventID>
        <Level>3</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2012-07-20T07:38:35.000000000Z" />
        <EventRecordID>39943</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>Datawarehouse.site.com</Computer>
        <Security />
      </System>
      <EventData>
        <Data>SystemCenterChangeAndActivityManagementCube</Data>
        <Data>SystemCenterChangeAndActivityManagementCube</Data>
      </EventData>
    </Event>

Todas las respuestas

  • lunes, 23 de julio de 2012 18:15
     
     Respuesta propuesta

    Use SQL Management Studio to connect to your data warehouse Analysis Services database instance (the AS DB), which you defined when installing your data warehouse. Right click on your database (which is probably DWASDataBase) and back it up. After you've backed it up, drill down to the "Cubes" folder and delete the SystemCenterChangeAndActivityManagementCube. Then, in the Service Manager console, go to the Data Warehouse wunderbar, go to the Management packs, find the "Service Manager Change and Activity Management Cube Library" mp, select it, and click the Restart Deployment task.

    • Propuesto como respuesta F A D martes, 09 de abril de 2013 7:13
    •  
  • viernes, 03 de agosto de 2012 16:54
     
     
    I can't seem to find the DWASDataBase.  I have Analysis services installed on the database.  If this database is not created would I need to reinstall the Datawarehouse?
  • jueves, 09 de agosto de 2012 18:49
     
     Respondida
    I have re-installed both the SQL Database and the Datawarehouse Management server.  This error does not occur any more.
    • Marcado como respuesta Misha Rudiy jueves, 09 de agosto de 2012 18:50
    •