Tag: SQL

Retail offline sync service: string or binary data would be truncated error

Fix for Offline Sync service synchronization error ‘String or binary data would be truncated’

POS: SQL connections in case of multi-threading

Discussion how to handle SQL connections in POS background threads.

Retail download job fails with Timeout exception

Fix for Async Client fails to merge records to [ax].[RETAILCHANNELTABLE]/[ax].[INVENTTABlE] tables with error ‘Timeout expired’.

POS: Execute stored procedure

We will discuss how to execute stored procedures from POS using standard API: SqlStoredProcedure and DBUtil from DataAccess DLL.

Offline sync service: check if data sync is in process

We will discuss how to quickly validate if Offline Sync service is executing SQL actions on data or not.