Problem In Store Database Backup Restore.
Problem :
Unable to Create Store Database from HO Management console. Script.xml is not created in the backup file.
Reason :
Earlier backups were corrupts because following SQL statement was throwing error as:
Select A.* From InvSerial A With(nolock), InvProduct B With(nolock) Where SerialKey
between '5000000000001' and '5999999999999999' And A.ProductKey = B.ProductKey And B.IsGiftCertificate = 'TRUE'
AND B.GiftCertificateType = 2
AND TRY_CONVERT(NUMERIC(18, 6), SerialNumber) IS NOT NULL
Error Code - Numeric value 'SerialNumber' is not recognized
Resolution -
We had to change the compatibility level of SQL Server to resolve the issue at iVend Enterprise DB Level and Store DB Level.
Following command was executed as:
alter database [CXSRetail] SET COMPATIBILITY LEVEL = 120
Related Articles
Addon information was not updated for newly created store
Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...Cannot open database 'CXSIntegration' login failed
Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Error message "Scripts.xml missing" when trying to restore the store backup on the new store pc
Product version: 6.5 Update 5, 6.6 Problem statement: Below error can be encountered while restoring the store backup on the store machine. This has been found appearing at a time while re-initializing the store Below is the screenshot of the error: ...Store Backup on iVend Cloud
Environment: iVend Cloud Version 6.6 Problem Statement: Create store database backup from enterprise from iVend Cloud Symptoms: Store Database created from iVend Cloud with the file size 1 KB. Resolution/Work Around: Step 1: Login to iVend Cloud ...