cancel
Showing results for 
Search instead for 
Did you mean: 

How the Generic data source of Type Function Module will pass Msg that Data load is done.

anju_naidu
Participant
0 Kudos
73

Hi Experts,

I have create a function module type generic data source .If i tested it in RSA3 in ECC it is provideing extact reasults.

But when i replicated the same into BW and Performed InfoPackage call then a background job BI_* is created in ECC.


Here is the place i am getting issue.


I have all the data loaded into BW.

Status is still 'YELLOW'.

ECC job is still running and after a some  time it is turned to Red with error SYSTEM_NO_ROLL.


Please let me know how to inform BW that data load is completed .



Note : I am not using Cursor here ( Full Load every time) not and NO_MORE_DATA is also not working.

Thanks & Regards,

Anjan

View Entire Topic
matt
Active Contributor
0 Kudos

What do you mean "NO_MORE_DATA" is not working.  Are you sure it's being raised?

You can set an eternal loop

data x.

while x is initial.

endwhile.

in your extractor. Then launch from BW, and you'll be able to get into debug from SM50 (on your extractor system).

Or you can issue messages that you can see in the log.

Have you checked the details of the dump? Perhaps it tells you what table is getting very big?

anju_naidu
Participant
0 Kudos

I set the below but still not working

If  IF I_INITFLAG = SBIWA_C_FLAG_ON.

IF S_COUNTER_DATAPAKID = 0.

logic

E_T_DATA[] = Internal table.

End if.

   IF SY-SUBRC <> 0.

      RAISE NO_MORE_DATA.

    ENDIF.

   S_COUNTER_DATAPAKID = S_COUNTER_DATAPAKID + 1.

ENDIF.

former_member209032
Active Contributor
0 Kudos

Hi,

  Only when you use cursor and when all data records are selected sy-subrc <> 0. and no_more_data will be raised. It is always advisable to use cursor to handle large amount of data . In your case try to give RAISE no_more_data at the end of your logic when e_t_data is appended.

Regards,

Raghavendra.

matt
Active Contributor
0 Kudos

Given the nesting of your IF statements, NO_DATA is not being raised - the conditions are not being met.

There are many examples of generic extractor, and explanations of how they work. I strongly suggest that you search for them. Thread locked on the grounds that this is basic extractor programming and should be able to be figured out with a little research.