Skip to main content
Question

Source Data Migration silent errors

  • December 5, 2019
  • 6 replies
  • 336 views

Forum|alt.badge.img+9

I’ve got my source migration job working, but I’m trying to log errors that just show up as unprocessed records. In this case it’s a bad Operation No/ID and you can see in the debugger it can’t find the Objid/Objversion for the routing operation I’m trying to update. Is there a way to flag these rows so the end users can go back and resolve the issue with the source data?

 

 

Thanks,
Lane

Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+19

Normally the migration job logs for errors for each row and stops if there are errors unless you have setup a rule to ignore errors. Do you have such rukes setup in your migration job?

 

Fie example, IGNOREXEERROR will continue procedure on error. The rules are setup in the rules tab. If this rule is activation, disable it so that user will see the errors during execution.


Forum|alt.badge.img+9
  • Hero (Customer)
  • December 5, 2019

I should have put in the original message IGNOREXEERROR is set to inactive and nothing is put into the detail tab of the Execute Job screen. The only clue that there was a problem is that it shows fewer rows where updated than selected.

 


Forum|alt.badge.img+9
  • Hero (Customer)
  • December 5, 2019

I ended up adding a couple more methods to the migration job. The first method calls exist_operation and if it returns a 1 then the second method updates a row status column. 

 

 


JULIAN
Hero
Forum|alt.badge.img+9
  • Hero
  • December 5, 2019

You can normally check out the errors in the execute job menu after execution


Forum|alt.badge.img+9
  • Hero (Customer)
  • December 5, 2019

Unfortunately in this case it doesn’t. I saw the errors you are referring to when I was trying to get the Intface_Table_Migrations_API.Process_Table call working.


JULIAN
Hero
Forum|alt.badge.img+9
  • Hero
  • December 6, 2019

Any difference whether you run migration “online” or select “background”? 


Reply


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