JT to PM conversion doesn't restart after conversion error?

SOLVED

Premium 2020 - 2023 upgrade, including PM (test migration for now).

Migrated and converted v2020 to v2021.  Then migrated from v2021 to v2023, and there was a conversion error in one of the JT tables.

Wonderful, bad data in one of the tables.  I remove what I think is the bad data, and try to restart the conversion... but it skips past the JT to PM conversion.

Company maintenance clearly shows the PM module sitting at version 7.00, but it won't convert.

Is there a way to kick-start this JT to PM conversion without redoing the entire company code?  It took about 4 hours of conversion before the error occurred, and I'd rather not wait through that 4hrs multiple times (because I am not sure I removed the offending bad data).

JT SQL tables are still in place, and there are a bunch of PM M4T's, but no PM tables in SQL yet.

Edit:

For anyone at Sage reading this, I just created ticket 8009721472.

  • +1
    verified answer

    Hi Kevin,

    Unfortunately, there is no conversion restart. There isn't a clean way to handle this and still ensure data integrity for the converted data.

    This is something we need to look at because if the conversion had stopped when it encountered error 41, it should have allowed a restart.

    Thank you,

    Kent

  • 0 in reply to Kent Mackall

    Thanks Kent.  I was expecting things to pick up where it left off, which is how things work for conversion errors in normal Sage modules, but I understand this is a special case.

    I'll reset and restart (with fingers and toes crossed).

  • 0 in reply to Kevin M

    Update:

    I was lucky, guessing correctly, and the data I removed allowed the conversion to run to completion on the first retry.  (Re-copy the MAS_### database and folder, manually... company maintenance showed the wrong module versions, but did go through the 4hr conversion when I clicked Convert).

    If anyone comes looking for an answer to the Error 41...

    This customer imports WT's from spreadsheets, and sometimes forgets to save as CSV first... causing some weird data to get into the JT_WorkTicketHistoryHeader table.  I just removed the extra rows (that had no linked data) before running the v2023 conversion.

  • 0 in reply to Kevin M

    Kevin,

    Thanks for posting back that the conversion completed and what the issue was.  As I said, this is something we will be looking into.

    Kent

  • 0 in reply to Kent Mackall

    Thanks Kent.  Conversion errors with bad data will happen sometimes.  Being able to continue the JT to PM conversion where it left off would likely be helpful for other upgrades in the future.