Hi,

I have a web page where I execute an XML/A script to start to process a cube
("<base cube>"), this cube is linked to another cube ("<Visible cube>").
the process command works fine, the cube is processed correctly.

But, when I click make a connection in management studio to browse the
visible cube, I receive an error. I have to click reconnect a second time to
access my cube.

If I execute the same XML/A script to do the process but from management
studio himself, then everything works fine!
I can create my connection see the new values in the cube without receiving
any error.

so, why processing from the web site cause an error while the exact same
script executed in mngmt studio don't generate this error????

The error is:
Error in the OLAP storage engine: the version of the linked file « measure
group », with the name "<base cube>" as changed.
Restart the operation to solve the problem.
(error translated from a french error message)

"<base cube>" is the name of the processed cube, while I'm refreshing the
connection of the second cube. (the visible cube)

I'm using the XMLAClient API to execute my XML/A Script.

Other tests done:
executing a standard MDX query against my visible cube after I do the web
based process return nothing (no error but no result), reexecuting the query
(without doing anything else) and the result is returned correctly.
executing a query against the <base cube> after the process works fine, only
the cubes where this one is linked generate the error.

any idea of what's appends?

thanks.

Jerome.

ok,, after a lots of tests I have found the reason....

1 of the partitions in the <Base Cube> use the proactive caching feature.
After I have disabled it the web based process is ok and the first
connection to the cube no longer generate no result or errors.

but to be honest, I don't know why processing from the web or from
management studio produce the error or not!!!
if the problem is really linked to the proactive caching, then in the 2
cases I should suffer the first connection access issue.

Does the management studio access do something more when we execute an XML/A
script from his interface?


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote