Document status: RELEASED

Date:

Stocktaking Performance Improvements

(TFS: 167621)

StocktakingCommandsJob job has been split into three jobs, so the user will be able to process count list, complete stocktaking and finish count group at the same time:

  • The new job CountListProcessorJob - responsible for 'ProcessCountList' event, will process new count list;

  • The new job CountingGroupProcessorJob - responsible for 'CompleteCountingGroup' event, will process complete count groups in 'Cycle' and' Items not counted' stocktakings;

  • The old StocktakingCommandsJob - responsible for 'CompleteStocktaking', will complete Periodic, Random stocktakings.

Previously, these three actions were handled by the same job, which caused a lot of delay when several stocktaking were being completed at the same time.

Configuration:

  • When BackofficeIntegrationSubscriber package update ends, enable new jobs: CountListProcessorJob and CountingGroupProcessorJob;

  • Check if service bus subscription is enabled in configuration of each new job;

  • Set up ItemSaleUrl, ItemSaleExtentedUrl and BridgeInventoryServiceUrl in new jobs configuration the same as in the StocktakingCommandsJob;

  • Check if after Integration Platform restart to the topic StocktakingCommands have been added two new subscribers CountListsProcessing and CountingGroupsProcessing.

Improvements

Module

Description

Reports

Improvements in upgrade package (TFS: 163231)

There are improvements in the upgrade package related to update of reports. Upgrade package will always contain latest version of reports from build server. Support for customers running Reporting Services 2017 is added.

SIC Register

Processing of SIC Codes (TFS: 167566)

The job CustomerSicCodeUpdateJob had issues updating SIC Codes due to performance issues. The performance of this job is now improved and able to handle more data in shorter period of time.

Stocktaking

Stocktaking translations (TFS: 167558)

Corrections in Swedish and Norwegian translations. From now on, correctly translated text in Swedish is displayed upon finishing stocktaking.

Problems with status "Pending stocktaking" (TFS: 168118)

A problem stocktakings being stuck in “Pending” has been improved. There is a possibility that the main problem may occur again, if for some reason something fails during operation (update) on StocktakingResult, e.g. if the SQL Server is restarted at the same time. This will cause the stocktaking to be stuck on “Pending” status, and not all lines/details from the last POSLog will be updated in Retail database. Timeout related to this is increased from 30 sec to 15 minutes, and the loading time of Stocktakings grids and Stocktaking Result grid has been improved to perform faster.

  • No labels