Question

Migration 21R1 Error formatting date value 11/16/2022 for CREATION_DATE

  • 16 November 2022
  • 6 replies
  • 170 views
H
Rank

I am trying to migrate Customer_info where the Creation Date is today’s date.  The migration does not like the format:  

1000001 ABAN ABRAHAM PTE LTD 11/16/2022 1000001 CUSTOMER United States of America en
1000041 SEADRILL OFFSHORE AS - EUROPE OPERATIONS 11/16/2022 1000041 CUSTOMER United States of America en
1000342 TURKIYE PETROLLERI A.O. 11/16/2022 1000342 CUSTOMER United States of America en
1000457 TRANSOCEAN DRILLING LTD 11/16/2022 1000457 CUSTOMER United States of America en
             
             
             
             
 

6 replies

M
Rank
Userlevel 4
Badge +10

Hi @HDZSTEPHANIE ,

Could you please give an information which migration tool your are using?

Thanks
Martina

H
Rank

I am using Data Migration, not Data Migration Manager

 

M
Rank
Userlevel 4
Badge +10

Hi @HDZSTEPHANIE ,

I guess you are using two migration jobs. One for loading the data from csv (Procedure = CREATE_TABLE_FROM_FILE) and one for migrating the loaded data into the IFS tables (Procedure = MIGRATE_SOURCE_DATA)

In the first job, where you load your data from the csv file into the temporary IFS table you can define how the date format in your legacy file looks like
E.g. you have a date in your csv  24-12-2022
Then you enter DD-MM-YYYY in the job
when you have 2022/12/24 then you need YYYY/MM/DD

 


 

H
Rank

This is the attribute field prior to unpacking the file:

After unpacking, the attribute field looks like this:

After executing the job, the customer creation date shows as this:

 

M
Rank
Userlevel 4
Badge +10

@HDZSTEPHANIE : are those records updated or inserted? Creation_date is a only insertable. It’s not possible to update the field atferwards when the record is already created.

H
Rank

I am doing an insert/update.  Perhaps that is my problem.

Reply


Terms & ConditionsCookie settings