Skip to main content

Hello Ifs community

I have created migration job to load data in Part Based tab for sales price list page.

Lines are inserted but when i want to deleted or updated it i get this error

And when i try to modify one column of this line insert through migration job i had this error message :

but I have no problem deleting or modifying manually created lines. I only have this problem for lines loaded via data mig job.

This is my migration job source mapping :

 

thank you in advance for your help.

 

 

Regards.

 

 

Hi @ArcElhadC ,

I would suggest to run a quick report to compare a manually created line and a migrated one. So you can search for differences between the data. Maybe a column is not filled or something like this.

BR
Martina

Hi @ArcElhadC ,

I would suggest to run a quick report to compare a manually created line and a migrated one. So you can search for differences between the data. Maybe a column is not filled or something like this.

BR
Martina

hello @Makede  i did the comparaison. Manually created line and Migrated one have same value.

I didn't notice any difference.

Hi @ArcElhadC , which procedure that you have used to insert data to this view? can you share your migration job configurations detail (database information, method list)?

 

Hi @ArcElhadC , which procedure that you have used to insert data to this view? can you share your migration job configurations detail (database information, method list)?

 

Hi @Nirogini Janstin 

I uses this method to

insert data

method list attributes :

database information :

source mapping

 

@ArcElhadC , the procedure is MIGRATE_SOURCE_DATA?

@ArcElhadC , the procedure is MIGRATE_SOURCE_DATA?

Yes, i use the MIGRATE_SOURCE_DATA procedure.

@ArcElhadC 

So issue was that the VALID_FROM_DATE is a key field storing its date as 2024-04-04 00:00 
and when using sysdate, IFS does not complain but it stores the date as 2024-04-04 12:12
 

(note the difference in the hours)


When you delete it tries to fetch the objid/objversion using this  VALID_FROM_DATE and it cannot find any record because there is a mismatch between the dates, so for IFS the object does not exist anymore. 

to solve it you can use this so the date from sysdate is correctly created 

TO_CHAR(TO_DATE(SYSDATE, 'YYYY-MM-DD'),'YYYY-MM-DD') 


and that will work.

@ArcElhadC 

So issue was that the VALID_FROM_DATE is a key field storing its date as 2024-04-04 00:00 
and when using sysdate, IFS does not complain but it stores the date as 2024-04-04 12:12
 

(note the difference in the hours)


When you delete it tries to fetch the objid/objversion using this  VALID_FROM_DATE and it cannot find any record because there is a mismatch between the dates, so for IFS the object does not exist anymore. 

to solve it you can use this so the date from sysdate is correctly created 

TO_CHAR(TO_DATE(SYSDATE, 'YYYY-MM-DD'),'YYYY-MM-DD') 


and that will work.

@kvbe  Thanks for the solution! It's working perfectly.

@ArcElhadC 

So issue was that the VALID_FROM_DATE is a key field storing its date as 2024-04-04 00:00 
and when using sysdate, IFS does not complain but it stores the date as 2024-04-04 12:12
 

(note the difference in the hours)


When you delete it tries to fetch the objid/objversion using this  VALID_FROM_DATE and it cannot find any record because there is a mismatch between the dates, so for IFS the object does not exist anymore. 

to solve it you can use this so the date from sysdate is correctly created 

TO_CHAR(TO_DATE(SYSDATE, 'YYYY-MM-DD'),'YYYY-MM-DD') 


and that will work.

 

Where did you enter this in the migration job? I assume the source mapping, valid_from_date row, but which column?

Do you leave in the sysdate also?

Thank you!

Reply


Terms & ConditionsCookie settings