Sage 100

 View Only
Back to discussions
Expand all | Collapse all

2014 Premium to 2017.6 Premium gone sideways

  • 1.  2014 Premium to 2017.6 Premium gone sideways

    Posted 04-16-2020 18:47
    Doing a 2014 Premium to 2017 Premium upgrade and got some very strange results after the data conversion.  There are several DSD Enhancements involved including InstaDocs.  The 5.40 versions of these were downloaded yesterday.
    After conversion, each of the five companies had only 5 GL tables left in the SQL databases.  All the modules show version 5.40, but conversion logs were created for 6.0 and 6.1, and include references to instadocs tables.  I am attaching a zip of the conversion logs from the main company folder.

    I reran the migration and stopped at that point, and all the tables are there.

    Anyone else seen anything like this?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 2.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-17-2020 07:52
    It would probably help if I actually attached the log files....

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 3.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-17-2020 12:16
    Hate to say it but it is the MODS blowing up the conversion process.   There is no way sage is looking for providex files when your going premium to premium
    If you were to create a vanilla install NO MODS.  Create a backup of the dataset you want to test.  Restore into the new system.  Change the owner of the database to MAS_USERS
    Then go into Sage company maintenance and create the code.  Sage will see it in SQL and ask you if you want to link to that 
    Click OK
    Run conversion


    ------------------------------
    Carmen Cruz
    Senior Specialist, Technical Consultant
    SWK Technologies Inc.
    Carmen.Cruz@SWKTech.com CA
    973-437-3984
    ------------------------------



  • 4.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-17-2020 12:23
    On the providex upgrades I have done, DSD recommends installing DSD enhancements, do migration and then do the DSD installs again. Then do the data conversions. Not sure if relevant for Premium.

    ------------------------------
    Joe Uhl
    Eide Bailly, Inc.
    ------------------------------



  • 5.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-17-2020 12:32
    I had done the DSD installs, migrated, then reinstalled the DSD mods (received a prompt when in Company Maintenance).  I will contact them.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 6.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-17-2020 17:59
    It was the GLDE installer, which set the flag in GL_Options to ProvideX, and unfortunately that is the ONLY place the Sage conversion program looks.  And for some reason the conversion program doesn't think that deleting all the tables is something it ought to warn you about....
    Fortunately it is a DSD fix and not a Sage fix and I will have an updated installer by the end of the day.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 7.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 11:00
    Can anyone tell me where the flag for SQL vs ProvideX is?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 8.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 11:05
    Edited by Jim Woodhead 04-20-2020 11:13
    It's accessed the data dictionary
    "dd” command via syzcon

    Jim
    Sent from my iPhone. Please excuse any typos. 


    ------Original Message------

    Can anyone tell me where the flag for SQL vs ProvideX is?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------


  • 9.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 12:59
    Is that the SQL: Create in MAS_SYSTEM DB flag in Dictionary Custom Info tab?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 10.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 11:14
    When I needed that one time, I don't think I saw it anywhere in data, so I had to use a script (oSession.Edition)

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

    Original Message


  • 11.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 11:17
    I need to be able to find it to set it back to Premium

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 12.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 12:56
    See my e-mail for more info on Jim's comment.

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 13.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-20-2020 13:01
    dd, GL_Options, Custom info, SQL flag
    got it done

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 14.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-22-2020 11:05

    The need to reinstall DSD (or any other mods) after migration does not change with Premium.   The migration can overwrite some of the settings and reinstalling ensures that they are correct..   Taken years of getting hit over the head lessons regarding this..

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    On the providex upgrades I have done, DSD recommends installing DSD enhancements, do migration and then do the DSD installs again. Then do the data conversions. Not sure if relevant for Premium.

    ------------------------------
    Joe Uhl
    Eide Bailly, Inc.
    ------------------------------


  • 15.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-22-2020 11:32
    ​yes, all levels (Standard, Advanced and Premium); always Install, Migrate, Install Again, then Convert.  And follow same process when converting for Go Live after they finish their testing.

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 16.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-22-2020 11:51
    I had done the reinstall - the issue was a bug in the GLDE installer that unchecked the SQL flag for GL_Options, which is the one table Sage update code looks at to determine PVX vs SQL

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


  • 17.  RE: 2014 Premium to 2017.6 Premium gone sideways

    Posted 04-22-2020 12:07
    Here is how to look at it:
    File > Run > SYZCON > DD, locate the file (GL_Options).  Thenclick  "Custom Info", you should see  the row for "SQL Create Table" .

    Check the box  and update the file.

     


    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------

    Original Message


Related Content