Job Queue - Release Notes

Job Queue - Release Notes

v480.1000  2025.04.02
  1. Update to run in .Net framework 4.8.0
  2. Add ability to run in Parallel - multi thread mode
  3. Add ability to run in Interactive mode
v462.1001 - Update to Flush Buffering Appenders; Add AppContextSwitchOverrides for TLS 1.2
v462.1000 - Update to run in .NET Framework 4.6.2 with Connected Services *Requires SRI Macro Server v1000.1000*
"Optimize SRI_JOB_QUEUE SQL Indexes
- Move COMPLETE_DATETIME to first Column
- IX_Dequeue: Add JOB_ID Column for ORDER BY tie break"
Optimize SRI_JOBSUBMIT SQL Performance (Refactor out upfront EXISTS check)
v450.1006 - Update ProcessMacroScriptJob to Wrap in Double Quotes (if spaces) & Set Engine to VBScript
v450.1005 - Enhance Timed Out Errors, Properly Escape Quotes with No Spaces, Handle Timed Out Check & Enhance Logging in ProcessExecutable()
v450.1004 - Support Spaces in ProcessExecutable() with Quotes
v450.1003 - Run: Fire Process Event Now in separate Thread so Window Service responses cleanly when Started
Resolve MSBuild not honoring Prefer32Bit when PlatformTarget not explicitly defined as AnyCPU
Add README.txt for 32-bit(x86) Install Instructions (Note: Assembly must be same name to pass legacy SRI Macro Server Licensing Check)
v450.1002 - Add 32-bit (x86) build with Prefer 32-bit compile flags & Add better exception if Creds Key not found
Fix loading log4net.dll.config when running as Service
v450.1001 - Update log4net to log separate files per Server Instance DB & set Application Name=Synergy Job Queue for SQL Server Connection strings
v450.1000 - Major Refactor & Upgrade .NET 4.5
"Removed garbage scripts (backup file in use ~script)
Rename files to include installation order
Refactored code to insert using a Sequence
Added Index to support the job lookup query"
"Modifications to Database Table Installer
--BAT File configuration for proper logging
--Cleanup of SqlServer installer / files"
This is a very active project
"Source cleanup / add missing projects

manual merge differences in code as necessary

Remove assemblyinfo.cs from all projects except the queue engine (all other projects will use engine assembly info as linked file)

Add references folder (for log4net & VTGMacroServerInterface.dll)

Add post build commands so releasekit folder is created for all projects (except SqlBase)"
Update debugging, got it to build (for Royal).
Add Retry logic to Load, LoadQueue, and Execute as in Save.
Handle "deadlock victim" and other SQL errors gracefully.
Queue engine now looks for status of "Go" to Execute queued job


"Build 4225

*********Enhancements: (not tested)*************
New Job Type: EX - Designed to Run EXE without blocking
New Job Type: EB - Designed to Run EXE WITH blocking

Added Worker.ProcessExecutable methods
- UnTested, intended to run external process with new Job type
************************************************

*********Enhancements:  ************************
New Command Argument /P 0 or 1 Enable Performance Monitor

Re-factored JobQueuePerformanceCounter eliminating Static Methods (and constructor) to work with the Conditional Enable per instance.  


************************************************

Refactored Command / Help options Uses Windows Forms Messagebox"

    • Related Articles

    • Macro Server - Release Notes

      v1100.1001 2025.05.11 (Beta Release) - Add support for editing Visual ERP Macros - VTG.Loader.dll is now using Framework 4.8 - Update supporting nuget packages to latest release. - VTGMACMT.exe has been renamed to MacroEditor.exe v1100.1000 ...
    • Shipper Connect - Release Notes

      "DatabaseConnectionUI: Fix Server not always being disabled for Oracle DatabaseConnectionUI & DefaultDatabaseConnectionUI: Ignore case for string compares FrmMain: Eliminate try/catch for alias" Add MacroStub.vms to the ClientLoader Project Macro ...
    • Synergy/Avalara Tax - Release Notes

      v1100.1003 2025.05.11 Add more diagnostic to validate the shipping address sent mod to SRI Macros SRITAX/SRITAXC to better handle an empty Avalara return data packet Add <line1><line2><line3> to the request packet information for traceability in ...
    • WM-Synergy SBO - Release Notes

      v1100.1003 - 06/11/2025 Fix Issue in ShipperLine Customer Order for Part id 500pcs, WorkOrder to make part id is for 1000pcs. Linked CO to WO for Supply links for the 500 pcs. Ship the 500 pcs from sbo objects, expectations are (Visual ERP) customer ...
    • Launchpad - Release Notes

      version: 1100.1001 Date of Release 2025.05.28 (Beta) Utilizes Crystal Reports x64 now at service pack 37 LaunchPad now has it's own application pool (LaunchPad no longer supports x86) Oracle SQL Server may not work with this Release (to be reviewed ...