Home > Archive > MS SQL Server OLAP > April 2005 > Dimension.Process(processRefreshData) give a dump in OLAP Database









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Dimension.Process(processRefreshData) give a dump in OLAP Database
Andrea Temporin

2005-04-21, 7:23 am

We're trying to do the IncrementalUpdate of Analysis Services by code using
the DSO object (ADOMD components not ADOMD.NET).
The problem is that occasionally this causes an internal error of the
Database.
The code is like that:

DSODatabase.BeginTrans()
DSODimension.Process(DSO.ProcessTypes.processRefreshData)

For Each dsocube As DSO.MDStore In DSODatabase.MDStores
If dsocube.Dimensions.Find(.Name) Then
dsocube.Process(DSO.ProcessTypes. processFullReaggrega
te)
End If
Next

DSODatabase.CommitTrans()

DSODimension.Update()
DSODatabase.Update()

It seems to me ut is conformant with what micorsoft says in
http://support.microsoft.com/default.aspx/kb/325289

Some one can give me some help and example?
Thank You All
Andrea



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com