POSTMAN 7.9.2 : PARCEL COD DELIVERED STORED PROCEDURE ISSUES AND SOLUTION

Postman 7.9.2 Stored Procedure Error : Parcel COD Delivered

In Postman 7.9.2, While verify the Parcel COD articles in Supervisor it may shows the error message as " Could not find stored procedure 'dbi.Reg_Msg_ParcelCODDelivered'.

the above error due to while Upgrade eCounter database in SQL 2005 / 2008  it may show the error message shown like below

Solution:

Error in execution of scripts of ePayment-

17:24:16:============================================

17:24:16:         SCRIPT EXECUTION DETAILS (eCounter)

17:24:16:============================================

17:24:21:[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 -- =============================================

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

Solution By CEPT

Please execute the attached script using script tool after taking backup of eCounter database.

Download