FYI - Sage 50 2024.0.1 Update Issue

SOLVED

FYI for anyone having issues installing the Sage 2024.0.1 update
Never did have an issue such as this on any other previous updates.

Today, I installed the Sage 50 2024.0.1 Update for a client.
Starting with the server i attempted to install the update.
I received the message: Sage 50 Update could not be completed and needs to be run again.
The steps below resolved the issue and I was able to process the update.
No issue installing the update on the workstations.

Hope this helps anyone having this issue.
Hopefully Sage 50 Support will take a look at this as it does seem that the update process is not stopping the Actian Zen Workgroup database service and apparently it should.

Lonnie

References:
  • Update did not apply on first attempt.
  • Restarted Server
  • All attempts would get the message:
    Sage 50 Update could not be completed and needs to be run again.
  • Reviewed: C:\ProgramData\Sage\Peachtree\PeachWLog.XML
    • Found line on each installation attempt that stated that during the BackupPatchFileData process, C:\Shared\Data\Sage 50 Data\Company\Attrib.ddf, copying the back files failed. 
    • Attempted to rename the Attrib.ddf file and could not because some process had it locked. 
    • Used steps in the above references to find the process which I determined to be the zenengnsvc32.exe process.
    • This is the Actian Zen Workgroup Engine Service
    • Ending that process freed the lock on the file. 
    • Note, I did not rename the Attrib.ddf file. Now knowing that the file was no longer locked, I proceeded with the update
    • Was able to then complete the update successfully. 
  • After the update was complete, attempted to start Sage 50 but could not as the Actian Zen Workgroup Engine service was not restarted. 
  • Restarting this service,Sage would then now open normally. 
  • Restarted Server just as a best practice.
  • Moving on to updating the workstations. 

Screenshots:

Top Replies

  • Hi  ,

    Thank you so much for sharing your experience and the resolution steps for installing the Sage 50 2024.0.1 update. Your detailed post is incredibly helpful for others who might encounter the…

  • +1
    verified answer

    Hi  ,

    Thank you so much for sharing your experience and the resolution steps for installing the Sage 50 2024.0.1 update. Your detailed post is incredibly helpful for others who might encounter the same issue.

    For the community's benefit, here's a summary of the steps Lonnie took to resolve the installation issue on the server:

    1. Lonnie encountered an error message stating that the Sage 50 update could not be completed and needed to be run again.
    2. After restarting the server and reviewing the PeachWLog.XML file, Lonnie discovered that the update process was failing to copy backup files due to the Attrib.ddf file being locked.
    3. By utilizing the resources provided, Lonnie identified the locking process as the Actian Zen Workgroup Engine Service (zenengnsvc32.exe).
      • The Sage 50 US team advises to use this article to check for running processes at this point, specifically highlighting zenengnsvc32.exe among others, and ending them to resolve the locked file issue.
    4. Terminating this service released the lock on the file, allowing the update process to continue without renaming the Attrib.ddf file.
    5. The update was successfully completed after this intervention. However, the Actian Zen Workgroup Engine service needed to be restarted as Sage 50 wouldn't open without it.
    6. A server restart was performed as a best practice before proceeding to update the workstations.

    I've forwarded your post comments onto the Sage 50 US product team to  ensure that they review and look into this matter for future updates.

    If anyone else encounters similar issues, please refer to Lonnie's steps, and don't hesitate to reach out for further assistance. Chat with support here.

    Warm Regards,
    Erzsi

  • 0 in reply to Erzsi_I

    The Sage 50 US support team has advised us of a helpful resource that fits perfectly with Step 3 of the troubleshooting process shared by Lonnie so I've added it in above.

  • 0

    Yes. I experienced this as well. I restarted the server and the installation automatically continued upon restart and completed successfully. However, all of our workstations presented error messages when trying to install the patch. I had to find the patch file (or download online) and manually install on each workstation.

    Another unfortunate bug is that now if you have a new workstation and want to install from clientinstall.bat, that will no longer work (for the time being). During installation the software seems to think that the company data directory is inaccurate or inaccessible or outdated (I'm finding users experiencing different error messages). See this discussion for more information: Community Hub (sage.com)