Store/Offline POS restoring error :MicrosoftJODBC SQL Server Drives String data, right truncation

Problem :

After taking an Offline POS backup from the HO (Enterprise Server), an error may occur while restoring the Offline POS backup file during the Offline POS initialization process.

Error : MicrosoftJODBC SQL Server Drives String data, right truncation

The Error Description will be like:

“[Microsoft]|ODBC SQL Server Driver String data, right truncation”

Root cause :

During the patch activity,if offline POS machine configuration file was not replaced as per the current patch version or other as well . As a result, an error occurs while performing offline POS re-initialization.

 Resolution –

 To resolve the issue we need to replacing the updated configuration file as the deployed currecnt patch version, then  able  restored database successfully with our any error  and  able to log in to the offline POS machine 

 

 

 

• Related Articles

• Store Initialization Error [Microsoft][ODBC SQL Driver][String data, right truncation

  Problem statement : Below error appeared while Initializing the store [Microsoft][ODBC SQL Driver][String data, right truncation iVend version : 6.6 8929 Symptoms: This problem generally occurs when Configuration manager version and patch not updated ...

• Offline Terminal POS Data Sync with Store

  iVend Retail - Offline Terminal POS Data Synchronisation with the Store server This document describes the Offline Terminal POS feature and the data synchronisation with the Store Server. · This feature allows the Terminal POS to function even if the ...

• Require to make the inventory as Zero for particular store

  Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...

• Offline POS

  Introduction The offline POS feature allows the terminal POS to function even if the connectivity between the terminal POS and the store server is interrupted. The Offline POS feature has to be enabled via the iVend Retail Management Console. Note: ...

• Enable Offline POS

  Offline POS Introduction The Offline POS is related to a Store - in the same way as a Store is related to the Enterprise. This means that the replication dashboard if accessed from the On-premises Store will list all the offline POS terminals ...