Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Blank Record in SY_User

  • 1.  Blank Record in SY_User

    Posted 08-29-2022 13:50
    One of my customers is running into a situation where a blank record is being inserted in SY_User. I have not established any patterns to it. It happened when I was at their site a couple of weeks ago and had happened several times before that.

    The Sage 100 activity log doesn't show any changes to SY_User.

    The only users with access to the Sage 100 security menus are their controller and me.

    When it happens, it causes all reports and forms to print blank. For all modules. 

    Sage 100 Advanced 2021 PU2 hosted with Summit.

    Has anyone run into this before?

    Thanks!

    ------------------------------
    John Shaver
    Chief Value Officer
    Axiology
    ------------------------------


  • 2.  RE: Blank Record in SY_User

    Posted 08-29-2022 14:21
    Have there been any imports done on security tables?   Does the SY_Surrogate table last record number match the last record number for SY_User.  The Surrogate needs to be 1 higher if not already.   I would start there.  But that is a weird one. ;)

    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106





  • 3.  RE: Blank Record in SY_User

    Posted 08-29-2022 14:28
    No imports on those tables. 

    SY_User last record number is 56 and SY_Surrogate is showing 59 as the next surrogate number. The difference represents the blank records I've deleted so far.

    Yes, definitely a strange one!

    ------------------------------
    John Shaver
    Chief Value Officer
    Axiology
    ------------------------------

    Original Message


  • 4.  RE: Blank Record in SY_User

    Posted 08-29-2022 14:43
    Any 3rd party mods or special changes to code?  You got my curiousity ticking over here.   :)

    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106



    Original Message


  • 5.  RE: Blank Record in SY_User

    Posted 08-29-2022 14:27
    Any blanks in SY_UserHistory?  (Perhaps it's being copied from there...).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 6.  RE: Blank Record in SY_User

    Posted 08-29-2022 14:43
    That's a good question that Kevin put out there.  And look in UserSecurity, UserSecurityHistory as well

    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106



    Original Message


  • 7.  RE: Blank Record in SY_User

    Posted 08-29-2022 14:47
    Looks like Sage removed SY_UserSecurityHistory so disregard looking for that but SY_UserSecurity is s valid table to check.  Also check SY_UserTableSecurity which appears to be new as well. 

    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106



    Original Message


  • 8.  RE: Blank Record in SY_User

    Posted 08-29-2022 15:11
    @Carmen Cruz and @Kevin Moyes I went ahead and checked all of the SY_Userxxxx tables. No blank records in any of them.​​

    ------------------------------
    John Shaver
    Chief Value Officer
    Axiology
    ------------------------------

    Original Message


  • 9.  RE: Blank Record in SY_User

    Posted 08-29-2022 15:23
    Is this a Vanilla version of Sage or is this modified with add-ons.   What if new files were created?   Did this just start happening?

    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106



    Original Message


  • 10.  RE: Blank Record in SY_User

    Posted 08-29-2022 15:33
    They are using Operations Management but it went live back in November, 2021. This started happening about a month ago.

    No new version upgrades or PUs have been installed.

    ------------------------------
    John Shaver
    Chief Value Officer
    Axiology
    ------------------------------

    Original Message


  • 11.  RE: Blank Record in SY_User

    Posted 08-29-2022 22:57
    Can you get you hands on the security files from a backup from that long ago??

    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106



    Original Message


  • 12.  RE: Blank Record in SY_User

    Posted 08-30-2022 11:22
    Unfortunately, they don't have backups going that far back.

    ------------------------------
    John Shaver
    Chief Value Officer
    Axiology
    ------------------------------

    Original Message


  • 13.  RE: Blank Record in SY_User

    Posted 08-30-2022 13:37

    The only way to fix this is going to be to build the exact same names but they would have to be tied into the correct user keys that is assigned to the user now.   If these are built a few records at a time you can see when and if it goes into disappearing mode.  Since they don't keep long term backups this is going to be quite the chore to try and solve. .


    Carmen Cruz
    Sage Consultant
    carmen.cruz@compudata.com
    215-969-1000 Ext. 279
    www.compudata.com
    Work Smarter... Together 

    CompuData, Inc. • 325 Chestnut St, Ste 700 • Philadelphia • PA • 19106



    Original Message


  • 14.  RE: Blank Record in SY_User

    Posted 08-30-2022 16:49
    It's definitely a strange problem! 

    I'll look into recreating the table manually. 

    @Carmen Cruz and @Kevin Moyes Thanks for the suggestions!​​

    ------------------------------
    John Shaver
    Chief Value Officer
    Axiology
    ------------------------------

    Original Message


Related Content