Skip to main content
Solved

ERROR - ODP_RESOURCE_NOTFOUND - (ODP_RESOURCE_NOTFOUND Error): Object has already been deleted by another user. Resource not found.

A
Sidekick (Partner)
Forum|alt.badge.img+6

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.

 

 

Best answer by kvbe

@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.

View original
Did this topic help you find an answer to your question?

M
Hero (Employee)
Forum|alt.badge.img+10
  • Makede
  • Hero (Employee)
  • March 26, 2024

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

A
Sidekick (Partner)
Forum|alt.badge.img+6
  • ArcElhadC
  • Sidekick (Partner)
  • March 26, 2024
Makede wrote:

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.

Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5

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)?

 

A
Sidekick (Partner)
Forum|alt.badge.img+6
  • ArcElhadC
  • Sidekick (Partner)
  • March 27, 2024
Nirogini Janstin wrote:

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

 

Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5

@ArcElhadC , the procedure is MIGRATE_SOURCE_DATA?

A
Sidekick (Partner)
Forum|alt.badge.img+6
  • ArcElhadC
  • Sidekick (Partner)
  • March 28, 2024
Nirogini Janstin wrote:

@ArcElhadC , the procedure is MIGRATE_SOURCE_DATA?

Yes, i use the MIGRATE_SOURCE_DATA procedure.

K
Hero (Partner)
Forum|alt.badge.img+10
  • kvbe
  • Hero (Partner)
  • April 4, 2024

@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.

A
1 person likes this
  • A
    ArcElhadC
A
Sidekick (Partner)
Forum|alt.badge.img+6
  • ArcElhadC
  • Sidekick (Partner)
  • April 4, 2024
kvbe wrote:

@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.

PraBrandB
Do Gooder (Partner)
Forum|alt.badge.img+1
  • PraBrandB
  • Do Gooder (Partner)
  • August 12, 2024
kvbe wrote:

@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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings