cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Dumps while extracting the data source

Former Member
0 Kudos

Hi,

I am having an issue while extracting the data source – 2LIS_03_BF .  After the enhancement , when I am executing RSA3 , with data records up to 10000 , it is fetching records, but with 100000 or more records , it is giving a dump.

Runtime Errors         CONNE_IMPORT_WRONG_COMP_LENG
Exception              CX_SY_IMPORT_MISMATCH_ERROR
Date and Time          15.05.2012 12:25:28

Short text
     Error when attempting to IMPORT object "MC03BF0_TAB".

What happened?
     Error in the ABAP Application Program

     The current ABAP program "SAPLMCEX" had to be terminated because it has
     come across a statement that unfortunately cannot be executed.

What can you do?
     Note down which actions and inputs caused the error.


     To process the problem further, contact you SAP system
     administrator.

     Using Transaction ST22 for ABAP Dump Analysis, you can look
     at and manage termination messages, and you can also
     keep them for a long time.

Error analysis
     An exception occurred that is explained in detail below.
     The exception, which is assigned to class 'CX_SY_IMPORT_MISMATCH_ERROR', was
      not caught in
     procedure "MCEX_BW_LO_API" "(FUNCTION)", nor was it propagated by a RAISING
      clause.
     Since the caller of the procedure could not have anticipated that the
     exception would occur, the current program is terminated.
     The reason for the exception is:
     When importing the object "MC03BF0_TAB", the component 80 in the dataset
     had a different length from the corresponding component of the
     target object in the program "SAPLMCEX".

     The length is 120 in the dataset, but 200 in the program.

Please guide.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

did you empty the delta queues and qRFC befor the enhancement?

I think you have data in the qRFC which is still in the old format (before the enhancement) and the extract structure is already changed.

Is it in your PRD-system?

If not: clear delta queue for the extractor (& SMQ1).

Former Member
0 Kudos

No it is not the PRD..

It is Dev system.

How to clear delta queue for the extractor & SMQ1?

Former Member
0 Kudos

delta queue:

txn RSA7, then select the entry which is called 2LIS_03_BF and click on the garbage can.

SMQ1: select MCEX03 and also click on the garbage can

And also clear the setup tables: txn LBWG, then enter application 03 and execute.

Beware that you are deleting everything in the delta queue, so better check if someone is working on it.

Former Member
0 Kudos

Done everything & checked RSA3 ... It is showing 0.

when I am executing RSA3 , with data records up to 10000 , it is fetching records, but with 100000 or more records , it is giving a dump...Above 10000 it is throwing error..How can it be??

Whether it can be a memory issue?

Former Member
0 Kudos

Well, the fact that RSA3 does not give data is normal as you emptied the setup tables.

Do the following:

start txn OLI1BW in ECC.  This is the transaction to fill the setup tables (tables which are read by RSA3).  Just fill them with some documents and try again in RSA3.

It's not a memory issue, that would be a very different dump.

Former Member
0 Kudos

No result sir..

Tried with SBIW also..

Really cannot understand what the issue is..

Former Member
0 Kudos

did you check the system log & st22?  maybe there are some inconsistencies in the extractor due to the enhancements.

Former Member
0 Kudos

No dumps in ST22 other than this.

Former Member
0 Kudos

SM21 screen page:

SE38               A1  9 Field contents changed: IT_KNA1[1]-YYSTATUS -> Y

SE38               A1  4 > in program ZTEST15_5 , line 0099, event START-OF-SELECTION

YMD04              A1  9 Field contents changed: SY-SUBRC -> 4

YMD04              A1  4 > in program LYRI_ATPU09 , line 0030, event Y_RI_OPEN_STO_PER_

YMD04              A2  3 Goto ABAP Debugger: Source:(67)->(30)   ByteCode:FUNE(12

YMD04              A1  4 > in program LYRI_ATPU09 , line 0030, event Y_RI_OPEN_STO_PER_

YMD04              A1  9 Field contents changed: SY-SUBRC -> 0

YMD04              A1  4 > in program LYRI_ATPU09 , line 0030, event Y_RI_OPEN_STO_PER_

YMD04              A1  9 Field contents changed: LS_REGION-GLOBAL_REGION ->

YMD04              A1  4 > in program LYRI_ATPU09 , line 0033, event Y_RI_OPEN_STO_PER_

YMD04              A1  9 Field contents changed: SY-TABIX -> 10

YMD04              A1  4 > in program LYRI_ATPU09 , line 0034, event Y_RI_OPEN_STO_PER_

YMD04              A1  9 Field contents changed: LS_REGION-BZIRK -> GTR01

YMD04              A1  4 > in program LYRI_ATPU09 , line 0033, event Y_RI_OPEN_STO_PER_

YMD04              AB  0 Run-time error "TSV_ILLEGAL_REFERENCE" occurred

YMD04              AB  1 > Short dump "120515 141557 hpsapsd2 p01_RD2_14 " generated

                   R0  4 Session 004 is not active

SMQ1               Q2  2 User DASGUPTAA is deleting outbound queue MCEX03,NONE

SE37               IC  J DEBUGGING entry of USER PALS created for USER PALS and URL

SE37               IC  J DEBUGGING entry of USER PALS created for USER PALS and URL

LM24               A1  9 Field contents changed: LT_ITM_INS[1]-CHARG -> 9999999

LM24               A1  4 > in program LV51PU03 , line 0149, event HU_PACKING_UPDATE

LM24               A1  9 Field contents changed: LT_ITM_INS[1]-YYCHARG -> Nanda

LM24               A1  4 > in program LV51PU03 , line 0149, event HU_PACKING_UPDATE

YRFREPACK          BZ  E Type conversion for field VEPO~WERKSC ==> N : not permitted

YRFREPACK          AB  0 Run-time error "DBIF_RSQL_INVALID_RSQL" occurred

YRFREPACK          AB  1 > Short dump "120515 144247 hpsapsd2 p01_RD2_14 " generated

                   R0  4 Session 004 is not active

YRFREPACK          BZ  E Type conversion for field VEPO~WERKSC ==> N : not permitted

YRFREPACK          AB  0 Run-time error "DBIF_RSQL_INVALID_RSQL" occurred

YRFREPACK          AB  1 > Short dump "120515 144857 hpsapsd2 p01_RD2_14 " generated

SE11_OLD           A1  9 Field contents changed: CODE -> EDIT

SE11_OLD           A1  4 > in program LSETBF01 , line 0026, event SET_STATUS_VAL

YRFREPACK          A1  9 Field contents changed: IT_KNA1[1]-YYSTATUS -> Y

YRFREPACK          A1  4 > in program YREPACK_F01 , line 0844, event CHECK_ACTIVE_CUSTO

YRFREPACK          A1  9 Field contents changed: IT_KNA1[1]-YYSTATUS -> Y

YRFREPACK          A1  4 > in program YREPACK_F01 , line 0841, event CHECK_ACTIVE_CUSTO

SCC1               BB  1 Buffer TABL reset

SCC1               BB  1 Buffer TABLP reset

Former Member
0 Kudos

and are you sure there is data in the setup table for the 03 application?

Because this should work, enhancement or not.

Former Member
0 Kudos

Yah I am sure..

I have found out 1 SAP note-

SAP Note 328181 - Changes to extraction structures in Customizing Cockpit

But still not able to find a concreate solution.Still the thread is open.

Former Member
0 Kudos

Hi,

For enhancing the logistic data source is any support pack or plug in needs to be installed in R/3 (ECC 6.0)system?

Former Member
0 Kudos

Do we need any plug in PI 2000.2 for enhancing the logistic data source?

I think we do not have this plug in installed.

Former Member
0 Kudos

There is no separate plugin necessary for enhancements.

Former Member
0 Kudos

Hello,

Still my problem exists. I am just writing down the steps which I have followed.Please correct me if i am wrong.

As per our project I need to enhance the LO data source – 2LIS_03_BF with some batch related fields.

So the steps that I have performed:

1) Deleted the set up table (LBWQ) emptied the Delta q (RSA7)

2) Enhanced the structure  MC03BF0 by appending – ZZCHRG ( Append structure) with fields:
   ZZCHRG1
  ZZSTATUS
  ZZCOUNT
ZZFLAG
ZZCHRG2

Save and Activate the Append structure.

3) Saved the data source and unchecked the ‘HIDE’  box for these ZZ fields.

4) Activated the data source .

5) Written the piece of code in the exit - EXIT_SAPLRSAP_001

6) Initialize Set up table through SBIW navigation path (Settings for Application-Specific Data Sources (PI) LogisticsManaging Extract StructuresInitializationFilling in the Setup TableApplication-Specific Setup of Statistical DataInventory Management - Perform Setup)

When I am filling the set up table  with 3 or 4 article documents lesser records are coming up. Triggering RSA3 up to 10,000 Data Records/Call , data is getting extracted.

But with more numbers, it is throwing the dump "CONNE_IMPORT_WRONG_COMP_LENG"

Former Member
0 Kudos

1) Deleted the set up table (LBWQ) emptied the Delta q (RSA7)

LBWQ is not the same as the setup table.  LBWQ is the QRFC.

But this OSS-note gives you detailed instructions on what to do:

328181

Former Member
0 Kudos

Hi,

But how this Note -- 328181 is valid for my system..

I am having ECC 6.0,EHP4.

I have found another note-- 505700 but I am not sure whether I should follow the instructions prescribed in this note.. Please guide me.

Former Member
0 Kudos

It's a consulting note and does not contain corrections.  You should not implement it but read it and check where you went wrong.

Note 505700 is very old and is just describing a 'new' delta method in LBWE.  this has nothing to do with your problem (as filling setup tables and RSA3 is in fact a full load).

Former Member
0 Kudos

So where I went wrong??I think I did it exactly the same way as I used to do it in earlier projects..

I have tried to do what have also suggested but nothing is working right now.

No solution till yet..

Former Member
0 Kudos

So where I went wrong??I think I did it exactly the same way as I used to do it in earlier projects..

I have tried to do what have also suggested but nothing is working right now.

No solution till yet..

Former Member
0 Kudos

I don't know where you went wrong.  I can only give advice.

I believe that there is still data somewhere with the old structure (so before the enhancement).

The OSS note is very clear about this: it will generate exactly the shortdump you describe.

Former Member
0 Kudos

Thanks for all your timely advice..

When I am extracting with 10,000 it is giving data , but more than that it is showing a dump. Why so? Currently I have fill up the set up table with 3 article documents, so having only 6 records in the extractor. This question is still unanswered.