UpgradeError - 27506 No item by the name of 'cfgcustomerdisplayfeedbackResult' could be found

UpgradeError - 27506 No item by the name of 'cfgcustomerdisplayfeedbackResult' could be found

This KM is for Internal Purpose Only for CitiXsys

 

Environment : iVend 6.5 Update 6 database upgrade with iVend 6.6 Installer

Problem Statement : While upgrading from 6.5 Update 6 to 6.6 when run the iVend installer, some time we get the error validation message ‘Error 27506 No item by the name of 'cfgcustomerdisplayfeedbackResult'could be found in the current database, given that item type was input as 'null' 15225’.

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 to check whether this table exists or not :

select * from CfgCustomerDisplayFeedbackresult

Above table not there as you informed yesterday.

Step 3. If above table not there please execute below script on the fresh restored database :

CREATE TABLE [dbo].[CfgCustomerDisplayFeedbackResult](

[FeedbackResultKey] [bigint] NOT NULL,

[TransactionKey] [bigint] NULL,

[QuestionsKey] [bigint] NOT NULL,

[SelectedValue] [nvarchar](250) NOT NULL,

[Created] [datetime] NOT NULL,

[CreatedBy] [bigint] NOT NULL,

[Modified] [datetime] NOT NULL,

[ModifiedBy] [bigint] NOT NULL,

[IsDeleted] [bit] NOT NULL,

CONSTRAINT [PK_CfgCustomerDisplayFeedbackResult] PRIMARY KEY CLUSTERED

(

[FeedbackResultKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

GO

Step 4. Once this table 'CfgCustomerDisplayFeedbackresult' created, please check and verify it.

Step 5. Now run the iVend installer.

Recommendations /Suggestion : N/A


    • Related Articles

    • CfgCustomerDisplayFeedbackResult could not be found.

      Problem Statement CfgCustomerDisplayFeedbackResult could not be found. Environment iVend Version 6.6 Symptoms The Db is already used for Upgrade earlier. Resolution/Work Around  Restore new backup and again run Installer. Recommendations /Suggestion  ...

    • Getting error in integration monitor "Data source name not found and no default drive specified "

      Problem Statement Getting an error on integration monitor when we are trying to view the records "Data source name not found and no default drive specified" Product Version 6.6 Proposed Solution If we are trying to connect with HANA DB please check ...

    • Item Matrix Global Settings

      Item Matrix Global Settings This feature allows the user to define the Global Code and Inheritance settings for Matrix Items. These settings are used as the system defaults and are inherited to the Matrix products in the first instance. The user can ...

    • Stock Transfer error "Item not found product-' ' , warehouse-

      Problem Statement: While making Stock Transfer receipt on receiving store MC, user get the error “Item not found product - Warehouse - “ Version : iVend 6.5 Update 6 Check Points: 1. Check if Sending warehouse/Receiving warehouse contains correct ...

    • License File not found

      Problem Statement:- License File not found. Problem Description:- An issue comes to a specific user while using the Item matrix on the terminal server. Troubleshooting attempts : -- Gave user full permission to the item matrix folder on the SQL ...