Re: Cube Processing Failure - no error message

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 13:53:28 -0700

Are there any entries in the system-wide processing log file?
See the Analysis Services Operations Guide in the "Processing log file"
section
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Diane Blackwood" <Diane_Blackwood@kirkland.com> wrote in message
news:19a401c4a25c$bd6b18e0$a301280a@phx.gbl...
> In the last month, some of the cubes in a cube database
> have been failing to process, while other cubes in the
> database process.  This is run every day on a schedule by
> a DTS package.  The Analysis Server is not sending an
> error message to the DTS package.
> When I use Analysis Manager and choose "process database",
> the same thing happens:  The database processes through
> the cube where it has been stopping and then
> says "completed successfully".  I have to go into the
> database and process the individual cubes one at a time in
> order to get them processed.  When I do this, they process
> successfully.
> Why might this suddenly be failing?
> What are appropriate correction steps?
> Has anyone else experienced this?

Relevant Pages

  • Re: Cant connect to / see cube
    ... SQL BI Product Unit (Analysis Services) ... > I have a development domain, with one server running SQL Server 2000 sp ... > I restored the database from a cab-file, ... > prosess 2 out of 4 individual cubes. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Exporting Analysis Server objects (cubes, dimensions, etc) to Business Intelligence Studio
    ... Intelligence folder choose the "Import Analysis Services 9.0" project. ... should then be prompted for a Server and Database to connect to and BIDS ... Darren Gosbell - SQL Server MVP ... How do I export or copy these cubes from the server to my local computer ...
    (microsoft.public.sqlserver.olap)
  • Re: HELP I am about to quit on AS2005
    ... Create an Analysis Services Project Based on an Existing ... Analysis Services Database ... Working with Diagrams in a Data Source View ...
    (microsoft.public.sqlserver.olap)
  • Re: HELP I am about to quit on AS2005
    ... Create an Analysis Services Project Based on an Existing ... Analysis Services Database ... Working with Diagrams in a Data Source View ...
    (microsoft.public.sqlserver.olap)
  • Re: Relational to DW.?
    ... Analysis Services for some time. ... data on the same server. ... > interesting question......I assume your 'relational database' is for a ... > just finished it but have not put the pointer to it on my web site ...
    (microsoft.public.sqlserver.datawarehouse)