cancel
Showing results for 
Search instead for 
Did you mean: 

No end of selection message arrived : (FM based Datasource)

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Check the source system connection.....check if it works fine...appears liek the connections is broken...

Regards

Former Member
0 Kudos

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 ,

Former Member
0 Kudos

Did you check if used the template RSAX_BIW_GET_DATA_SIMPLE for create your FM...maybe some parameters or exceptions declares are missing in your FM....

Regards

Former Member
0 Kudos

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

Former Member
0 Kudos

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