Skip to Content
author's profile photo Former Member
Former Member

"No data available in the source system" when loading from ODS to ODS

Hi,

I am loading data from one ODS to another ODS in the same system. I have everything set up and activated. The infopackage has no selection criteria -- just a full update. The load goes with no errors but says there was no data, when I know for a fact the source does have active data. I have replicated datasources, deleted everything and built it again, but it still says "No data available in the source system for this selection".

If I view the active contents of the source ODS I see many records. If I use RSA3 to look at the datasource for this ODS it says there are NO records.

It seems like I'm just missing a critical step. Anyone have any ideas?

Thanks.

Nat

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    Posted on Nov 19, 2005 at 06:06 AM

    Hi Nat,

    How did you determine update rules of the ODS2?

    How did you load it? Right click on ODS1 - update into data targets?

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2005 at 06:45 AM

    When you are in RSA3, which datasource you chose, <ODS1> or 8<ODS1>?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2005 at 06:50 AM

    Try to generate export DS for ods1 and reactivate URs for ods2.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Eugene:

      In RSA3 I enter 8<ods_name>. I have no choice. If I omit the 8 it would not recognize it at all. Using 8<ods_name> it recognizes and runs the extractor, and just returns 0 records

      I have tried Generating Export Datasource and recreating URs, TRs, and anything else I could think of.

      Any other ideas? This is really stumping me...

  • Posted on Nov 19, 2005 at 07:18 AM

    Try both test for ODS in RSRV tcode.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2005 at 07:32 AM

    Nat, just in case, check if you have anything in SM21 and ST22.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 20, 2005 at 04:42 AM

    Hi Nat,

    Have you tried to repair your ODS in RSRV after finding errors? (There is a button at the top).

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Eugene, thanks for hanging in there.

      I repaired all the errors (one at a time -- missing SIDs), reloaded, retested (no errors), replicated datasource + reactivated transfer rules just for good measure (seems like you always have to do that), and STILL rsa3 says "0 data records selected".

      There HAS to be a step or something I am missing here. I tried other ODSs in rsa3 and was able to view data.

      Does anyone have any ideas?

  • Posted on Nov 20, 2005 at 06:59 AM

    Nat,

    Try to debug in RSA3.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Eugene,

      I tried that already but I am not sure what to look for. I found the FM where it searches and finds no records, but it is not clear what's causing it.

      Are you sure there is not a setting or extra step that's required to use an ODS as a datasource?

  • Posted on Nov 20, 2005 at 07:43 AM

    You did already what I can remember.

    I reread your messages and your words about "full upload only" options caught my attention.

    Actually, during first load from ODS there are should be 2 options: full and init. Let's try to do init from the system generated package.

    RSA1, menu option Settings/Display generated objects, choose Show generated ODS objects radiobutton.

    Goto Infosources area, find Datamarts node (or DM, or similar), find your 8ODS1 infosource. Under it and the source system find an init infopackage and execute it with data transfer (Update tab of the scheduler).

    Let us know what you’ll get.

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I tried what you suggested and still got no records. The load was 'successfull' (green light) but is says there were no records.

      In the step-by-step analysis I got a red-light next to "Does selectable data exist in the source system?", and the corresponding diagnosis says

      <b>

      Diagnosis                                                                                
      The data request was a full update.                                                                                
      o   In this case, the corresponding table in the source system does not      
                   contain any data.                                                                                
      o   System response                                                          
                   Info IDoc received with status 8.                                    
                   Procedure                                                                                
      Check the data basis in the source system.    " 

      </b>

      Even before I tried the load, rsa3 showed 0 records.

      Is there a setup table I must fill when the DS is an ODS? I know there is when the source system is an extractor in R/3, but what about an ODS in the same system?

  • Posted on Nov 21, 2005 at 05:18 AM

    Hi Nat,

    There are no special setup tables for ODS load. ODS' tables are used instead.

    What do you see in both, active data table and change log of ODS1?

    Did you perform full load to ODS2, not init?

    Best regards,

    Eugene

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Eugene Khusainov

      PROBLEM SOLVED.

      Finally!

      Our system has a setting that controls which source systems data can be exported to from this instance. This is a new instance (we are implementing an Enterprise Data Warehouse layer below our existing BW layer) and the entry had not yet been made to allow data transfers to my destination soursystems. I got one of our company gurus on the phone and he explained it to me this morning.

      Eugene, big thanks (spacibo) to you for your efforts to help me with this over the weekend. I will award all points to you of course.

      Thanks,

      Nat

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.