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

[former_member589680]

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

:

[Former Member]

There is any Data selection in info package level

[abdullahqureshi]

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

[former_member589680]

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

[RamanKorrapati]

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

[former_member589680]

1) Yes, Source Side ECC Data showing correctly -

2) Yes , i am proper authorized for extraction !

3)  SM37 - job details

I Run my Job Two times from 11:00 AM , i am still waiting to finish my running profile.

- Thank you

[RamanKorrapati]

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?