RE: Generic data source extraction using Function module

[former_member215123]

Dear All,

  We have created a generic data source using FM extraction. When we are executing the info package data is coming correct but status of the info package is not changing it is in yellow status only. When we searching in SCN saying that RAISE no_more_data exception has to be used after that also we are facing same issue, please find the below screen shot. Kindly help us to solve this issue.

Thanks in Advance!

 

Exception code:

IF sy-subrc <> 0.

*      CLOSE CURSOR s_cursor.

         RAISE no_more_data.

       ENDIF.

Regards,

Alagappan R.

[Former Member]

What is the status of the extraction job in the source system ?

Thanks

Francis

[former_member215123]

Hi Francis,

  In source system keep on running in yellow status after long time going for canceled status. Then BW Side IP status also changing into red.

 

Regards,

Alagappan R.

[Former Member]

did it complete successfully when you try to run it through RSA3 ?

50,724 is all the records it is supposed to extract ? or is there more to be fetched ? what about other data loads (from other datasources) in this source system ? are they completing ?

could you post the code also ? if its too big, you can post snippets of important pieces like opening of cursor, loops etc.

Thanks

Francis

[former_member215123]

Hi Francis,

  There is no issues in RSA3. It's working fine and no.of entries also matching with ECC table(50724)

All other data loads are working fine in this source system.

We have not used any cursor option. Please find the below code for your reference.

Thanks in Advance!

Regards,

Alagappan .

[Former Member]

Thanks for sharing the code snippets.

The execution will never reach the "Raise NO_MORE_DATA" statement.

Try to put that statement in the end (next to incrementing of the data package counter).

Thanks

Francis