Cube doesn't build automatically

[Ahmed Ghaith]

Hello,

Having gone through all of the setup step-by-step, all seems fine when
building the Cube. I can create Data Analysis Views, etc.
The problem is that the Cube doesn't build automatically based on my
settings (every night).
I don't get any error (like it failed to build or anything) and the status
just shows successful completion on the day\time I manually built it last.
Is there some timer service or something I am missing? SQL Server
2005 and Analysis Services 2005 SP2 on one machine, PS 2007 on another.
The Windows SharePoint timer service is started.

Thanks.

 

[Ben Howard]

Hi Ahmed,
This is reliant on the timer service, which as you say is running. Make
sure the two servers are set to the same time and timezone etc, there have
been issues if these are out of synch between the servers.

 

[Ahmed Ghaith]

Hi Ahmed,
This is reliant on the timer service, which as you say is running. Make
sure the two servers are set to the same time and timezone etc, there have
been issues if these are out of synch between the servers.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Thanks to replay

i check all things its OK but i still doesn't know ehat the problem.

Thanks again.

 

[Ben Howard]

Okay, then, confirming that the cube builds okay manually, you'll need to
check the ULS logs to find more information. Also, are you getting any
failed jobs in the queue. Setting the cube to build hourly will shorten your
troubleshooting duration.

Also, in the Timer Job Definitions, you should see a CubeAdminSRPJob, that
relates to the instance of project server - worth confmining that this is
there and not disabled. Also, you should be able to see the last status of
this job in the timer job status - what does this say?
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Ahmed Ghaith]

when i check the Timer Job Status i found "Application Server Administration
Service Timer Job" is failed what can i do?

 

[Ben Howard]

Hi Ahmed, well now you have found an error, I would troubleshoot that.
Google perhaps? ULS logs?
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[ProjmanZA]

Hi there ,

Have you tried restarting the Sharepoint Timer service ?

 

[ProjmanZA]

Hi,

I make restart  for "Windows SharePoint Services Timer" from services (MMC)
and the service is stopped now but i cannot make start again, could you help
me please.

Ahmed ,

That points to an underlying problem. could you post your eventlog
here ??

Andre

 

[Ahmed Ghaith]

hi,

every thing now its OK,i made restart the server then i was restart to this
service then every thing its OK,
Tthanx alot every body.