TSV_TNEW_PAGE_ALLOC_FAILED when start export BSEG data

Advertisement

Dear all,
We need to download contents of database table BSEG into a local file via SAP GUI.
When we start we get TSV_TNEW_PAGE_ALLOC_FAILED.
SAP ECC 6.0 Oracle 10.2.0.2 and HP-UX 11.23
There is physical memory in the system of 50 GB.
SAP Memory      Curr.Use % CurUse[KB] MaxUse[KB]  In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %
                                                                                Roll area            2,50      6.551      6.664     131.072    131.072   IDs           97,06
Page area            0,12        315      1.136      65.536    196.608   Statement     76,00
Extended memory     12,43  2.084.864  2.101.248  16.773.120          0                  0,00
Heap memory                  500.446          0     501.962          0                  0,00
The MaxUse of Extended Memory does not exceed 2.101.248  and we still get
"Memory low. leave the transaction before taking a break!""
Can you please advice what should I tune to prepare the system to get all exports from BSEG for all fiscal years?
there are 10 000 000 in BSEG totaly
Thank you in advance.
Ruzica

Advertisement

This is basically SE16.
That is not the recommended way of doing that - it will
- allocate a LOT of memory on the source system - and that twice: once for reading the data and another time the same amount to fill the export table - and eventually dump (as you see it).
- create lots of traffic on your network
- will consume a lot of memory on the PC you download the data to. The grid is to be built on the client, if you're unlucky, your PC may run out of memory too
SE16 was not designed to "download" huge amounts of data, it's used to display table entries.
I suggest you create a small ABAP doing that, writing the output on the server and then either enable to user to access that file (using e. g. SAMBA) or send it via email.
Markus

October 11, 2015

TSV_TNEW_PAGE_ALLOC_FAILED when start export BSEG data

Dear all, We need to download contents of database table BSEG into a local file via SAP GUI. When we start we get TSV_TNEW_PAGE_ALLOC_FAILED. SAP ECC 6.0 Oracle 10.2.0.2 and HP-UX 11.23 There is physical memory in the system of 50 GB. SAP Memory     

The developer 3 crashed,when i exported the data out xls ,why?

i have been reinstall office and developer 3,but it still no echo. why? thanks.Try to be more definitive when posting. For instance, give the amount of records to be exported. There are several reason SQL Dev got crashed when exporting into XLS file.

Why does biobench freeze sometimes when starting to accuire data?

Sometimes when I try to start logging data it will not display any data and the time axis will not advance. If I hit the "Stop" button, it will stop after a short delay. The only way to get it to work again is to reboot the computer. Any suggest

System Copy:Failure when starting export with SAPINST

We are busy with a Unicode conversion and needs to start the export with sapinst. All pre unicode conversion steps are done, we upgraded from 4.6C to ECC6.0. It is a distrubuted system running on MSSQL. Started the export on the DB server and got the

How to export the data as integer into excel sheet?

Hi All,      I am working on export to excel functionality and using JEXCEL API to create it.  When I export the data to excel sheet, the data are stored in text format in the excel sheet.  If I click on summation button on excel sheet,  it is not su

Not showing year data when we export into infoview

Hi All, We had a issue with Crystal reports .We  created crystal report  through BW query .When we run in local machine it is working fine  . When we exported in the info view one of year column data is not showing  . What could be the reason behind

Error 8 when starting the extracting the program-data load error:status 51

Dear all, <b>I am facing a data exracton problem while extracting data from SAP source system (Development Client 220). </b>The scenario and related setting are as the flowings: A. Setting: We have created 2 source system one for the developme

Bi data upload error:status 51 - error: Error 8 when starting the extr prog

while data load form the source system into thw bw i am getting error in error monitor as under, Extraction (messages): Errors occurred   Error occurred in the data selection Transfer (IDocs and TRFC): Errors occurred Request IDoc : Application docum

When I export photos from Aperture, the pixel dimensions are halved thus losing data.  I have set the export preferences to export at original size, to no avail.  This happens even if I just drag to the desktop and then back, or if I export into my iphoto

When I export photos from Aperture to desktop or iphoto I lose pixels.  The pixel dimensions are halved, despite setting the export preference to export at original size.  Anyone know why or how to correct this?Dragging an Image from Aperture exports

Do I have to use lock when I am reading data from a table

Hi, When i am reading data from a table , do I have to set a lock on that table . Is it necessary for us to set the lock on a table when I am reading data from the table. When I am updating the table , do I have to set a lock on the table ? If yes, t

SYSTEM_NO_ROLL dump when trying to precalculate data with RSRD_BROADCAST_PR

Dear all, At my present customer we are facing a problem when doing a precalculate of data with RSRD_BROADCAST_PROCESSOR. The dump message is: Runtime Errors                                                       SYSTEM_NO_ROLL                     Dat

Error when testing CSV Open data driver

Hi All, <p> I followed all the steps in the 'Using the Open driver sampleu2019 guide and was even able to view my data when right-clicked in the Universe Designer and selected to View Table Data.  However, when I do the data integrity check, I get a

Materialized View with "error in exporting/importing data"

My system is a 10g R2 on AIX (dev). When I impdp a dmp from other box, also 10g R2, in the dump log file, there is an error about the materialized view:ORA-31693: Table data object "BAANDB"."MV_EMPHORA" failed to load/unload and is bei

When I export a AAF file from Protools 9 and Import the file into Logic ProX the drum track is out of sync.  I created the drum loop using NI Maschine.  Has anyone else seem this??

When I export an AAF file/project from Protools 9 using an external drive and import the AAF into Logice Pro X the drum track does not play correctly.  It is out of sync with the rest of the track.  I created the drum loop as a plugin using Native In

2004s Excel Export of Date is incremented by one day

Hi, When I export a report with dates to Excel the dates are incremented by one day.  An OSS search turns up nothing.  Anyone have any idea why this would happen?  We are on 2004s sp10. Thanks, Ken MurrayANyone have any ideas why my report dates woul

Still frames got cropped when I exported to DV, how do I avoid this?

I'm using iMovie HD 5.0.2. Made a film and used alot of still photos of bands with the name of the band zooming in and then a transition between each. In iMovie the photos were perfect but when I exported to my DV several of the photos were cropped.

Export As Data Feed

Hello, I am trying to find a way to add the export as data feed button to my SharePoint list - connection (subcategory).  From my research this is normally done with procedures using "SharePoint Central Administration".  However, I am using the

"General Error" when I export to quicktime movie .mov

I have no idea why all of a sudden FCE4 says "General Error" when I export using quicktime movie... If i use another option like mpeg4 or other it works fine. What could be a problem? I have lots of memory.I made the movie self contained and it

Using Start Point with Date-objects

Hi Expert guys and girls! I use the "Start" point to execute my BAPI "Salesorder GetList" / BAPI_SALESORDER_GETLIST. In order to use this BAPI you have to define 1) Customer Number 2) Sales Org and optionally I checked also 3) Document

When to export a numbers file to csv the minus signs don't work with R

Friends, I have trouble getting the statistic program R to read my exported CSV-files from Numbers. The minus sign doesn't work, R reads it as a factoric input rather than numeric. Does anyone have a tip how to reformat this? JockeWayne, actually, I'