Getting short dumps while reading bulky data from excel sheet

Advertisement

Hi all,
We have converted our non-unicode based sap system (R/3 4.7, Windows 2003,
SQL 2000) into a unicode based system recently. We are facing two peculiar
problems for last few days.
*Problem 1 - *Whenever we want to upload the data from excel sheet, the
system throws a dump after reading about 400 entries, while last week the
same system used to read about 8000 entries in a single go.
*Problem 2 - *Also, whenever we realease a transport requst from development
containing a lot of changes, the request will reach the quality system but
without the changes. but if i ll try to import the changes into quality
system after generating more than one request containing small small
changes, they get reflected in QAS immediately. Is there any size
constraint in transporting a request fro DEV->QAS->PRD.
Please suggest some ways.
I am pasting the dump (that I am getting while data uploading from Excel).
~~~~~~~~~~~~~~~~~~
Runtime errors
MESSAGE_TYPE_X*
Occurred on
22.02.2008 at
13:21:02*
The current application triggered a termination with a short dump.
What happened?
The current application program detected a situation which really
should not occur. Therefore, a termination with a short dump was
triggered on purpose by the key word MESSAGE (type X).
What can you do?
Print out the error message (using the "Print" function)
and make a note of the actions and input that caused the
error.
To resolve the problem, contact your SAP system administrator.
You can use transaction ST22 (ABAP Dump Analysis) to view and administer
termination messages, especially those beyond their normal deletion
date.
Error analysis
Short text of error message:
Control Framework : Error processing control
Technical information about the message:
Diagnosis
An error occurred when the system tried to process the commands
from the Automation Queue on the presentation server.
There are several possible reasons for this:
- The installation of the SAP GUI on the presentation server is
faulty or obsolete.
- There is an error in the application program
- There is an error in the SAPGUI or an integrated control
Procedure
1. Make sure that you have imported the appropriate Support
Package, the current kernel, and GUI patch for the release of your
System
2. Check whether the error occurs locally on one or a few PCs, or
generally on all PCs. Note whether the error only occurs for some
users, for example because of a specific Customizing setting.
If it only occurs locally, this suggests an installation problem
with the PC. Check the installation; if necessary, reinstall the
software. In the dump, search for the SY-MSGLI field, since it may
point to the cause of the error.
3. Activate the Automation Trace (in accordance with SAP Note
158985).
4.Start the transaction and continue until the screen immediately
before the dump.
5. From the System -> Utilities menu, choose Autom. Queue,
Synchronous Processing.
The status bar of the GUI displays the text:
"Automation synchron flush mode on"
6. If you now proceed with the application, the short dump will
display the ABAP call that caused the error; the Automation Trace
will contain the error on the presentation server.
7. If necessary, load the short dump and trace files on to
sapservX, so that SAP can analyze them.
Message classe...... "CNDP"
Number.............. 006
Variable 1.......... " "
Variable 2.......... " "
Variable 3.......... " "
Variable 4.......... " "
Variable 3.......... " "
Variable 4.......... " "
How to correct the error
Probably the only way to eliminate the error is to correct the program.
You may able to find an interim solution to the problem
in the SAP note system. If you have access to the note system yourself,
use the following search criteria:
"MESSAGE_TYPE_X" C
"SAPLOLEA" or "LOLEAU02"
"AC_SYSTEM_FLUSH"
If you cannot solve the problem yourself, please send the
following documents to SAP:
1. A hard copy print describing the problem.
To obtain this, select the "Print" function on the current screen.
2. A suitable hardcopy prinout of the system log.
To obtain this, call the system log with Transaction SM21
and select the "Print" function to print out the relevant
part.
3. If the programs are your own programs or modified SAP programs,
supply the source code.
To do this, you can either use the "PRINT" command in the editor or
print the programs using the report RSINCL00.
4. Details regarding the conditions under which the error occurred
or which actions and input led to the error.
System environment
SAP Release.............. "620"
Application server....... "nhbho930"
Network address.......... "192.168.0.30"
Operating system......... "Windows NT"
Release.................. "5.2"
Hardware type............ "4x Intel 801586"
Character length......... 16 Bits
Pointer length........... 32 Bits
Work process number...... 0
Short dump setting....... "full"
Database server.......... "NHBHO930"
Database type............ "MSSQL"
Database name............ "DEV"
Database owner........... "dev"
Character set............ "C"
SAP kernel............... "640"
Created on............... "Aug 17 2007 00:18:58"
Created in............... "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"
Database version......... "SQL_Server_8.00 "
Patch level.............. "196"
Patch text............... " "
Supported environment....
Database................. "MSSQL 7.00.699 or higher, MSSQL 8.00.194"
SAP database version..... "640"
Operating system......... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2,
Windows NT 6.0"
User, transaction...
Client.............. 300
User................ "NHBABAP"
Language key........ "E"
Transaction......... "SE38 "
Program............. "SAPLOLEA"
Screen.............. "SAPMSDYP 0010"
Screen line......... 0
Information on where terminated
The termination occurred in the ABAP program "SAPLOLEA" in
"AC_SYSTEM_FLUSH".
The main program was "ZBDC_CONTRACT ".
The termination occurred in line 29 of the source code of the (Include)
program "LOLEAU02"
of the source code of program "LOLEAU02" (when calling the editor 290).
~~~~~~~~~~~~~~~~~~~~~
Thank you all.
Cheers.
Mitra __.____._

Advertisement

for the 50 millionth time: Excel spreadsheets are NOT databases, you should NOT try to use them as such and NEVER access them using JDBC.
You should also under NO condition use the JDBC-ODBC bridge driver (that was actually the 78 millionth time that was told someone).

October 11, 2015

Getting short dumps while reading bulky data from excel sheet

Hi all, We have converted our non-unicode based sap system (R/3 4.7, Windows 2003, SQL 2000) into a unicode based system recently. We are facing two peculiar problems for last few days. *Problem 1 - *Whenever we want to upload the data from excel she

Read data from excel sheet and then perform the required operations.

Hi all I need to write a procedure which can read data from excel sheet.I have excel sheet in which i have to options one is modification and other is addition.so if it reads modification then i need to read the concerned table name then check its av

Short dump while displaying cube data in production

Hi Folks, I'm getting a short dump while displaying cube data in production, please suggest Thanks and Regards SanthoshHi Santosh, I'd suggest to follow as per SAP Note: 568768 - Analysis of SQL Errors causing Shortdumps or Error messages. The Note c

Reading the data from excel file which is in application server.

Hi, Iam trying to read the data from excel file which is in application server. I tried using the function module ALSM_EXCEL_TO_INTERNAL_TABLE. But it didn't work. I tried just reading using open data set and read data set it is giving junk character

How to read the data in excel sheet

Dear sir, How to read the data in excel sheet when i recieve a data serial communication... ie i have store a data in excel such that Cell A       Cell B    A           Apple     B           Ball    C           Cat    D           Doll when i recieve

Urgent - Migrate data from Excel sheets

Hello all.. I want to move data from excel sheets into oracle9i Database I have a bout 50 table with average of 5000 row per table How could I do it I will be so obligated if you could detail it for me Thanks in advanceI want to insert data using loa

Short dump while reading a currency field from Flat file into internal tabl

Hi, I am getting a short dump........saying number conversion dump (while reading a currency value into field in internal table from a fixed lenght flat file)......... Do I need to use a string variable to get the value from flat file or how ?? Pleas

Pasting data from Excel sheet to Table in web dynpro View

Hii All, Is it possible to copy data ( some rows) from Excel sheet and paste in table in a view? I tried doing this, but only first element is getting pasted.. Does anybody know how to do this? Is there any way to perform similar thing? Pls help. reg

Short dump while reading Payroll results

we have a Z program to read the payroll results for a quarter(3 months)for a large number of employees. As the internal allocated memory is 2G. This is exceeding that limit resulting in a short dump. There are no big internal tables in the program ex

How to delete the Junk Data From Excel Sheet

Dear ABAPers,             I am uploading the Excel sheet from the Desktop to the SAP System. In the Internal table i am getting Unwanted Junk data's for Example '##########'.I am not getting this Junk data for all the times. i am getting it for Some

Uploading Data From Excel Sheet to SAP Database Tables

Dear Friends, We are having an Excel Sheet with 90 different columns. Now we want only 2 of the columns to be uploaded in the database tables. So, Plz tell me which function module will be suitable for this. And plz help me with the code also. Thanks

Uploading data from Excel sheet into SAP.

Dear All, I want to upload data existing in Excel sheet into SAP. Is there any possibility with the following requirements? 1) Excel file contains serial numbers with different values.Like power(230Wp),Voc,Isc,Vmp and Imp. 2) We need to upload the sa

Problem in loding data from excel sheet

hi , i hav some problem with sqlloader.i m using oracle8i this is my loader.ctl file load data infile 'c:\data\emp.xls'           into table employee fields terminated by "," optionally enclosed by '"'           ( empno, empname, sal, deptn

Short dump while executing info package in 3.5 data flow?

Hi, i am getting short dump while executing info package while executing info package. it was working perfectly 2 days back suddenly it is giving this problem. it is a full load for info object text data and i have only 600 records. when i tried with

Short Dump while activating Transformation through Program

HI All, I am getting short dump while activating - Inactive Transformation through Program RSDG_TRFN_ACTIVATE. However while i can activate single Transformation but if run without selection, I am getting this dump. Short Description of Dump - Catego

Error while importing data from excel to forms

Hi, I am working on Oracle forms 10g, and I'm supposed to import data from excel sheet to forms. While the user enters the data,sometimes after entering a particular word he/she hits the alt+enter button. As a result the data appears in two lines in

Reg transfer of data from excel to internal table

hi i need to upload datas from Excel sheet to Internal Table.For this i use d FM ALSM_EXCEL_TO_INTERNAL_TABLE.but the problem is if a particular field has no value in excel sheet,then its not  uploaded into internal table.then next field value has co

Upload data from excel where one column has text of 3000 characters

Guyz, I have a query. One of my requirments is to upload data from excel sheet & create a material. In the excel sheet one of the columns has text for BASIC DATA TEXT under ADDITIONAL DATA of a Material. This is a text of running length. the selectio

Getting dump while loading master data

Hi, i am gettin dump while loading master data genrated by copa, that gtwa_not_assigned. Best regards, dushyant.hi, see weather that master data contain attribute or not, if not than un check master data field from the master data attribute tab, and

Short dump while doing subtotal in the ALV report

Hi All, I am getting run time error while doing the sub total and total in the ALV . error is "MESSAGE_TYPE_X" and discription is  "The current application program detected a situation which really should not occur. Therefore, a termination