Sage 100

 View Only

  • 1.  2018 to 2020.1 conversion

    Posted 10-30-2020 18:07
    Edited by Beth Bowers 10-30-2020 18:18
    Job Cost - keeps crapping out on the JC_JobTransactionDetail file - detail in Activity log says CREATE TABLE failed - file is currently open. Cannot update at this time.  WTH?

    UPDATE - nevermind, Run as Admin worked
    ANOTHER UPDATE - It worked on one company, not on another

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


  • 2.  RE: 2018 to 2020.1 conversion

    Posted 10-30-2020 19:32
    Hi Beth
    Had this exact same thing last week.  I had done a 2017 to 2019 6 mos ago for same customer and didn't have this happen.  They were still in test and I decided to take them to 2020 (from 2017, basically redo the test upgrade) and now getting it.  I'm thinking I put on PU1, but would have to look.  I ended up taking the 2019 copy of the same file and putting into my 2020 and conversion complete successfully.   So maybe try the v2018 file and put into your 2020.  A case should probably be opened now that 2 of us received the same error.

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: 2018 to 2020.1 conversion

    Posted 10-31-2020 10:49
    @Nancy Hanson - that's exactly what I had decided last night I will try.  Hopefully it works out - at this moment, one company converted FINALLY, and the other (plus a copy of the other, which I don't really care about) are still being poopy.  ​

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

    Original Message


  • 4.  RE: 2018 to 2020.1 conversion

    Posted 10-31-2020 06:56
    There’s also a JC hot fix for something JC ( didn’t match this error ) I saw in Sage City. Might be worth installing.

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 5.  RE: 2018 to 2020.1 conversion

    Posted 10-31-2020 11:01
    WHAT in the ever-lovin' - this morning I went in and restarted the conversion on that company one more time and it didn't even MENTION the JC file - it pretty much went straight to views and finished up with no errors.

    I GIVE.

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

    Original Message


Related Content