Sage 100

 View Only

  • 1.  Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-05-2023 14:30

    v2022 Standard PU2.  It doesn't matter if it is PO Lines or SO Lines whenever I try to add a UDF to a lines panel I get Error 26 cm_maintgrid, line 0930.  In PO Lines I get  Key = PTOTALSW 1869.  I have tried replacing sy_griddefinition and sy_personalize with generic unmodified files and it didn't help.  Can someone look at the line of code and point me in the right direction?  I have tried this on two different servers and get the same issue.  One server doesn't have antivirus and the other server excludes the mas90 folder.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 10:13
    Doug,
    ???? That program is deep in grid land calling all sorts of objects.?? Error 26 (variable type invalid) is when stmt expects
    numeric info and encounters alpha info.

    Did this work on their system before, or was error introduced in 2022?
    Seems like the 2022 upgrade sometimes resulted in corrupted records.

    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com





  • 3.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 10:19

    Thanks @Lee Graham   It doesn't work on version 2020 either.  They are still live on 2020 and are in the process of moving to 2022.  They just got a new server so I installed 2022 on the new server and migrated the data over the weekend.  I was hoping the upgrade might solve the issue.  At least I have a test server with no users in it for now so I can test it.  I have called Sage twice and they are kicking the can down the road... supposedly escalating the case to someone that knows how to figure this out.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 4.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 10:22

    @Lee Graham   Do you think it is worthwhile rebuilding key files?  I know that this will many times fix an error 26 however I am not sure if the corruption is a system file that is not available for rebuild.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 11:05
    Doug,
    ?????? All the key files for the rebuild utility are company-specific data files.?? Never hurts but wouldn't suspect those files are involved.
    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com



    Original Message


  • 6.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 11:07
    Doug,
    ???????? Rebuild Customizer log on Custom Office Utility menu might possibly help.
    Lee
    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com



    Original Message


  • 7.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 11:20

    If I click debug at the error and break out to a ProvideX prompt should I be able to display the table and key and field of the record causing the error 26?

    Already rebuilt the custom office files several times to no avail. 



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 8.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-06-2023 11:33
    Doug,
    ???????? Sage 100 2022.2 cm_maintgrid Line 930 is:

    0930 LET %cmGRIDOBJ=NEW("SY_GridDefinition_ui",%SYS_SS)
    Suspect a problem in a system file.

    Lee
    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com



    Original Message


  • 9.  RE: Error 26 cm_maintgrid when trying to add a UDF to Any Lines Panel

    Posted 03-15-2023 19:49

    This issue has been resolved.  It was a tough nut to crack, and Brian Reddeman from Sage stuck with it and finally tracked it down to a hosed sy_task file.  

    It's a broken SY_Task, it's pulling some weird task.  I made a new install with the same modules and use the newly minted Sy_Task instead.

     



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



Related Content