UpgradeError:27506 Script Upgrade Dataupated Auto 6.6 Sql Line 1171 statement has been terminated

UpgradeError:27506 Script Upgrade Dataupated Auto 6.6 Sql Line 1171 statement has been terminated

This KM is for Internal Purpose Only for CitiXsys

 

Environment : iVend 6.5.6 database restored with iVend 6.6 Installer

Problem Statement : While upgrading from 6.5.6 to 6.6 when run the iVend installer, get the error validation message ‘Error 27506 Executing SQL Script Upgrade Dataupdates Auto 6.6 Sql Line 1171 The statement has been terminated’

Symptoms : Environment Specific

Resolution/Work Around : We have suggested below steps to perform and issue has been resolved.

Step 1. Please restore the database again from the backup.

Step 2. Please execute below query once database successfully restored :

Step 3. update CfgReport set IsCustomized-0 where ReportKey='1'

Step 4. Please verify whether above query successfully executed.

Step 5. Now run the iVend installer.

Recommendations /Suggestion : N/A


    • Related Articles

    • Upgrade iVend version from 6.5 to 6.6

      Environment: 6.5.X Statement : Is there any guide to show how to upgrade the iVend version from 6.5 to 6.6, step by step? Resolution: iVend 6.6 is a quantum jump with various new technologies such as Quartz, Signal R, GZip MS IIS, SQL Servers, etc. ...

    • compatibility version SAP & SQL Version

      Product Query Customer currently using the SQL version 2016 in HO and stores in 2008 express . SQL 2019 and higher version will support ivend 6.6? SAP Version 10 and Pl 2405 and higher PL version will compatible with ivend integration ? Answer As per ...

    • iVend 6.6 Performance Issues-Required SQL Index

      This KM is for Internal Purpose Only for CitiXsys Environment: iVend 6.6 Problem Statement: We have noticed that customers are facing performance issues with iVend 6.6. Symptoms: Environment Specific Resolution/Work Around: Technical Team has checked ...

    • Unable to open the ivend configuration after upgrade

      Product version: iVend Retail Configuration Manager 6.5 update 6 Problem statement: Customer not able to open the iVend configuration manager and Integration stops after upgrade. Proposed solution: We checked Windows event viewer --> System or ...

    • Configure Auto Generate serial number for transaction

      Product version: iVend 6.6 and iVend 6.5.6 Problem statement: How to configure auto generate serial number for transaction. Proposed Solution/Workaround: We can Define the Document Number Series for various transaction types to generate Serial ...