Speed Net Update - GenerateBill_A and KKCess error and Solution

12:29:32:============================================ 12:29:32: SCRIPT EXECUTION39094: DETAILS (POSPCC) 12:29:32:============================================ 12:29:32:[Invalid column name 'KKCess'.] : Script Execution Error : While executing statement CREATE PROCEDURE AAK_Gen_XMLInvoice_For__Amazon 12:29:33:[Invalid column name 'KKCess'. Invalid column name 'KKCess'. Invalid column name 'KKCess'. Invalid column name 'KKCess'. Invalid column name 'KKCess'.] : Script Execution Error : While executing statement CREATE PROCEDURE GenerateBill_A 12:29:20:============================================ 12:29:20: SCRIPT EXECUTION DETAILS (POSPCCBACKUP) 12:29:20:============================================ 12:29:20:[Invalid column name 'KKCess'. Invalid column name 'KKCess'. Invalid column name 'KKCess'. Invalid column name 'KKCess'. Invalid column name 'KKCess'.] : Script Execution Error : While executing statement CREATE PROCEDURE GenerateBill_A

Solution:

1. The referred issue is due to incomplete upgradation of SpeedNet to Version 4.4 Update 1 prior to upgradation to Version 4.4 Update 2. Now, please do the following and check: 
2. Download the following script files from ftp://cept.gov.in/SpeedNet/Speednet_4.4_update_1/: ECounter09052016.exl SP_V441_POSPCC07062016.exl SP_V441_POSPCCBACKUP07062016.exl
3. Take full backup of POSPCC and POSPCCBACKUP databases. 
4. Run these script files using Meghdoot ScriptTool.exe and check the log files generated.
5. If script files are executed without errors, then proceed to the next step. 
6. Re-run the below mentioned script files which will be available in '\\SpeedNet\SpeedNet Client\DB Scripts' folder of the Client machine from which the SpeedNet 4.4 Update 2 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. POSPCC07092016.exl POSPCCBACKUP07092016.exl POSPCC_COD_07092016.exl POSPCC_XML_Requirements_07092016.exl POSPCC_IPSCDS_Requirements_07092016.exl