Project server don't activate mspolapbreakout.dll when processingcubes

A

Alex Granovsky

Hello.

I've made my own breakout library using C# and .NET, registered it in
Project Server computer, but it's not used by Project Server when I
initialize "Process cube". After all I tried using original and Hugues
libraries. Nothing changed... What's wrong in your opinion?

Thanks ahead for answers.
 
H

Hugues Perron

Hi Alex,

The only thing I can see is in that there is a problem in the code. When
that happens, no message is sent and it`s very difficult to fugure out what
is the problem. You probably did some tests to see if the dll worked well,
but were you on the same computer?. Also, check you connection string, I had
some problems with it.

Since you can't debug live, I suggest that you modify your dll to write some
info in a log file after each important line to know which one causes the
problem.

Finally, if the DLL is never used, I guess it's a problem of registration.

Hope this will help

Hugues
 
A

Alex Granovsky

Hello, Hugues
The only thing I can see is in that there is a problem in the code. When
that happens, no message is sent and it`s very difficult to fugure out what
is the problem. You probably did some tests to see if the dll worked well,
but were you on the same computer?. Also, check you connection string, I had
some problems with it.
Click to expand...

I've made tests on the Project Server And OLAP Server computer. I simply
called library function from Excel's VBA. Everything worked fine. It
prooves that mspolapbreakout.dll is successfully registered and it's
functions work ok.
Since you can't debug live, I suggest that you modify your dll to write some
info in a log file after each important line to know which one causes the
problem.
Click to expand...

I've also wrote debug log to a file after each function execution. No
log appears after reprocessing cube.

The question is: do you now how Project Server calls this dll? By what
mean does it find out that it really exists? By COM registration with
name "mspolapbreakout"?
 
J

Jesse Vaught

I'm not sure why this is, but from the MSDN article: "If you are creating
a new dimension, it will not be overwritten when the OLAP cube is rebuilt
using this procedure. However, if you are modifying an existing dimension,
you will have to do this programmatically by using the UserOLAPUpdate
function in the download. Otherwise, the dimension will be overwritten each
time."

I have to try the UserOLAPUpdate function, but have been manually processing
the cube (in analysis services, right-click the database and select "process
the database") in order to get weeks to show up in the analyzer views. If I
rebuild the cube from PWA, I lose the week dimension (because it isn't
really a new dimension but a modification of the "Time" dimension).
According to the quoted statement above the "Time" dimension would get
overwritten since it is not new.

Jesse
 
Top