Sage 100

 View Only

  • 1.  Job Cost Upgrade Failure

    Posted 12-12-2020 11:15
    We are getting an error message when upgrading from Sage 2018 - 2020.3

    The following conversion record failed while converting 400:\06.20.01.00:DATA:JC_JobTransactionDetail:000000:000 - Failed to create table JC_JobTransactionDetail: Create Table failed for C:\SJG\MAS90\MAS_400\JC400\JC_JobTransactionDetail\PHYSICAL UPDATE ABORT: JC_JobTransactionDetail - C:\SJG\MAS90\MAS_400\JC400\JC_JobTransactionDetail.M4T is currently open. Cannot update at this time.

    Just migrated this morning, nobody on the system. Sage knowledgebase no help.

    ------------------------------
    Gary Feldman
    President
    I-Business Network, LLC
    Marietta GA
    6786270646 x224
    http://www.i-bn.com/
    ------------------------------


  • 2.  RE: Job Cost Upgrade Failure

    Posted 12-12-2020 11:20
    Have you already tried rebooting? Any hung pvxwin32's?

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: Job Cost Upgrade Failure

    Posted 12-12-2020 11:25
    Copy in the same file from 2018 and convert.

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



  • 4.  RE: Job Cost Upgrade Failure

    Posted 12-12-2020 12:53
    I had multiple failures like that on a 2020 upgrade recently and found it was the rights of the user running the Adv service.  If I ran it in MAS90 mode, the conversion went fine.

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



  • 5.  RE: Job Cost Upgrade Failure

    Posted 12-12-2020 13:49
    Thank you Beth!   That did the trick!

    ------------------------------
    Gary Feldman
    President
    I-Business Network, LLC
    Marietta GA
    6786270646 x224
    http://www.i-bn.com/
    ------------------------------

    Original Message


Related Content