cancel
Showing results for 
Search instead for 
Did you mean: 

Invalid 'to Date' 'from Dare' Error - Master data load

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member185177
Contributor
0 Kudos

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.

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Ram,

Kindly find the below error message and Mappings.

Regards,

J.Sakthikumar

dhrubojyoit_saha
Explorer
0 Kudos

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

Former Member
0 Kudos

Hi Ram,

Source to inbound infosource mapping is given below,

Source Data :

Regards,

J.Sakthikumar

Former Member
0 Kudos

Hi All,

The strange thing ia data load is success for MD Attribute, Data load is getting failed only for MD text.

Regards,

J.Sakthikumar

RamanKorrapati
Active Contributor
0 Kudos

Hi,

What's your text data source?

Even thru text data source we load only text/descriptions. 0date and 0dateto will be loaded thru attributes only.

Once we load 0datefrom 0dateto thru attributes then why you need load thru text data source?

is this is new data flow or old one?

Thanks

dhrubojyoit_saha
Explorer
0 Kudos

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.