Verify Transaction Data Retention keep TDM_POS DB size at normal level

Verify Transaction Data Retention keep TDM_POS DB size at normal level


In Store level DB, old Transactions are being deleted by TransactionDataRetention  job  
By default Transactions older than 14 days are deleted by the job



In stations with heavy transaction activity TransactionDataRetention  that runs every 4 hours by default may not handle the deletion so more transactions coming in DB that being deleted

Check oldest transaction exist in TDM_POS by following script:

use tdm_pos select min(TransactionBegin) from TransactionHeader with (nolock)

if transaction its date is older than 14 days ,better change Job scheduler configurations to run more frequently


 increase  TransactionDataRetention job to run in shorter intervals
by default, TransactionDataRetention runs every 4 hours ,  Schedule cron set 0 0 0/4 ? * *

Change TransactionDataRetention  to run every hour or 30 min

Example:
0 0 0/1 ? * *       (1Hour)
0 */30 * ? * *     (30 min)

Sync POS
Restart POS job scheduler service

    • Related Articles

    • How to check used memory by DB

      Sometimes the ireports are loading slowly the possible issue is memory usage from DB, below a check query: SELECT DB_NAME(database_id) AS [Database Name], COUNT(*) AS [Page Count], COUNT(*) * 8 / 1024 AS [Memory Usage (MB)] FROM ...

    • PPX Portal login fail (error 503) - Verify iis_admin_user password not expire

      Verify iis_admin_user password expiration Open Computer Managment Verify status of iis_admin_user Checking user status from Powershell command line : net user iis_admin_user Example: PS C:\WINDOWS\system32> net user iis_admin_user User name ...

    • Using new printer in BSM

      Image for POS contain installed printer drivers. If replace POS and keep existing printer, will work without any action. For new station installation or replace broken printer, when use the new printer, is mandatory to update printer firmware.

    • PassportX Unified Installer error when want to install 2nd POS for Roxana Station

      BOS PC name and IP was wrong set into PassportX Unified Installer Settings screen. Recomandation is to check those parameters before save it into Uniffied Installer.

    • PAIS: Procedure to disable Orpak StoriX Pais Service (ShvaEPS)

      Orpak StoriX Pais Service Removal procedure Errors found in Comserver log Example: 2026/02/10 07:22:00.089|ERROR|[47]|00005574-0000-0000-0000-000000000000|||ComServer.WcfService.WcfCommunicationService - System.ComponentModel.Win32Exception: The ...