SQL Server Performance

Cube Processing Terminating abruptly

Discussion in 'SQL Server 2005 Analysis Services' started by amahalingam, Jan 31, 2008.

  1. amahalingam New Member

    Hi there,
    we are using AS2005 server for cube processing. The AS2005 Server has a job that exceutes daily for around 50 mins. In the last two weeks we observed that the job is terminating abruptly with the following message in event viewer.Message: Processing has been attempted and was not successful. Attempt 1 of 3. Reattempting processing now.
    Category: General Priority: 1 EventId: 500 Severity: Warning
    Post the issue there have been instances that AS2005 starts the job automatically if not a person has to manually start the job. adding fuel to the scenario, the AS2005 Service is running without any issues.
    please help.
  2. satya Moderator

    Do you have any other jobs running at the same time?
    Also check for any other warnings in the log such as SqL error log & event viewer log.
  3. amahalingam New Member

    No jobs were running simultaneoulsy. The error message displayed in the query is taken from event viewer.
  4. satya Moderator

    As it states its a warning, but for more information you should monitor the activites during this cube processing. See a comparision from the last time it was running successfully.

Share This Page