Friday, January 31, 2014

Just for Info : HDMS - how to use CEPT Help desk

Tutorial for Help Desk Management System

Help Desk Management System (HDMS) launched from 10.1.2014.

Login Screen for HDMS 

  • Once User has been created in HDMS website Login Using cept.gov.in
  • Enter your Registered HDMS User name and Password.

Main Screen 

Main Screen of HDMS website is Employee corner contains many useful Link Meghdoot, Speed Net, E-services, website link and Downloads.
  1. HDMS Web link was given in Support Link.
  2. To goto HDMS Main page click on Support Link from your home page.

HDMS Home page

After Click on Support link it moves to HDMS Home page.

HDMS: User Manual for Ticket Raiser
After logging into the CEPT website please click on the Support Menu. The Menus appearing in the subsequent page and its functionality are as follows:
i. Home : Self explanatory.

ii. Add Ticket : To register a ticket. Please ensure correct particulars. Please ensure furnishing of all relevant details to avoid any suspension of the ticket by CEPT support team.

iii. Pending Ticket : To view / Remind the pending tickets. In case the tickets are suspended by the CEPT for want of any additional information, please respond to it.

iv. Closed Ticket : To see / reopen the closed tickets. The ticket wise feedback can also be given.

v. Search Ticket : To search a particular ticket. The tickets registered by the user concerned shall only be available for search. The tickets can be searched with the ticket number only.

vi. Feedback : To provide feedback by the user on the application as a whole. Users are encouraged to provide feedbacks.

vii. Back : To go to the main menu of the CEPT website.
Once Ticket was raised using Add ticket, Ticket number has been generated for feature reference.
Using Ticket number you can track the status of ticket.

Once Ticket has been raised

  1. You can Remind the Ticket if no response was received from CEPT.
  2. You can Reopen the Ticket if you are not satisfied/ issues in Solution.
  3. You can provide Feedback for the closed ticket. 

Sanchay Post 7.5 Patch 1 dated 28.01.2014 by Infosys

Patch 1 for Sanchay Post 7.5

Download

Download

Steps for installation

a)  Close/Exit all screens in SanchayPost 7.5 application.  Make sure that application is not running.
b) Click on “Patch 1 for SanchayPost 7.5.msp” file.

Click on “Next” button.


c)



Click the “Update” button.

d)



Click on “Yes” button.



e)



Click on “Finish” button.

Your “Patch 1 for SanchayPost 7.5” installation is complete now.

Sanchay Post Version 7.5 Issues and Solution dated 30.01.14

Sanchay Post 7.5 Solutions dated 30.01.2014

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 1

Issue 

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

Solution

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 .If any irrelevant entry in that table, pl remove the same after obtaining prior permission from concerned authority.

Download(Missing table)

S.No 2

Issue 

Invalid object name 'dcl.misc' / table missing : 'dcl.misc'

Solution 

"update_report" ( available in SDC site under known issues - patches)
Download (Update Report)

S.No 3

Issue 

Problems in Intialisation in the DE certificates/ working in DE Module

Solution 

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.

S.No 4

Issue

Error while running Upgrade DB:  Invalid object name 'dcl.temp_scs_ledger' . The object 'PK__accountopen_thro__2077C861' is dependent on column 'scheme'.

Solution 

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. 

S.No 5

Issue

Error While Upgrading DB : But forgot to click "Restore to Previous version" and continued with Sanchay Post Version 7.5. 

Solution 

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.

S.No 6

Issue

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.

Solution 

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

S.No 7

Issue

Rs. 50000 denomination is not available  in KVP DE Module

Solution 

Pl run the patch (1) released on 28.01.2014 in our SDC site

Download (Patch 1)

S.No 8

Issue

Error : "Amount doesn't tally" while issuing NSC IX through cheque in Online module

Solution 

Pl run the patch (1) released on 28.01.2014 in our SDC site

S.No 9

Issue

In certificate Data Entry Module, KVP & NSC is not working.

Solution 

Pl run the patch (1) released on 28.01.2014 in our SDC site

S.No 10

Issue

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

Solution 

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. 

S.No 11

Issue

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

Solution 

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. 

S.No 12

Issue

Error: "You are not authorised to login" in Certificate DE Module

Solution 

This issue was due to unsuccessful upgradation of one or more databases . Follow the instructions given at Sl.No:4. 

S.No 13

Issue

NSC IX Agent Commission , TDS - not shown while generating Agent Commission Report

Solution 

Initialize the commission details -- through Initialization >>>Init comisn ,TDS amt (Form no 0412) by logging in as SUPER and then try to generate reports.

S.No 14

Issue

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.

Solution 

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.