Hi:
While trying to process my dimension, the process is stuck at Create dimension step. This is the first time I am getting this error. We are using BPC 5.1, no service pack, SQL 2005.
I had to make some changes to my account members, after I tried to remove some members and process the dimension, the processing stops at create dimension sub step. It does not proceed after this step for almost 2 hours and I had to kill my admin task.
I have no data in the system, so I do not know what is taking the process so long.
Some other observation I have made :
1. Process - sqlservr.exe and msmdsrv.exe are consuming extremely high amount memory
2. I wanted to manually process the dimension in sql server management studio, but the server hangs when I try to browse or process the dimension.
3. I tried to repeat the same with appshell, it took more than 30 min to process account dimension without any changes to it and now it is stuck in Validate formula(Account of Finance) step for last 30 min.
I do not think we have done any changes to the sql server side.
Has anyone experienced similar issues before? I fear it might be something in sql server, any recommendations ?
Thanks,
Subramania