Sage 100

 View Only
  • 1.  2018-2021 conversion hang on JC_JobTransactionDetail

    Posted 10-07-2021 06:26
    Anyone had this?  I rebuilt the file in 2018, copied over and started again, but still just sitting there.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------


  • 2.  RE: 2018-2021 conversion hang on JC_JobTransactionDetail

    Posted 01-23-2024 17:02

    Any chance you remember what happened with this one?  I have the same situation going from 2018 to 2023 currently.



    ------------------------------
    Andrea Stull | ACI Consulting
    p 714.282.0378 f 714.282.0235
    andrea@aciconsulting.com
    ------------------------------



  • 3.  RE: 2018-2021 conversion hang on JC_JobTransactionDetail

    Posted 01-24-2024 11:56

    We had a similar issue and found that if you migrated/converted to 2020.0 first, it would successfully complete. 

    For the customers that couldn't use 2020.0 we had to re-initialize the JC_JobTransactionDetail table prior to the conversion (one customer had over 2 million records and I let it run for 45 hours before just giving up).



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 4.  RE: 2018-2021 conversion hang on JC_JobTransactionDetail

    Posted 01-24-2024 12:26

    Thanks for the feedback Steve.  This one has 950K records and is on hour 32 of converting.  I am about to stop it and will try going to 2020 first.  Thanks!



    ------------------------------
    Andrea Stull | ACI Consulting
    p 714.282.0378 f 714.282.0235
    andrea@aciconsulting.com
    ------------------------------