Out of Memory while doing SAP BPC Excel refereshing members (NW)

[former_member1026401]

Hi friends,

I am new to Netweaver, I have a question in SAP BPC and it related to database, so thought of checking with you people.

We are getting an error (about the error - system say out of memory) and when we referred to the messages in the SAP BPC forum, few have provided solution asking to shrink the log file size.

They have also provided the SQL synatx to reduce the log file size.

" dbcc shrinkfile (Appset_Log, 1) " -

But the question is where to go write this and how to proceed and what are all the prerequisites that I should take before and after writing the SQL Syntax dbcc shrinkfile (Appset_Log, 1)

Please can you guide us

Thank you and Kindest regards

Srikaanth

[Sriram2009]

Hi Srikaanth

In a day what is the size of traction log in you MySQL DB? for that everyday once the backup get over you are doing the truncate? if its yes what is the size of after truncate? in my observation disk space very low to run the sap system in drive C & D. When you are getting the error message "out of memory" during that time what is the disk space?

Regards

Sriram

[Sriram2009]

Hi Srikaanth

1. As per your mail Kindly increase the virtual memory to Drive D Free 27.00 GB and Total 79 GB. to 25 GB (25600Mb)

2. remove the virtual memory setting in drive c: (4 GB default at the time of windows 2003 OS installations)

3. As per the SAP Note ZERO Memory Administration-88416

Regards

S

[former_member1026401]

Hi S Sriram

Thanks for the help.

I tried your suggestions, but still problem is not resolved.

I guess I should go for shrinking the file.

Your suggestions if any for shrinking the file

Thank you and Kindest Regards

Srikaanth

[Sriram2009]

Hi Srikaanth

1. As per your mail Kindly increase the virtual memory to Drive D Free 27.00 GB and Total 79 GB.

2. remove the virtual memory setting in drive c:

3. As per the SAP Note ZERO Memory Administration-88416

Regards

S

[Sriram2009]

Hi

As per the Sap Note 1353149 - How to truncate the database log size if it become too large you will able to do the log shrinkfile

1. During the time of your are getting a error message "out of memory" check the disk space, physical memory and virtual memory status?

2. If you are using windows 2003 64 bit Os what is the virtual memory settings ?

Regards

S

[former_member1026401]

Hi Sriram,

Thank you very much for writing

this SAP note says and I quote

"

In an SQL command line interface please execute the following commands:

use backoff

go

exec sp_dbcmptlevel 'backoff', 70

go

BACKUP log backoff with TRUNCATE_ONLY

DBCC SHRINKDATABASE ( backoff, TRUNCATEONLY)

DBCC SHRINKFILE (backoff70_prodData, 1)

DBCC SHRINKFILE (backoff70_prod_log , 1)

BACKUP log backoff with TRUNCATE_ONLY

go

"

question is how should I reach for SQL command line interface

1) Disk space deatils before and after the error

Drive C Free 8.88 GB and total 24.4 GB

Drive D Free 27.00 GB and Total 79 GB

Drive E Free 18 GB and Total 18.5 GB

2) Virtual memory Details

Drive C Initial size 4500 MB and currently allocated 14500 MB

Drive D initial size 10000 MB and currently allocated 14500 MB

Please can you let me, further

Thank you adnkindestRegard

Srikaanth

[former_member1026401]

Hi S Sriram

Diskspace in C is 4 GB and D drive is 4 GB

it was working earlier when we had 4 GB earlier, but not now

Please can you help us

Thank you and Kindest Regards

Srikaanth

[Former Member]

Hello,

to get answers to your problem you should please provide more information:

*What SAP system do you have incl. Version

*What database do you use

*What OS do you use

*Where exactly do you get the error (give exact error message)

If you are sure that your problem is related to the database, maybe it is better to post it in the according database forum.

Regards

Christian

[former_member1026401]

Hi Rose,

Here are the details,

SAP BPC 7.0 Version

DB is Oracle DB

OS - Windows Server 2003

Exact Error message - out of memory (Pop-up screen - no other information available)

Thank you and Kindest regards

Srikaanth