error out of memory in SAP BPC NW 7.version (Oracle)

[former_member1026401]

Hi friends,

I am new to Database, I have a question in SAP BPC Netweaver (version 7.0) and i do not know whether it is related to 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)

Other Information:

System : SAP BPC 7.0 Version (Net Weaver Version)

DB : 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

[markus_doehr2]

> 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) " -

This is for Microsoft SQL Server, not for Oracle.

If you get "out of memory" it's not a database logfile problem but a memory problem.

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

When is this happening?

And do not post the same question in different forums:

Markus

[former_member1026401]

Hi Markus,

Thanks for reply

This is happening, when I refresh the Dimension members in BPC Excel

Thank you and Kindest regards

Srikaanth

[markus_doehr2]

> This is happening, when I refresh the Dimension members in BPC Excel

So this error message is coming from Excel or from the SAP system?

Markus

[former_member1026401]

Hi Markus

this message is coming from SAP

Thanks for continuous Support

Srikaanth

[markus_doehr2]

> this message is coming from SAP

You have any error in the SAP system? SM21? ST22? workprocess traces?

Markus

[former_member1026401]

Hi Markus,

weI cannot check in SAP BPC, by entering transaction code SM21 or transaction code ST22

If you advise me the place to look for errors in SAP BPC, I will check.

I do not have any idea about workproces traces also , I am sorry

Many have recommended in SAP BPC Forum, to write a SQL syntax,which will shrink the file and space will be emptied after the syntax (what they have not mentioned is process to write out the SQL query). I do not know where to write this query.

Thank you Thank you

regards

Srikaanth

[markus_doehr2]

> Many have recommended in SAP BPC Forum, to write a SQL syntax,which will shrink the file and space will be emptied after the syntax (what they have not mentioned is process to write out the SQL query). I do not know where to write this query.

Check the following notes:

1500668 - Out of memory in BPC excel

1517673 - BPC Error message: Exception of type System.OutOfMemory Exception was thrown.

If that doesn't help I suggest you open an OSS call in component EPM-BPC and let the support have a look on the system.

Markus

[former_member1026401]

Hi Markus,

SAP Note 15000668 says that, let me quote

"In BPC for Excel go to etools then select client options and clear client side cache/files this will clear up any registry keys and my documents."

I have the following options in etools (excel)

etools >>> Client Options >>> Refresh Dimension members.

but as per SAP Note we are not getting " Clear client side Cache" after etools >> Client Options

we are using SAP BPC 7.0

Thank you and Kindest Regards

Srikaanth

[former_member1026401]

Hi Markus, any other suggestions please

[markus_doehr2]

As I said before, open an OSS call and ask the support for an idea, I'M out of luck here.

Markus