on 2005 Sep 15 11:44 AM
Hi
One of my ODS is getting uploaded from 2 infosurce.
But i see that ODS is getting uploaded from 1 infosource successfully but there is no data pulled from other infosource. upload finishes successfully with out giving any error mesg, but still it doesnt pull any data. No data is pulled to PSA also.
So how can i check why is it not pulling up the data.
Regards,
Rohini
Hi Rohini,
Seems strange. Perhaps you can retry the load for the line item and see what happens.
<i>i wanted to know how does data mingled in the data target in the ODS when loaded from 2 infopackage?</i>
If the update rules is set to overwrite(default) then for the same set of key fields the second infopackage data will overwrite the key figures already existing in the ODS. If some of the key figures were not loaded by the header data then the line item data would be filled for that.
One suggestion - In normal BW systems you would find 2 ODS in a case similar to yours - One for header data and one for line item. But thats the not case of the problem for data not being uploaded.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi rohini,
If you have already checked the data in RSA3 and the data is there i suggest you to check one thing.Use LBWQ transaction and in the screen that opens please check for the status.If the status is "nosend" then from the menu select the option "Reset Status".
venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rohini,
So, do you use a generic DS? Did you create a generic delta?
Have you ever load delta through this DS?
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eugene,
I have the same scenario in COPA and using generic datasource with timestamp.I have created records in R3 and trying to test my delta. But it is giving me the following in status tab "Info IDoc received with status 8". The processing is red and it does not drop down. This is bit urgent so your help is greatly appreciated.
regards,
Kal
Hi Rohini,
Just check if any of the previous loads ended in errors and hence the system is not picking the deltas.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohini,
It seems like there is no changed records in the source system hence no data was updated. Did you do a RSA3 check for the delta load.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohini,
There are few things to be checked:
1. Check the RFC connection for the source system in sm59.
2. Go to RSA1 -> source system -> Check.
3. Check whether you have authorization to pull the data.
4. Check for any short dumps on the source system.
Bye
Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Siggi - I can see data in rsa3.
Dinesh -
1. SM59 connection if fine. Because all other load is runing perfectly fine.
2. No porlbme with auhtorization.
3. No short dumps.
Let me put my question in the post.
I got 1 ODS which gets loaded from 2 infopackage. 1 package loads header level data and other loads line item data. So here data is geting uploaded for header details, but i dont see any data for line item level. And i see green light for the line item load. That means no error mesg, no dumps.
I hope iam clear with my question.
Any idea on this?
Regards,
Rohini
And one more thing i wanted to know how does data mingled in the data target in the ODS when loaded from 2 infopackage?
Hi Rohini,
It's not a fact that if in managing ODS screen you have green light for a load request you have no messages or errors in monitor.
Look at the detailed tab of the monitor. At least make sure that all processes are finished successfully.
But I'm almost sure that you'll find there some messages which will help us to understand where the problem resides.
Best regards,
Eugene
Hi Eugene
I dont any details under that.
This is the detail i can see in status tab in monitor.
<i>No new data since the last delta update
Diagnosis
The data request was a delta update, meaning, the data basis in the
source system has not changed since the last update.
System response
Info IDoc received with status 8.
Procedure
Check the data basis in the source system.</i>
Regards,
Rohini
Hi Rohini,
Your initial question has been answered by many of them.I do have the same thing to say,but for the last question of how data is stored when you mingle it from two infosurces is ,the records are appended if the selection keys or primary keys are different, but if the primary keys are the same then it overwrites.
There isnt much problem here when you upload from two different infosources.The data integrity is maintained based on the design.
Hi Rohini,
I think you need to check your source system for the second datasource. Are there relevant data to extract? Are there any errors documented in the syslog or the joblog? Do you have a wrong selection in your infopackage?
regards
Siggi
PS: what are the ds you are working with?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohini,
Do you have active update rules for the second infosource?
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.