on 09-18-2014 7:03 AM
Hi ,
Initially i try loading data from time independent MD object to time dependent MD object.The data load gets failed showing error as 'Data record 1 ('00010000220050E ') : Invalid "to" date '00000000 ' RSDMD 188 ','Data record 1 ('00010000220050E ') : Invalid "from" date '00000000 ' RSDMD 187'
As mapping was not there for 'from date','to date' from the source MD object.
Now source MD object is made as time dependent object and mapping is established between Source and target MD objects.
Where as still data load is getting failed with the same error.
Could anybody please show some light on this issue.
Regards,
J.Sakthikumar
Hi Sakthikumar,
First of all you need to inform to the business, You have some inconsistency records extracting from source. Specify that the dates should be filled and the "date from" should be less than or equal to "date to" field and also inform them that the dates should not be blank.
For time being if you want to load the correct data, then you need to create an error stack DTP and load it to your MD. Download the error stack PSA erroneous data and share it to business.
Regards,
Krishna Chaitanya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
When an IO is made time dependent, the two fileds will be added to it - DateFrom and DateTo. We need to populate these two fields in BW. In your case, these two fileds may be blank from your source. To avoid this, you can set a constant in your transformation while loading the data.
Rgds..
Shambhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What the fields you used for dateto and datefrom?
for which fields you mapped?
Always we need to map the fields/info objects which are same type and length.
So please check and let us know.
Can you share source data and bw data how it looks for one record.
actually date field will have 10 or 8 digit number. then why record showing more then 10digit value.
that means you mapped to some wrong object which have alpha routine.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are the date fields mapped to the infosource? What is the source of your infosource? As everybody is saying you cannot have the date fields blank. Maybe you should create a separate transformation for your historical load where you put DATEFROM as today's date (constant) and DATETO as 31.12.9999.
Regards
For time dependent MD you have to have the date fields filled. You cannot leave them blank. Maybe you can put some constant values for the first time load.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.