What's New

Modified database service to immediately stop retrying when encountering SQL errors 207 (Invalid column name) or 208 (Invalid object name), which indicate structural database problems that won't resolve with retries. This reduces unnecessary delays and log noise when database schema issues occur.

Changed log severity from Error to Warning when users intentionally stop strategy execution due to load failures. This reduces alarm fatigue in logs since these are expected user decisions rather than system errors.

Fixed "Invalid column name" errors when viewing Ace Hardware catalog details. The catalog lookup screen was using property names (Department, PricingStrategy) instead of the actual database column names (Dept, PS), causing crashes at stores 1838 and 10492. The query now correctly references the database columns.

Changed the OrderMultiple field from integer to decimal type to accommodate stores that use decimal order multiple values instead of whole numbers. This resolves data import errors and crashes when loading product data from POS systems that store fractional order multiples.

Added Formula1 through Formula5 columns to the mainTable_v2 table definition so that store group tables (like StoreGroup_NonCore_mainTable) include these columns when rebuilt. Pricing strategy steps that filter on Formula3 values were failing with "Invalid column name 'Formula3'" errors because these columns were missing from group tables.

Added null value checks before converting OnHand and Last12 inventory fields to integers in the One-Click screen filters. This prevents the application from crashing when filtering products with missing inventory data.

Added guards to prevent adding empty margin actions when no specific margin value is entered in the Future Price Panel. This prevents invalid pricing rules from being created and ensures only complete margin specifications are processed.

The application build process now uses BestSize delta compression when creating update packages. This produces smaller incremental updates by more efficiently comparing differences between versions, reducing the download size when the application auto-updates.