Error at deployment time (SSAS 2005)

Hello all,

May be somebody know what does this error mean:

"Error 1 Exception of type 'System.OutOfMemoryException' was thrown. 0 0"

I get it during deployment of cube after small changes I made in cube role.

When I deleted the role to return project to prviouse condition which was working, I still get the same error.

If anybody has any idea - it would be very appreciated.

Thanks

Inna

Hard to say on what is going on. Not clear which component produced an error.

Try connecting to Analysis Server from SQL Profiler and see if you will get the same error from the server.

Can you try and make changes to the role from SQL Managment studio and see if you are getting the same error?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Hello Inna

Could it be possible that Your workstation has not enough memory for the Business Intelligence Studio ? You could also have some trouble in he Control Panel/System/Performance. I recommend a contact with Your System Support.

regards

Matti

|||

Hi Edward,

Thank you for your answer.

From SQL Profiler I didn't see my deployment process - when task failed it doesn't reach server and doesn't apply any changes there.

I tried and made changes to the role from SQL Management studio as you advised and it worked without any errors.

At the same time project stood not up to date and I don't know how to export the changes I made directly on the server to VS to continue development:

I can open Analysis Database in V Studio and make changes directly on the server.

After all I reopened the project, deleted role at all and got the same error.

Every time after reboot - it let me to make and to deploy changes for only one time.

Do you have any idea what could be a problem?

Thanks a lot

Inna

|||

Hello Matti,

Thank you for your reply.

Unfortunately now I have to work directly on the server (Windows Server 2003 Standard x64 edition - 6 GB memory and 1 CPU). BI studio installed there. When I get this error during deployment time – memory doesn’t grow out of 2 GB. So I thought enough is still available.

May be I need to configure BI Studio the way it can raise the memory it needs? - I have no idea if it makes sense.

I didn't notice any degradation in performance on the server at the time I got memory error.

All additional ideas would be much appreciated.

Regards

Inna

|||

Hi Inna again

You seem to have lots of memory.

I have met same error and same behaviour ones with my own Java application in Windows Xp.

In that case I could make the correction by changing in the registry the limit for the space of memory the operating system allocates to that type of applications.

Sorry, but I am not an expert in Windows Server 2003. I expect that there somewhere is a limit for the size of memory the operating system allocates to one task.

This is only a quess, but I hope it would be helpfull.

regards

Matti