We have a number of jobs that process cubes when table loads complete. The last step in each of these jobs is to reprocess a "verification cube", which contains as linked measures the record counts from ALL other cubes. (We have a report which compares this against a direct SQL record count from the tables).
Anyway, we appear to have jammed up our Analysis Server (and had to restart) because one completing job issued a reprocess command for this "verification cube" while it (the verification cube) was still reprocessing in response to a previous job's completion.
OK, babbling aside, within a job I need to be able to ask "Is the verification cube currently processing, and if not, reprocess it".
Is this trivial, and I am not thinking correctly ? Any suggestions will be appreciated.
Which version of SQL Server 2000 or 2005 you are talking about?
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
2005.
Just to mention . . . this has only happened once, and may just be one of those things . . . . But of course if we can better understand the problem and program to avoid it, that would be better.
|||
You should probably create a synchronization logic within your application and not let multiple jobs kick processing of the cube.
It is very hard to say whether processing of the cube is going on. The cube is not a single object it has multiple measure groups. Many processing commands, especially batch commands can include processing of any number of cube objects.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
No comments:
Post a Comment