Document status:

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:

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:


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.