When running the incremental process (ProcessAdd), the status seems to complete, and then everything just hangs. I can't find anything that the server is doing, but it won't return. This happens in BIDS using debug, management studio wizard, and management studio XMLA execution windows.
Sometimes I can get the first measure group to return... Once the 3rd returned. The 2nd has never worked.
Thoughts on what's happeneing? Does anyone know how to see what's going on in the background? I have a SQL trace going and a trace on the SSAS server, and nothing seems to be going on...
Thanks!
-DougI have a similar issue occurring. I have an SSIS package that uses an analysis services task to incrementally update the most recent partition in three measure groups. It hangs everytime when run under the SQL agent Job engine, however, it processes fine through the SSIS debugger in BIDS.
I think I'm going to try submitting the XMLA statement directly from the job rather than going through SSIS. Did you ever figure out the issue you were seeing?|||
Try and run Profiler against Analysis Server and see if there is any activity is goign on.
Make sure you've got latest service pack installed. And lastly: if the problem still persists, contact product support services and report it.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
