Skip to Content

Generic Extraction, PSA ( 0 Records out of 0 ) : Error

Hello Expert,

I did Generic Extraction successfully, from ECC and now

turn to BI Server, Data not Loading in PSA , even i checked with SM37 - Request is showing properly , but in PSA (0 Records out of 0 )

Will you please help me to solve out !

Thank you .


you can find one screen shot below

:

Screenshot_16.png (146.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 03, 2015 at 10:03 AM

    Hi,

    at Source side RSA3 - have you extracted data?

    is it new/fresh system?

    if yes then have you proper authorizations to do the extractions?

    Can you check at ECC SM37 job log details and share if you see any issues.

    But your job still running, wait some more time and share if ita fails.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jatin Chauhan

      from above job screen , select your job and click on log details icon on tool bar.

      See there logs in detailed.

      at ECC, SM58 - can you check it, is there any failure LUWs?

      Other than this load, have you loaded any data from ecc to bw?

  • Jun 03, 2015 at 10:51 AM

    Hi Jatin,

    I think you need to check the code written in generic extraction. Have you used RAISE no_more_data  in the code. Without using it, it will be in endless loop for data extraction due to that PSA will remain yellow. The sample code is below :

         FETCH NEXT CURSOR s_cursor

                    APPENDING CORRESPONDING FIELDS

                    OF TABLE e_t_data

                    PACKAGE SIZE s_s_if-maxsize.

         IF sy-subrc <> 0.

           CLOSE CURSOR s_cursor.

           RAISE no_more_data.

    ENDIF.

    Regards,

    Abdullah

    Add comment
    10|10000 characters needed characters exceeded

    • Sir,

      Thank you for your reply but we didn't use any Programs.

      We extracting fields from tables only after using database view

      Tables listed below :

      1) EBAN

      2) EKKO

      3) MSEG

      4) RSEG

      5) RBKP

      - Regards

  • avatar image
    Former Member
    Jun 03, 2015 at 12:47 PM

    There is any Data selection in info package level

    Add comment
    10|10000 characters needed characters exceeded