Skip to Content

No Data with load using generic DS on view

Hi experts,

I am trying to do a load using a view in BI 7.0 (via a generic DS).

To test, I did a view on a small DSO, created a generic DS on that view, and tried to load using that DS into a copy of the original DSO. The extractor checker on the DS shows data, but the load pulls no data... puzzled..

thanks,

Darryl

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 05:58 AM

    If rSA3 is showing the data, then there is something wrong in the BW side. You should check the load monitor for exact reason. Looks like an idoc error to me. Please check as follows:

    1) SM37 job log (In source system if load is from R/3 or in BW if its a datamart load) (give request name) and it should give you the details about the request. If its active make sure that the job log is getting updated at frequent intervals.

    Also see if there is any 'sysfail' for any datapacket in SM37.

    2) SM66 get the job details (server name PID etc from SM37) and see in SM66 if the job is running or not. (In source system if load is from R/3 or in BW if its a datamart load). See if its accessing/updating some tables or is not doing anything at all.

    3) RSMO see what is available in details tab. It may be in update rules.

    4) ST22 check if any short dump has occured.(In source system if load is from R/3 or in BW if its a datamart load)

    5) Check in SM58 and BD87 for pending tRFCs and IDOCS.

    Once you identify you can rectify the error.

    If all the records are in PSA you can pull it from the PSA to target. Else you may have to pull it again from source infoprovider.

    If its running and if you are able to see it active in SM66 you can wait for some time to let it finish. You can also try SM50 / SM51 to see what is happening in the system level like reading/inserting tables etc.

    If you feel its active and running you can verify by checking if the number of records has increased in the data tables.

    SM21 - System log can also be helpful.

    Thanks...

    Shambhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 05:54 AM

    Hi Darryl,

    Go to T-Code SM58 in R/3 to check whether any iDocs are stuck there.

    If so, push those iDocs using F6.

    Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 05:58 AM

    Hi,

    Go to RSA3, pull some records. If records are coming then load it till PSA by info package. Go for full extraction.

    Regards,

    Zaheer

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.