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?
  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.
  3. shahab03 Member

    Satya

    His error is little different than mine. Any other ideas?

Share This Page