SQL Server Performance

Cube processing fails

Discussion in 'Analysis Services/Data Warehousing' started by shahab03, May 23, 2006.

  1. shahab03 Member

    I get following error when processing cubes


    Step 'DTSStep_DTSOlapProcess.Task_1' failed

    Step Error Source: DSO
    Step Error Description:Cannot connect to the repository.

    Analysis server: 006-PM2-SQL01

    Error:
    Unspecified error
    Step Error code: 80040033
    Step Error Help File:
    Step Error Help Context ID:1000440

    Step Execution Started: 5/23/2006 11:52:57 AM
    Step Execution Completed: 5/23/2006 11:52:57 AM
    Total Step Execution Time: 0.125 seconds
    Progress count in Step: 0

    this is a scheduled job which runs fine if ran from designer. The Olap admin group has full rights to programfiles/microsoft analysis services/ bin directory. I am not sure what else would be causing this problem. any idea guys?
    shahab03, May 23, 2006
    #2

  2. satya Moderator

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=278209

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, May 24, 2006
    #2

  3. shahab03 Member

    Satya

    His error is little different than mine. Any other ideas?
    shahab03, May 24, 2006
    #2

Share This Page