SANCHAY POST KNOW ISSUES & PATCHES

Error Description	Patch file
from Google drive :   Download all in one
Primary key violation error in Regeneration of files for SO form in online module at HO	DBDE_RegSO
Difference in live accounts data between DET and DBAnalyzer	DETFile
Primary key violation error in Project Arrow forms in online module	PA_Forms
Primary key violation error in RD - Account Close by BO form in online module	RD_BO
Availability of multiple signatures for a single account	Signature
NREGAEMO database error while logging into online module / invalid user 'nrega' in DBAnalyzer	Upd_Nrega_User
Unable to update common form number error in online module	Update_Cmnform
Cannot alter previous day’s transactions error in SOSB module	Update_Cons
Longer time taken for processing of forms in online module	Update_DB
Data entry module could not be opened due to wrong password	Update_DE
Run patch for NSC / KVP error while issuing / discharging certificates in online module	Update_Fresh
Database tampered - Rows conflict error in negative list updation	Update_NL_Fresh
NREGS tables are not available in POST / SO databases	Update_NR_Tables
NREGS job card renewal to be performed	Update_NREGS
Invalid pincode error while discharging certificates in online module	Update_Patram_Details
Primary key violation error (pending status) in RD deposit form	Update_Pending
Forms pending error during day end even though no forms are pending for authorisation	Update_Pending_DayEnd
Primary key violation in ‘account open through agent’ table  while performing RD bulk posting	Update_PK
Invalid object name error while viewing Agent reports	Update_Report
Stored procedures missing in POST / SO databases and Error while viewing passbook for RD accounts	Update_SP
Patch cannot be run from client system while running 'Patch for SPUser' during fresh installation	Update_SQL2008
Missing tables in POST / SO databases	Update_Tables
Database tampered error in negative list updation	Update_Trigger
Form 'Regeneration of files for HO' missing in online module in SOs	Upg_SOForms
Form ''Re-generation of files for S.O' missing in online module in HO	Upg_HOForms
Form 'MIS - Excess Withdrawal' missing in online module in HOs	Upg_MIS_EW
Form 'RD - Account Close BO only' missing in online module	Upg_RD_BO
Form 'Ledger Corrections' missing in online module	Upg_Form_LC
Login failed for user 'Arrow' error	Arrow
Email issues related to this software to : sblansupport@hotmail.com

Source : http://tamilnadupost.nic.in/sdc/adnl.htm

SB Order 01/ 2014 : Printing of modified Standardised uniform SB Passbooks for CBS Post offices and change in text of information printed in the Passbook about Small Savings Scheme

SB Order 01/ 2014 : Printing of modified Standardised uniform SB Passbooks for CBS Post offices and change in text of information printed in the Passbook about Small Savings Scheme

Negative List Updation Patch - Updated upto 31/01/2013

The file 'NL_20130131.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. This will update the negative list upto 31/01/2013  in Sanchay Post.

In addition to Negative List, updations relating to PINCODE details are also done in the database. Hence, execution of this patch will take longer than the usual updation time. System Administrators should ensure that the server is not switched off till successful execution of the patch.

Note:
This patch file updates the negative list available in Sanchay Post software. To confirm updation, use the "Database Discrepancies >> NSC >> Details of Negative List Updation" option available in DBAnalyzer software.


Downloadable from FTP site of PTC, Mysore

Sanchay Post Violation of Primary key error

Error
In Sanchay Post while new forms withdrawal of MIS,SB,NSC it shows an error Issue New form (Database Error) "violation of PRIMARY KEY constraint 'PK_flow_table_1367E606'. Cannot insert duplicate key in object 'dbo.flow_table'." 

Solution:
1. Download attached patches.
2. Extract to DB_Analyser folder.
3. Execute all patches one by one.


Download

Important : Before doing any updation/execution of patches take the back of the databases

Coutesy : http://potools.blogspot.in

SanchayPost - Negative List 31122012

The file 'NL_20121231.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. 

This will update the negative list upto 31/12/2012 in Sanchay Post. (Corrections received upto 31/01/2013)

In addition to Negative List, updations relating to PINCODE details are also done in the database. Hence, execution of this patch will take longer than the usual updation time. 

System Administrators should ensure that the server is not switched off till successful execution of the patch. To confirm updation, use 'DBAnalyzer >> Database Discrepancies >> NSC >> Details of negative list updation' option. 

Download

SanchayPost - Holiday Initialisation for the year 2013

Please Initialize the Holiday as early as possible 

( First Enter Weekly Holidays, then Declared Holidays )

SanchayPost -> Super ->  Initialisation -> Holidays --> 

This screen is provided to initialise the holidays. They can be weekly holidays like Sunday and also the declared holidays.

• Enter the start date (for eg: 01/01/2013) and end date (for eg: 31/12/2013).
• Select the weekly holiday (Sunday or Saturday) from the list.
• Click on Create button. This will automatically create the holidays with the selected day (Sunday).
• To enter the declared holidays, enter the date in the field from Declared holidays form and also the description.
• (For ex: if the date typed is 26/01/2013, the description should be Republic day and so on). The day will be displayed automatically.
• Now click on the Save button.

• To view the list of holidays click on View button.
• To modify any record in the holiday list, click on Modify button.
• The list of all the holidays entered will be displayed on the screen. Modify the required record and click Modify button.
• To delete any record in the holiday list, select the record and click on the Delete button.
• To exit, click on Exit option in the main menu.

SO - HO Balance Agreement Tool

This tool can be used for listing SB / PPF / NSS accounts with differences between SO balance and HO balance as on 01-04-2012 (or 31-03-2012). Zip file dated 24-12-2012 contains new exe for comparing SO and SOSB balances for SB accounts.
	User Guide Exes (zipped) Last updated on: 24-12-2012 Zip includes 'Readme' file Source : http://tamilnadupost.nic.in/sdc/index.htm

DB Analyser and Negative list dated 26.11.2012

New DB Anlayser and Negative list released by SDC Chennai on 26.11.2012

Download

Sources:S A Post. blogspot.in

Execution of SCS - SI entries for 29/09/2012

Execution of SCS - SI entries for 29/09/2012

Unzip the files to a subfolder in SP5 folder in server or any one of the clients. Logout of Sanchay Post from all the clients and server Backup POST database Execute "scs_si.exe". Click on 'RUN SCS SI' This exe should be executed before day-end of 29/09/2012 Click here to download patch files

Email issues related to this software to sblansupport@hotmail.comSoftware Development Centre O/o the Chief Postmaster General Tamilnadu Postal Circle Chennai - 600002 Phone: 044-65850861

PATCHES FOR SANCHAY POST VERSION 7.0 DATED 27/09/2012

Software Development Centre, Chennai

Patches for Sanchay Post Version 7.0
Sl.No.	Details	Copy to	Folder	Uploaded on
1	Online Transactions (7)	All systems with Sanchay Post Software, running the respective modules.	SP5\OT	27/09/2012
2	SOSB Online (4)		SP5\SOSB	27/09/2012
3	Data Entry (1)		SP5\DE\SB	14/08/2012
4	SOSB  Data Entry (1)		SP5\SD\SB	14/08/2012
5	NREGS - Data Entry (1)		SP5\NR\DE	05/09/2012
6	NREGS - SOSB Data Entry (1)		SP5\NR\SD	05/09/2012
7	SBCO (1)		SP5\SBCO	05/09/2012
Email issues related to this software to sblansupport@hotmail.com

Software Development Centre
O/o the Chief Postmaster General
Tamilnadu Postal Circle
Chennai - 600002
Phone: 044-65850861

 

Sources;www.sapost.blogspot.in

DBANALYZER FOR SANCHAY POST - DATED 27-09-2012

Software Development Centre, Chennai

---

DBAnalyzer for Sanchay Post
	Software Package (zipped) Revised Exe (zipped) Last updated on: 27-09-2012
Email issues related to this software to sblansupport@hotmail.com

---

Software Development Centre
O/o the Chief Postmaster General
Tamilnadu Postal Circle
Chennai - 600002
Phone: 044-65850861

sources;www.sapost.blogspot.in 

SBCO UTILITY 2.1.1

Software for SBCO developed by:

SRIKANTA S

PA (SBCO) Madikeri HO

Features:

1) Count and Display Accounts Opened between Two Dates for all Category.

2) Count and Display Accounts Closed between Two Dates for all Category.

3) Count and Display Accounts Transferred IN between Two Dates for all Category.

4) Count and Display Accounts Transferred OUT between Two Dates for all Category.

5) List of Transaction (LOT) view for all Category.

6) Ledger View for SB, RD, MIS, PPF and SCSS categories.

7) Live Accounts Report.

8) Accounts Without Date of Open Report.

9) Accounts Without Depositor Name.

10) Account Number Not in Index for All Categories.

11) Accounts Out of Ledger Chart.

12) Invalid Accounts List.

13) Find and Delete Duplicate Accounts.

14) Minus Balance Report for all Categories.

15) Closed Accounts With Balance for All Categories.

16) Silent Accounts List.

17) Binder Number Corrections.

18) Modify HO/SO Transaction Dates.

19) Update DLT (For RD Category).

20) Query for All Categories.

21) Find and Delete Invalid Records.

Latest Software Version: 2.1.1 - Released on 03/09/2012
Updated: Option to Check for Software Updates through Internet

Download

Source : www.sbcoutility.blogspot.com