Store Backup : error message: [Mircrosoft] [ODBC SQL Server Driver] Text column data incomplete
** Internal Purpose **
Environment:
6.5 Update 5 with SAPB1
Problem Statement:
While initializing Store database backup, it displays the error message :
Symptoms:
While initializing Store database backup, it displays the error message onStore backup screen.
Resolution/Work Around:
Below is the error coming when restoring the store backup (taken from Enterprise MC) at store:
(Error: Text Column data incomplete):
Below Script needed to run to resolve the issue at Enterprise Database and then took a fresh backup of store from Enterprise MC
ALTER TABLE TrxTransactionLayaway ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionQuotation ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE LbrLaborTransaction ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxARPayment ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TilVariance ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvInventoryRevaluationDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvProductPriceManager ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionLostSaleItem ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionCoupon ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE PurVendorComment ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionSurcharge ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvInventoryTransaction ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE PurPurchaseOrder ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE PurPurchaseOrderDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvStockTransferRequest ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvInventoryRevaluation ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvSerial ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionGiftCertificate ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvInventoryTransactionDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE ConTrxTransaction ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE ConTrxARPayment ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvLocationStockTransfer ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvBatchLocation ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TilCountDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionFulfillmentDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TilCount ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE ConTrxTransactionSurcharge ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvBatch ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE RtlExpense ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionFulfillmentDeliveryDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE ConTrxTransactionSaleItem ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvGoodReceipt ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvTransactionSurcharge ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionOrder ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvGoodReceiptDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvInventoryCount ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvProductBuildBreak ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TilSessionTransaction ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvGoodsReturn ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvGoodsReturnDetail ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionSaleItem ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE ConTrxTransactionSurcharge ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE InvProduct ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransactionFulfillment ALTER COLUMN Comments nvarchar(4000)
ALTER TABLE TrxTransaction ALTER COLUMN Comments nvarchar(4000)
Recommendations /Suggestion:
1) Such script is only for 6.5 Update 5 and need to check with Support Team before executing
2) Such Scenarios are handled in iVend 6.6 Latest version
3) Take a fresh backup of the HO database.
Related Articles
ERROR [IM002][Microsoft][ODBC Driver Manager] when opening the Integration Monitor
Problem Statement: While opening the Integration Monitor, we are getting the below ,error message : ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver provided. We restart the integration service but the ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...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 ...Fix for Store Backup issue with TLS1.2 for iVend Cloud Customer
************************** Internal to Citixsys Support *************** Environment: iVend 6.6 7989 integrated with SAPB1 deployed on Cloud Problem Statement: Cloud Customers with TLS 1.2 enabled iVend HO MC, are not able to create Store backup files ...Error while restoring the Store Backup file at Store
Problem– While trying to take a Store Backup from HO (Enterprise Server) OR While restoring a Store Backup file (Store Initialization) we may come across the following error. The Error Description will be like: “Could not load file or ...