Meghdoot 7.9.2 Upgrade Error and Solution

MM 7.9.2 Counter DB Upgrade Error in SQL 2005/2008

Error 1

Error in execution of eMO-

17:57:15:============================================

17:57:15:         SCRIPT EXECUTION DETAILS (emo)

17:57:15:============================================

17:58:04:[Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.] : Script Execution Error : While executing statement -- =============================================

Solution by CEPT

Please ignore the error, if any operational issues are observed please send the screen shot and details of problem faced. Then we will analyse and give solution.

Otherwise no issues is be observed so far

Error 2

Error in execution of scripts of Point Of Sale-

17:26:00:============================================

17:26:00:         SCRIPT EXECUTION DETAILS (Counter)

17:26:00:============================================

17:26:21:[Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.] : Script Execution Error : While executing statement CREATE    PROCEDURE [dbo].[UCRReport_PhilatelyStampSale]

Solution by CEPT

The issue is due to the restoration of database to a system with different collation. You may execute the attached script using script tool after taking backup of counter database.

Download

Thanks to RABINARAYAN CHOUDHURY