Problem In Store Database Backup Restore.

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

    • Store re-intialization Step

      Product version: 6.5 Update 6 or 6.6 Problem statement: User want to re-intialize the store. Proposed solution: Suggested customer to re-initalize Store by creating Store backup file from iVend Enterprise MC screen only when replication is cleared ...

    • How to debug Error related with store initialization

      Environment : iVend 6.6 integrated With SAPB1 Problem Statement : During the store initialization an error message has been encountered while configuring the Replication service for the store and the store were not initialized. Below is the attached ...

    • Store Reinitialization : Till assignment Error "Object Reference not set of an instance..."

      Problem Statement After Store initialization ,User doesn't able to assign the tills on POS screen. Environment iVend 6.6 with SAPB1 Resolution/Work Around When store is initialized, user should consider below points Replication should be clear from ...

    • 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 ...