aipeu puri

aipeu puri

Friday 13 February 2015

Sequential Installation / up gradation of Sanchay Post and Table “Collation” Conflict

From: adpmu-odi

Sent: 13 February 2015 15:06

To: PMG Behrampur Region; PMG Sambalpur Region; adtech-bmp.dop; Phulbani DO; Koraput DO; Kalahandi DO; Aska DO; Sundargarh DO; Sambalpur DO; Keonjhar DO; Dhenkanal DO; Bolangir DO; Mayurbhanj DO; Bhadrak DO; Balasore DO; Cuttack South DO; Cuttack City DO; Cuttack North DO; Bhubaneswar DO; Puri DO; Berhampur DO


Subject: Sequential Installation / up gradation of Sanchay Post and Table “Collation” Conflict  

To

The PMG Berhampur(GM) / Sambalpur
All the SSPOs / SPOs in Odisha Circle

No. SB/46-1/2010(SPOST)/CH-I                                       Dated at Bhubaneswar 13/02/2015

Subject:  Sequential Installation / up gradation of Sanchay Post and Table “Collation” Conflict               

A number of phone calls have been received by this office about problem in different sectors in Sanchay Post (especially in C Class P.Os where Sanchay Post is being installed newly) and about “Collation” Conflict while running “Consolidated Report” in DB Analyser as well Data Migration (Mock & Go Live). 

                In this connection I am directed to intimate the following for information and necessary action and to bring this to the notice of all concerned. 

                Installation / up gradation of Sanchay Post must be done in the following sequence.  After perfect Day End take a full backup, keep it in safe and proceed for up gradation  to next Version of Sanchay Post,  it is mandatory.  

 
Work to be done sequentially for installation of Sanchay Post
What happens if not Run / up grade
1
Sanchay Post 6.5 for New Sites
All required tables will not be created.
2
Sanchay Post 65R2 up gradation Patch-19022010
Necessary up gradation to Databases will not be done
3
Run “No Max Deposit Limit in SB”
Deposit limit will not be removed.
4
Run MoF_RateChange  (to change the Rates from 01112011).
Without it software will not allow further up gradation.
5
Sanchay Post 6.6.1
Necessary up gradation to Databases will not be done
6
Run Interest Change_0412 (to change the Rates from 01042012)
Rate changes will not happen & further up gradation may not be possible
7
Sanchaya Post 7.0
Nregaemo DB will not be created
8
Run InterestChange_0413 (to change the Rates from 01042013)
Rate changes will not happen & further up gradation may not be possible
9
Run InterestChange_27062013 (to Add RD NSC Rates from 01042013)
Rate changes will not happen & further up gradation may not be possible
10
SanchayPost7.5(Date-21012014)
Necessary up gradation to Databases will not happen.  All required tables for NSC IX Issue & SCSS will not be created.  UIDAI entry problem will arise.
11
Patch 1 for Sanchay Post 7.5(Date-28-01-2014)
Necessary up gradation to Databases will not happen.
12
Patch 2 for Sanchay Post 7.5(Date-19-02-2014)
Necessary up gradation to Databases will not happen.
13
Upgrade Nregaemo Fix for SanchayPost7.5 (Date-04-02-2014)
Necessary up gradation to Nregaemo Databases will not happen.
14
Run InteretRateFrom01042014 (to change the Rates from 01042014)
Rate changes will not happen & further up gradation may not be possible
15
SCS_Ledger_Adjustment_( Of 04 June 2014)
SCSS interest problem will not be solved.
16
Service Pack 1_29May2014
FTO processing problem will arise
17
Patch 5 for SanchayPost7.5-Dtd11082014-)
RD new DF & CC suffix change 6 to 8 will not happen.
18
Patch 5 (Revised for BORD Default Fee) for SanchayPost 7.5 - Dtd20092014
RD new DF for BORD will not happen.
19
Patch 6 for SanchayPost7.5-Dtd08102014
Necessary up gradation to Databases will not happen.
20
Patch 8 for SanchayPost7.5-Dtd18112014(KVPReintroduction)
KVP 2014 Issue will not be activated.
21
Patch 7 _ Sanchay Post 7.5-23Sep2014(Released in 23Dec2014)
SCSS PMI on SB Rate  & Quarterly Interest for normal accounts will not flow on first day of next quarter.
22
KVP_Reintro_Patch 8_Final dtd 20_Nov_2014(Revised-KVPReintroduction)
KVP problem will not be activated.
23
KVP_Old_Stock_Clearance_Tool
Not for new installation
24
Fix_KVP_reports_Discharge_Patch 8.1
KVP Discharge Report problem will arise
25
Patch 10 for Sanchay Post 7.5 (Introduction of SSA)-22.01.2015
SSA (Sukanya Samriddhi A/c) will not be effected.
26
Patch_10.1_dtd_03_02_2015
Subsequent Deposit in SSA will not be solved.

 Further, if there exists “Collation” Conflict in Default PO Name Table, “Consolidated Report” in DB Analyser will not run.  Please rectify the same.  

At the same time, if there exists “Collation” Conflict in any table in “Post” and “MDE” Database, neither mock migration nor Go Live migration will happen.  The concerned tool will exit throwing error message.  To remove the conflict, “click on Restore Default” in the table design to restore the database default. 

Hence I am further directed to request to bring this to the notice of all concerned (especially officials involved in discrepancy settlement & migration) and advise them to check the databases at S.Os and rectify the “Collation” Conflict for smooth settlement of discrepancy and smooth data migration. 

*** For creating database in Backup Server for migration (mock & Go Live) no need of installing from Sanchay Post 6.5 for New Sites.  Database may be created in Sanchay Post 7.5, as on restoring the DBs, the upgraded DB will come automatically.


D K Samal
Asst. Director(PMU)
O/o-CPMG,Odisha Circle
Bhubaneswar-751001