TSV_TNEW_PAGE_ALLOC_FAILED when start export BSEG data
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.
This is basically SE16.
October 11, 2015
View Thread Other 9 Replies on scn.sap.com
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.
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
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.
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
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
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
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
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
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 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
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
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
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
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 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
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
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.
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
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
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
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'