I have written the VB program to procss OLAP

the vb program is auto runned at 3:00A.M (Scheduled Tasks)
the vb program will read ini first to decide which dimensions and cube
are pending to process


1) process all dimensions of a club first
2) then, process the cube

the vb program ran 3 times, the result (steps errors will be logged) are
the same :
1) 4 cubes are process fail, the error code is -2147221411
2) there coressponding dimensions are process without error
3) the cube is not updated

the type of dimensions is shared


Process cube function:
========================
'***Connect to the Analysis Server
dsoServer.Connect G_OLAP_SERVER_NAME

Set dsoDB = dsoServer.MDStores.Item G_OLAP_DATABASE_NAME)
Set dsoCube = dsoDB.MDStores.Item(strCubeName)

dsoCube.Process

'***Clean-up
dsoServer.CloseServer
Set dsoServer = Nothing

Set dsoDB = Nothing
Set dsoCube = Nothing



process dimension function:
===========================
'***Connect to the Analysis Server
dsoServer.Connect G_OLAP_SERVER_NAME

Set dsoDB = dsoServer.MDStores.ItemG_OLAP_DATABASE_NAME)
Set dsoDbDim = dsoDB.Dimensions.Item(strDimension)

dsoDbDim.Process

'***Clean-up
dsoServer.CloseServer
Set dsoServer = Nothing

Set dsoDB = Nothing
Set dsoDbDim = Nothing



http://support.microsoft.com/default...b;en-us;297248
FIX: Server Shutdown When Processing a Cube with Private, Virtual, and
Shared Dimensions

However , I checked the version of Service Pack is 3.
is another problems cause this error?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Annie,

Thanks for your post. Based on your description, I am not sure what the
problem is on your side. I would like you to provide more information so
that I can narrow down this issue.

1. Please provide the exact and detailed error message.
2. How do your verify the version of Analysis Services on your side?
Generally, we check the version of the file msmdsrv.exe to verify the
version of Analysis Services.
3. Could you describe what you mean by the "corresponding dimensions are
process without error and the cube is not updated"? How many cubes do you
process and when does the error occur? Can you describe process of the
error occurring in detail?
4. Can you process the cube using Analysis Manager? Does the same error
occur?

You need to get the Processing log that shows the processing errors. If you
are using Analysis Services 2000 and you are processing the cube from
Analysis Manager, you can capture the log processing messages to a file by:
Open Analysis Manager -> Right click on the server name -> Select
Properties ->select Logging tab -> Enable Processing log setting and enter
a valid file path/name.

Please send it to me at v-yshao (AT) microsoft (DOT) com.

I am standing by for your response.

Thank you,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.