Wednesday, March 19, 2014

Latest Solutions for the issues in SanchayaPost 7.5

Before going for installation of Sanchay Post version 7.5, latest backup of all the databases should be taken and kept in safe. If the execution of "Upgrade_DB" completes with error and forgot to click 'Restore to Previous version', no solution is available with SDC.

S. NO
Questions
1
Issue is due to  missing tables or database : While Upgarding DB, Error " one or more tables are missing.check table_list_log.txt for more errors.kindly contact SDC chennai to fix these errors before running the tool" occurs
Pl check for missing tables of all databases using latest DBAnalyser.  (Solution for missing tables is available in SDC site under 'known issues - patches').  Pl check name of all the SO databases with corresponding entry in  'SOdb_name' table of POST database .If any irrelevant entry in that table, pl remove the same after obtaining prior permission from concerned authority.
2
Invalid object name 'dcl.misc' / table missing : 'dcl.misc'
"update_report" ( available in SDC site under known issues - patches)
3
Problems in Intialisation in the DE certificates/ working in DE Module
Detailed Procedure Document is available in SDC site. Ensure that the blocks  assigned in DE Module does not overlap with the one in Online Module.
4
Error while running Upgrade DB:  Invalid object name 'dcl.temp_scs_ledger' . The object 'PK__accountopen_thro__2077C861' is dependent on column 'scheme'
Click on "Restore to Previous Version" and contact SDC . If forgot to do this, Uninstall Sanchay Post version7.5 & install Sanchay Post version 7.0.   Restore the latest backup available with you (before going to 7.5) and make dataentry for remaining days. Then, contact SDC.
5
Error While Upgrading DB : But forgot to click "Restore to Previous version" and continued with Sanchay Post Version 7.5.
Uninstall Sanchay Post version7.5 & install Sanchay Post version 7.0.   Restore the latest backup available with you (before going to 7.5) and make dataentry for remaining days. Then, contact SDC with log files created.
6
Error while running Upgrade DB:  post : Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.
This issue was due to user database having different collation settings in databases. The below query needs to be executed in databases having collation issue using SQL  Query Analyzer.
ALTER DATABASE [POST] COLLATE SQL_Latin1_General_CP1_CI_AS
7
Rs. 50000 denomination is not available  in KVP DE Module
Pl run the patch (1) released on 28.01.2014 in our SDC site
8
Error : "Amount doesn't tally" while issuing NSC IX through cheque in Online module
Pl run the patch (1) released on 28.01.2014 in our SDC site 
9
In certificate Data Entry Module, KVP & NSC is not working.
Pl run the patch (1) released on 28.01.2014 in our SDC site 
10
While runnning "upgrade_DB" tool,  error: Processing XXXX….
XXXX: Database changes related to NSC IX deployed sucessfully
XXXX: Database changes related to NSC IX not deployed sucessfully
Click "Restore to Previous Version" button. Then check whether you are having more than one entry for this sub office  in "sodb_name" table of POST database. If so, remove one of the entry after obtaining prior permission from concerned authority. Try to run the tool again.
11
While runnning "upgrade_DB" tool,  error: Processing POST
POST: Database changes related to NSC IX deployed sucessfully
POST: Database changes related to NSC IX not deployed sucessfully
Click "Restore to Previous Version" button. Then check whether you are having any entry like'POST' in "sodb_name" table of POST database. If so, remove that entry after obtaining prior permission from concerned authority. Try to run the tool again.
12
Error: "You are not authorised to login" in Certificate DE Module
This issue was due to unsuccessful upgradation of one or more databases . Follow the instructions given at Sl.No:4.
13
NSC IX Agent Commission , TDS - not shown while generating Agent Commission Report
Initialize the commission details -- through Initialization >>>Init comisn ,TDS amt (Form no 0412) by logging in as SUPER and then try to generate reports.
14
Multiple user in Data Entry Module(Error: Invalid Regn No).  For Ex: You are having 15000 KVP regn numbers to enter and ready to deploy 5 persons to complete this work by allotting regn no as 1 to 3000 for user1, 3001 to 6000 for user2 and so on.
Login as DESUPER>>> Certificates Single Entry>>> Initialisation >>>Account Number>>> Add ; Enter the details as 'Starting-1' , 'Ending-3000', 'Latest -0' . Then, add one more row and enter the details as 'Starting - 3001', 'Ending-6000', 'Latest-3000'  and so on. This will solve your problem.
15
Invalid Column name "aadhar_id"
Pl check whether you have run "upgrade_DB' successfully without any error.
16
Arithmatic Overflow Occurred (while doing NREGS Credit Entry)
Patch (SP_UpgradeNREGAEMO_fix_04Feb2014) has been released in our SDC Site.
17
Missing tables like "usp_indexreg" etc
"update_sp" ( available in SDC site under known issues - patches)
18
Processing POST
POST: Database changes related to NSC IX not deployed sucessfully.Please rerun it.
Cannot insert the value NULL into column 'acrint', table 'POST.DCL.scs_ledger'; column does not allow nulls. UPDATE fails.
Click on "Restore to Previous Version". If forgot to do this, Uninstall Sanchay Post version7.5 & install Sanchay Post version 7.0.   Restore the latest backup available with you (before going to 7.5) and make dataentry for remaining days.                                                          Also, check in latest DBAnalyser >>> Database Discrepancy / CBS Additional Discrepancy 1 / CBS Additional Discrepancy II  >>> POST>>> SCS. If any discrepancies found under any category, correct them with the help of solution document and try to run "upgrade_DB" again. (Same procedure may be applicable to SO databases)
19
Invalid object name 'DCL.Udf_TotalDays'
Go to control Panel - PROGRAMS & FEATURES. Uninstall Sanchay Post 7.5.

Install Sanchay Post 7.5 again.

DO NOT run UPGRADE DB again.
20
POST : Cannot insert the value NULL into column 'scheme', table 'POST.DCL.dataexp_soho_filelog'; column does not allow nulls. UPDATE fails
Click on "Restore to Previous Version". If forgot to do this, Uninstall Sanchay Post version7.5 & install Sanchay Post version 7.0.   Restore the latest backup available with you (before going to 7.5) and make dataentry for remaining days.                Check whether any value as "NULL" under column 'scheme' in table 'post.dcl.dataexp_soho_filelog'. If so, update it after obtaining prior permission from concerned authority. Try to run 'Upgrade_DB' again (Same procedure may be applicable to SO databases)
21
Problems in SOSB reports
Patch 2 dated 19.02.2014 has to be installed (available in SDC site)
22
System Hanging Problem in Sanchay Post Version 7.5 Data Entry Module
Patch 2 dated 19.02.2014 has to be installed (available in SDC site)
23
NREGA FTO Print Problem (s)
Patch 2 dated 19.02.2014 has to be installed (available in SDC site)
24
Slow NREGA FTO Process
Patch 2 dated 19.02.2014 has to be installed (available in SDC site)
25
Provision for additional ID Proof(s) for NSC IX issue
Patch 2 dated 19.02.2014 has to be installed (available in SDC site)
26
Data not getting saved in SQL 2008 Express Edition
Run DBAnalyzer(use latest exe). Select 'DBUtilities' option. Select 'Update to SQL 2000/2005' option. Enter SA password and click on 'ok'. Select the databases one by one and click on 'Update' and wait till the message 'Updated successfully' is displayed.    (OR)
Stop SQL Server agent. Then try to move the files (mdf / ldf files or dat files) of your POST database to a different folder from the folder where it is existing. Then, start SQL server agent and try to attach the files using 'attach database' option.
You can also try attaching it without the ldf file if the first option does not work.  
(OR)
Take the backup of all databases . Uninstall SQL 2008 Express Edition. Reinstall SQL 2008 Express Edition again with server collation  as "SQL_Latin1_General_CP1_CI_AS". Restore all the backup(s). If any problem, contact SDC. (044 - 28524482)
27
OSQL error while upgrading DB
Check whether "SCS_Principal_Amount_Int_post.csv"  file is available or not in /SP5/UpgradeDB folder. If not, check whether COMMAND PROMPT (Start>>>Run>>>cmd) is working in your server. If not, rectify the problem first with the support of your Technical team & contact SDC.
28
Problem in  Installation of patches
Check whether COMMAND PROMPT (Start>>>Run>>>cmd) is working in your server. If not, rectify the problem first with the support of your Technical team & contact SDC.
Patch 1 dtd 28.01.2014 has to be installed in all systems in which Sanchay Post Version 7.5 was insatlled.  
Patch 2 dtd 19.02.2014 has to be installed in all systems in which Sanchay Post Version 7.5 was insatlled. 
Patch (SP_UpgradeNREGAEMO_fix_04Feb2014) - has to be run only once ie, in SERVER (not in all clients)

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

[ https://drive.google.com/folderview?id=0B25bTWT2-kXgYlF2UTFpX1I4a0U&usp]

No comments:

Post a Comment


Dont forget to post your comments. Your comments and suggestions are valuable to us