Job Queue - Release Notes

Job Queue - Release Notes

v462.1001 - Update to Flush Buffering Appenders; Add AppContextSwitchOverrides for TLS 1.2
v462.1000 - Update .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

    • 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 ...
    • Macro Server - Release Notes

      v1000.1007 - Resolve Invalid or Expired Credentials Key Exception when calling Client ExecuteNonQuery(), ExecuteQuery() or ExecuteScalar() directly from Macro before any other methods - Server, Client & MacroEditor: ExecuteNonQuery(), ExecuteQuery() ...
    • ACH - Release Notes

      version 1000.1800 - framework to .NET 4.8 so OS decides best TLS version to use for emailing version 1000.1700 - Fix issue with US Positive Pay specific fields not being used correctly - Remove CdtrAgnt information for Positive Pay files - Remove ...
    • Launchpad - Release Notes

      version: 1100.1000 Date of Release 2024.11.18 Upgrade to support Visual 11 Oracle SQL Server will not work with this Release (to be done at a later date) January 2024 Updates Visual ERP Application Integration Enhanced (Revision 23129, 22nd January ...
    • Synergy Tax - Release Notes

      September 2023 Updates Revision 21880 (17th September 2023): Fixed Oracle syntax errors in the Avatax Batch Utility, ensuring smooth integration. Revision 21737 (6th September 2023): Refactored GL By Jurisdiction in Configuration for improved tax ...