Cube deployment hangs

Hi,

SQL2005 RTM

I work with offline cubes projects. When I change the cube dimensions, it sometimes happen that the deployment hangs. The deployment is set not to process the cube.

Then When I look into the Analysis services service status, I see that it is stopped!

I can sometimes get out of it by restarting the service or if really bad, restart the server, then the deploy works.

What's that?

Philippe

Make sure first you have SP1 installed. It contains some important bug fixes. http://www.microsoft.com/downloads/details.aspx?FamilyID=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en

If you still the problem and you can reliably reproduce it, please contact customer support and report the problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward Melomed wrote:

Make sure first you have SP1 installed. It contains some important bug fixes. http://www.microsoft.com/downloads/details.aspx?FamilyID=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en

If you still the problem and you can reliably reproduce it, please contact customer support and report the problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks, but I will first try on a Guinea Pig Computer because SP1 brings other bugs and I do not want to apply SP1 HotFixes in emergency mode.
I am really really concerned about SP1 I do not dare to install it, it is just too risky. I guess I could not even uninstall it and would have to reformat and rebuild if SP1 screw me-up.
What I really want to do is to wait for SP1a so SP1 bad bugs like Integration services not working will not hit me as a two-one punch.
Philippe

CTE and XQuery

I'ev been playing around with CTE's and trying to query a table that has the following structure

tbl Projects{
id (int),
Project (xml)
}

sample data within the project column is
id = 100
Project =
'<Projects>
<SubProjects>
<id>150</id>
<id>160</id>
<id>170</id>
</SubProjects>
</Projects>'

basically i'm trying to set up a recursive query to get all sub projects for a given project.. this is PART of a bigger query ..

WITH MySubProjects(SubProjects)
AS
(
SELECT TblProjects.*, P.SubProjectIDs.value('(.)[1]','int') AS SubProjects
FROM RB_Projects TblProjects
CROSS APPLY Project.nodes('/Projects/SubProjects/id') AS P(SubProjectIDs)
where id = 100
)

but i keep getting the following error
Incorrect syntax near ')'.

does CTE's not like xquery functions within it's expression?n/m

guess i gotta use the CTE after definine it...

"A CTE must be followed by a single SELECT, INSERT, UPDATE, or DELETE

statement that
references some or all the CTE columns."
http://msdn2.microsoft.com/en-us/library/ms175972.aspx