I'm receiving the following error when attempting to process some objects
(dimensions) in parallel.

It works fine on the dev box, however on production it isn't. Processing
serially works fine.

Ideas?



Executed as user: ADMIN\svc_db. ...n: The request transaction was not
validated. The server is terminating the request unsuccessfully.The request
transaction was not validated. The server is terminating the request
unsuccessfully.Execution of the managed stored procedure
ProcessMeasureGroupProd failed with the following error: Exception has been
thrown by the target of an
invocation.Microsoft::AnalysisServices::AdomdServe r::AdomdException. at
Microsoft.AnalysisServices.Xmla.XmlaClient.CheckFo rSoapFault(XmlReader
reader, XmlaResult xmlaResult, Boolean throwIfError) at
Microsoft.AnalysisServices.Xmla.XmlaClient.CheckFo rError(XmlReader reader,
XmlaResult xmlaResult, Boolean throwIfError) at
Microsoft.AnalysisServices.Xmla.XmlaClient.SendMes sage(Boolean
endReceivalIfException, Boolean readSession, Boolean
readNamespaceCompatibility) at
Microsoft.AnalysisServices.Xmla.XmlaClient.SendMes sageAndReturnResult(String&
result, Boolean skipResult) at Microsoft.AnalysisServices.Xmla.XmlaCl.
The step failed.



The code:


Public Sub ProcessAllDimensionsParallel()

Dim oDimension As CubeDimension

Dim Results As XmlaResultCollection

Dim Result As XmlaResult

Dim Message As XmlaMessage

Dim BeginTime As DateTime = Now

Dim EndTime As DateTime

Dim Errors As Integer = 0

Dim sSQLQuery As String



'Start capture mode

objServer.CaptureXml = True

'Capture XML

For Each oDimension In objCube.Dimensions

oDimension.Dimension.Process(ProcessType.ProcessUp date)

InsertCubeProcessingLog("Process Dimension All Executing...", 0, 0,
BeginTime, "12/31/9999", objDatabase.Name, "", oDimension.Name, "Dimension",
"", "", "", "", "")

Next oDimension

'Exit capture mode

objServer.CaptureXml = False

Results = objServer.ExecuteCaptureLog(True, True)

EndTime = Now

'Log the errors and warnings

For Each Result In Results

For Each Message In Result.Messages

If Message.GetType.Name = "XmlaError" Then

InsertCubeProcessingLog(Message.GetType.Name + ": " + Message.Description,
0, 0, BeginTime, EndTime, objDatabase.Name, "", "", "Dimension", "", "", "",
"", "")

Errors = Errors + 1

Else

InsertCubeProcessingLog(Message.GetType.Name + ": " + Message.Description,
0, 0, BeginTime, EndTime, objDatabase.Name, "", "", "Dimension", "", "", "",
"", "")

End If

Next Message

Next Result

'Update the cubeprocessinglog table

If Errors = 0 Then

sSQLQuery = "set EventDescription = 'Process Dimension All', issuccess = 1,
recordactive = 1, eventendtime = '" & EndTime & "' where eventdescription =
'Process Dimension All Executing...' and eventendtime = '12/31/9999' and
eventstarttime = '" & BeginTime & "'"

UpdateCubeProcessingLog(sSQLQuery)

Else

sSQLQuery = "set EventDescription = 'Process Dimension All Failed',
issuccess = 0, recordactive = 0, eventendtime = '" & EndTime & "' where
eventdescription = 'Process Dimension All Executing...' and eventendtime =
'12/31/9999' and eventstarttime = '" & BeginTime & "'"

UpdateCubeProcessingLog(sSQLQuery)

strKeepProcessing = "False"

End If

End Sub

do you use a custom AS stored procedure?
I receive the error when I'm using a custom code, specially in the calculate
statement.
I have not tested after SP1 and I have changed my cube to not use anymore my
SP.

and also, I have not tested all the possible configurations around my SP

if you don't use an SP, then I don't know what's appends :-)

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

yea...custom sproc


"Jeje" <willgart (AT) hotmail (DOT) com> wrote