on 05-05-2009 10:21 AM
Hi Experts ,
I created a datasource based on a function module ,
when I extract data the data is transferred in the BW but the status is not set to green ,
no end of selection message comes from the source system and ALE is identical in both systems ,
so the status of the extraction request is never set to green automatically ,
any one knows if there is any thing to add in the FM or any other setting ,
thanx,
Check the source system connection.....check if it works fine...appears liek the connections is broken...
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi all,
thank for both of you for your help
actualy during debugging I foun that the NO_MORE_DATA exception is not being executed ,,
and i checked the RFCs and it was all ok
i'm working on to find the reason why NO_MORE_DATA exception is not executed i think this is the key for the solution
thanx ,
Hi,
You have FM, which is written well. But when you specify Maximum Package size and open curser to fill that package, it puts data as per the size. Rest of the data goes to next package and so on...once you reach at the end...i.e. sy-subrc not equal to 0 then you know it is the time to raise exception "No More Data".
Check your code for this section...
FETCH NEXT CURSOR G_CURSOR
APPENDING CORRESPONDING FIELDS
OF TABLE E_T_DATA
PACKAGE SIZE L_MAXSIZE.
IF SY-SUBRC <> 0.
CLOSE CURSOR G_CURSOR.
RAISE NO_MORE_DATA.
Have a look at the sample FM for datasources and you may get some clue.
Hope it helps...
Regards,
Ashish
Hi,
have u raised the exception "no more data' in your datasource. When you curse returns sy-subrc other then 0, you should close curser and raise NO_MORE_DATA exception.
check the code, use RSA3 debug mode.
Hope this helps...
Regards,
Ashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.