BW Generic FM Extractor

[Former Member]

Hello Experts,

We have created generic extractor. and we replicated and load the data into BW.

Total 39 records came into BW but it is in yellow state. if we change manually to green then we can load further.

in the monitor screen we went to details tab.every thing is green but it is showing "Missing Message : Selection completed"

then we went to job overivew in soutce system.it is in canclled state.

Attached are the screens for the reference.

please provide inputs on this

Thanks in Advance

Nagendrascn-2.pngscn-1.png

[former_member186445]

extractor is based on what? table, FM?

you say in your question that the job cancelled in the source system. How can you say that it's working fine in the source system? if a job dumps in a system you have a log. can you please specify the details in this log?

you really need to provide more info if you want help.

[Former Member]

Extractor is based on FM.

This is the error in the source system

Short Text

No more memory available to add rows to an internal table.

What happened?

An attempt was made to add rows to an internal table. There was no memory available for this however.

can you please refer the below screen shot for the job status.

scn-1.png

When i run the particular extractor in RSA3 Transaction in source system i am getting the exact output but the problem is in the bw system.

Please let me know if u need any more information regarding the query.

[former_member186445]

seems that there is an issue in the code of the function module. you put too much lines in an itab. hence the dump. it does not dump in rsa3 as you limit the data there (100 lines, 10 packets or so).

so check the code of your FM, or if you don't get abap, get help from a developer.

[Former Member]

Thank you for the answer. i am an ABAP Developer

The extractor contains only 39 records,So i don't think it is an internal table issue

internal table contains variable memory so no need to define internal table memory based on the records the internal table memory will be increased automatically and i would like to give you an information that by default it is having the data limit of (100 lines and 10 packets ). and i think if their is any problem in the FM code when i run in the RSA3 transaction in source system i would have encounter with an appropriate error, but it is working fine in the source system if you know anything regarding this error please help me with the correct answer.

[former_member186445]

how can you say it is working fine in the source system if the extraction job dumps in the source system? And i would like to give you an information that RSA3 is not an actual extraction, it's mere a test on a limited number of records.

and as additional information, the way you answered made me loose any intrest in this post.

[Former Member]

I apologize if i mean anything wrong.i am trying to give you the complete details of the error .

can you please help me, how to check the extractor in source system wheather it is working fine or not ?

[former_member188080]

The issue may be the missing of the instruction RAISE NO_MORE_DATA in the Function Module.

The Job never finish until it receives the confirmation of NO_MORE_DATA. The datasource finish ok, but the job doesn't know it.

Your extractor is running fine in RSA3 but while loading it might be giving issue.

Thanks and regards

Kiran

[Former Member]

Thank You for the answer

As per your answer i have already declare the exception.

[former_member186445]

what type of extractor is it? and what is the error message in the source system?