Sequential Installation / up gradation of Sanchay Post and Table “Collation” Conflict
From: adpmu-odi
O/o-CPMG,Odisha Circle
Bhubaneswar-751001
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
