Sage 100

 View Only

  • 1.  Printing Activity Log hosed the system.

    Posted 11-22-2023 10:12

    Client is on Sage100 Premium 2022 SU3.

    We were looking for the history of when a user logged in, which the system activity log filter is great for, 

    and they took a screen-shot.   Then they asked for a report (PDF) and when we clicked the print icon, all hell broke loose.

    A pvxwin32.exe task on the server went to 100% (of one of the processors) and nothing worked from that point onward.

    As soon as we stopped and started the service again, it happened again.

    So with the service off, we renamed SY_Console, SY_workstation and the files for the apphost....

    And it seemed to run again and seemed okay.

    Question: - has anyone seen printing the activity log trigger an event like this ?

    It was 100% related, but we are not trying it again, they are living with a screen-shot of the info the screen provided without error.

    Happy Thanksgiving to all 90minders

    JF



    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------


  • 2.  RE: Printing Activity Log hosed the system.

    Posted 11-22-2023 10:21

    I remember having serious issues with the old activity log, but not with v2022.

    Premium, just do a direct SQL query of SY_ActivityLog in MAS_System.

    select *,

    CAST(DATEADD(MILLISECOND, convert(float, LogTime) * 60*60*1000, 0) AS time) as ConvertedLogTime

    from SY_ActivityLog



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



  • 3.  RE: Printing Activity Log hosed the system.

    Posted 11-22-2023 10:22

    Jeff,

    I have seen the activity log hang, but not in recent versions.  In older versions, if the activity log was huge, I would use Crystal and ODBC to pull the data I needed.

     

    Side note: If the Activity log is HUGE and you don't need all the history, you can rename the file SY_ActivityLog.M4t when all users are out and service is not running. It will recreate itself on the next user login.

     

     

     

    Year-end is quickly approaching.  Be sure to attend our Sage 100 Year-End Tips Live Webcast: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    A black background with white text Description automatically generated

     






  • 4.  RE: Printing Activity Log hosed the system.

    Posted 11-22-2023 10:24

    Thanks - on a premium system is this an M4T file, or a database table ? 

    (I'm not connected to their system anymore)



    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------

    Original Message


  • 5.  RE: Printing Activity Log hosed the system.

    Posted 11-22-2023 10:25

    SQL table for Premium, absolutely.  If there is an M4T, that would be a problem.



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

    Original Message


  • 6.  RE: Printing Activity Log hosed the system.

    Posted 11-22-2023 10:33

    If it's a virtual machine, check and see how many cores are allocated.  If it is only one core then a report that takes a long time to run will consume 100% of the CPU time, effectively locking up all other processes.



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



  • 7.  RE: Printing Activity Log hosed the system.

    Posted 11-22-2023 10:38

    Good thought... I've seen that in a few places. 

    Also make sure SQL server is set with a memory cap, so it doesn't starve the rest of the server processes for memory.



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

    Original Message


Related Content