Bex Report error Error when writing in the internal buffer.

[Former Member]

Hi Expert,

I am getting error message "Error when writing in the internal buffer. See OSS note 156957 " while running the report in Bex /Portal. We are using BI7.0 system .

Please suggest if any one face same problem and how this can be solved without applying OSS message.

**********************************************

Diagnosis

You attempted to save the structure for the hierarchy

with HIESID 484 from characteristic 0WBS_ELEMT in the

application buffer (eshared buffer). The application

buffer is configured too small, and this results in the

error 'EXPORT_BUFFER_NO_MEMORY'.

System Response

Procedure

Contact your system administrator.

Procedure for System Administration

Change the profile parameter rsdb/obj/buffersize as

described in SAP Note 156957.

**************************************************************************

Please suggest

Thanks

Lakshmi

[former_member225306]

Hi,

please apply the note 1614788. After note implementation, you need to set parameter RSR_HIER_THRESHOLD_EXPORTDB in table RSADMIN via report SAP_RSADMIN_MAINTAIN in transaction SE38.

If you set this parameter to value 50.000 for example, all hierarchies with more than 50.000 nodes will be buffered in the database instead of using the export/import buffer.

To find out the current size of a hierarchy, goto the hierarchy maintenance in transaction RSH1 and copy the hierarchie ID from the header data. With this key you can goto transaction SE16 and select table RSRHIEDIR_OLAP (Field HIEID is the hierarchy ID).

It should resolved your issue.

Thanks,

Venkat

[Former Member]

Hi Venkat,

Thanks for your quick reply and valuable inputs . I would need further information to get the current size of hierarchy, i do not have authorization to run the RSH1 tcode .Is there any other way to check it ?

thanks ,

lakshmi

[Former Member]

Hi Venkate,

Made the changes in characteristics attribute "Suppress 'Unassigned' Node" in hierarchy maintenance. This solved the issues.

thanks

[former_member225306]

Hi,

Thanks for positive update. If useful plz award the points.

Regards,

Venkat