Hi,
I’ve tried to summarize all whereabouts of our issue just below, if you need any more information on the subject to help us understand it, just ask, we’ll provide it ASAP 😉
Environment : single server
o Intel Xeon DualCore 3.2GHz / RAM 3.5GB
o Windows Server 2003 R3 SP2
o SQL Server 2005 SP2 (9.0.3042)
o BPC 5.0.0.500 (5.1 SP?)
o Excel 2003
o Security
 BPC logons have all full rights on the SQL Server
 BPC logons are all local admins of the server
 The installation logon is inscribed on the Active Directory
BPC Diagnostic : all green
Symptoms (on ApShell):
o Logs from the server (in the administration console, for every operations) are only showed for the first operation done on the session. Next ones are silent, no returns are made in the window and then only the final status is displayed (lately, only “an error has occurred during processing”…).
o Applications can be optimized (full optimization)
o Dimensions can only be processes when not included into applications. Once included into an application, the process fail on the connection to the OLAP database. Sometimes dimensions are well processed despite error messages, sometimes not, we havenÂ’t understand what causes what yet.
o If an application is selected in BPC for Excel, the following error message is returned: “A dimension information file cannot be created … the server is either not started or busy” and then it shows some dimensions that cannot be downloaded, even dimensions that are not part of the selected application.
o Maybe not related: SQL Server time-outs (relational or OLAP, no log to tell the difference) sometimes occur during processes
What we already tried
o Restarting server, several times
o Giving full security rights to all BPC accounts on SQL Server and Windows
o Copying all OsoftTaskÂ… DLL to MSSQL DLL directory
o And every possible manipulation of the application set settings. Not really significant since even the original ApShell is impacted by this issue.
We are running out of option, and if any of you has any lead on what we can do to improve the situation, we will gladly try it!
Thx!