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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks for the quick reply Eugene.

To create the update rules I right-clicked on the target ODS and chose 'create update rules'. I have some routines that occur -- or would occur if I could get some data!

Anyway this is the same way I always create update rules. I did this for the target ODS which I filled from an R/3 extractor with no trouble at all.

Thanks again for your ideas and any suggestions.

[Former Member · Accepted solution]

While creating URs for ods2 did you choose ods1 as a datasource?

And you didn't answer how you load ods2?

Best regards,

Eugene

[Former Member · Accepted solution]

Yes, I chose ODS1 as the datasource.

I loaded ODS2 by going to RSA1 --> Infosources, right clicking on ODS1 assigning ODS1 as the datasource and then creating my infopackage, which I loaded from there as a full load.

I also just tried right-clicking on the source ODS and choosing "update into data targets", but that load also resulted in "No data available in the source system."

[Former Member · Accepted solution]

OK,

This message is just information. If you go further, choosing type of update, do you see your ODS2 in the Data targets tab of the scheduler?

Best regards,

Eugene

[Former Member · Accepted solution]

Yes, I have my target ODS selected. Thanks for your help and ideas. I keep thinking I must be missing something but I have gone back over everything I can think of....

[Former Member]

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

[Former Member]

Yes, I did. Now I have tried it both ways: full load, and an init with data as you suggested.

What do you mean about a change log? I have not seen that- where would it be?

Thanks so much for all your suggestions. This is a tough one. Hopefully Monday morning some other people will see this and maybe give some ideas.

[Former Member]

ODS-manage, Content tab. There you'll see buttons for active data and change log.

[Former Member]

ok, found the change log. It has data as well. Still can't see anything in RSA3...

[Former Member]

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

[Former Member]

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

[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?

[Former Member]

Nat,

Try to debug in RSA3.

[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?

[Former Member]

Hi Nat,

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

Best regards,

Eugene

[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?

[Former Member]

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

[Former Member]

Try both test for ODS in RSRV tcode.

[Former Member]

Well I am glad to learn about transaction RSRV.

I ran the two ODS tests on my source ODS. The test "Check How Up-To-Date the Generated Programs of an ODS Object Are" was passed with no problems, but the test "Foreign Key Relationship of Reporting-Relevant ODS Object and SID Table Characteristics" found 3 problems: <i>"The SID values are missing for 4 specifications for characteristic 0NOTIFICATN"</i>, and the same for characteristic <b>0CALDAY </b>and characteristic <b>0PURCH_ORG</b>.

I am wondering if these problems are unrelated to the issue of no data being found. I would expect to see these problems cause errors in my load <u>after it finds records starts loading them</u> (I've seen load errors like that before), but the problem I'm having is that it thinks there is no data in the ODS, even though I can view contents and see all the records.

It seems like I'm missing an obvious step here. RSA 3 shows no records, the load says there is no data, but I can see 900+ records in the ODS. Is there something I'm forgetting to do, or is it possible that the missing SIDs are causing this?

Also, I checked SM21 & SM22 as you suggested and there were no errors for my user ID.

Thanks again for your help!

[Former Member]

I am still unable to get data to load from this ODS, even though I know it has active records. Is there any step that I could be missing for loading from ODS to ODS?

[Former Member]

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

[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...

[Former Member]

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