Speed Net 4.3 SPCOD Error and Solution

SPCOD Transfer error and Solution

 During transferring SPCOD to Meghdoot Postman an error is shown.

Could not find stored procedure 'ValidateSPCODReturns

Solution for SPCOD transferring issue

Please do the following and check: 

(i) Please take full backup of POSPCC database. 

(ii) Please re-run the script (EXL) file, POSPCC_COD_09102015.exl, which will be available in '\\SpeedNet\SpeedNet Client\DB Scripts' folder of the Client machine from which the SpeedNet 4.3 upgradation was attempted. Note: If you have upgraded SpeedNet Client from Server machine, then the DB Scripts will be available in '\\SpeedNet\SpeedNet Client\DB Scripts' folder of Server machine. 

(iii) Please check the log file generated after script file execution. If any error is noticed, then please supply the log file generated for analysis. Important Note: In SpeedNet Version 4.3, SQL Server is being configured to allow remote connection through SQL Queries. This configuration is mandatory for SP COD related activity. As such, please upgrade the SQL Server to 2005 or 2008 or 2012 before upgrading the SpeedNet to 4.3 Version.