Tuesday 2 December 2014

PARIVARTAN - IT Project Newsletter || First edition (Hindi)

PARIVARTAN - IT Project Newsletter || First edition (Hindi) : Click Here.

Improvement in efficiency of postal services

GOVERNMENT OF INDIA
MINISTRY OF  COMMUNICATION AND INFORMATION TECHNOLOGY
RAJYA SABHA
QUESTION NO  684

ANSWERED ON  28.11.2014



Improvement in efficiency of postal services

684  Shri A.U. Singh Deo

Will the Minister of COMMUNICATION AND INFORMATION TECHNOLOGY be pleased to satate :-
(a) whether Government has proposed plans to improve efficiency of postal services, if so, the details thereof;

(b) whether Government is planning any Public Private Partnership model in postal services, if so, the details thereof;

(c) if not, the reasons therefor;

(d) whether there is any proposal to raise employment in postal services for rural areas, if so, the details thereof; and

(e) if not, the reasons therefor?

ANSWER

THE MINISTER OF COMMUNICATIONS AND INFORMATION TECHNOLOGY
(SHRI RAVI SHANKAR PRASAD)

(a) Yes, Sir.

Performance of Post Offices is monitored on selected Key Performance Indicators (KPIs) on Mails, Savings Bank and Money Orders through a web based mechanism.

The Government has undertaken the following steps to improve efficiency of Postal Services by:

(i) Introduction of a Mail Network Optimization Project (MNOP), for consolidation and optimization of operational network.
(ii) Process redesigning at Speed Post Hubs and Intra Circle Hubs.
(iii) Strengthening of end –to-end online tracking system, resulting in increase in online tracking.
 (iv) Regular performance review of all Postal Circles.

(b) & (c) No Sir.


(d) & (e) There is no new proposal to raise fresh employment in postal services for Branch Post Offices situated in rural areas. In fact, whenever any vacancy arises in any Departmental cadre, irrespective of its location in rural area or urban area, the same is filled up as per the provisions of the Recruitment rules of that particular cadre. Till filling up of vacancy, the work of the post is managed by redistribution/combination of duties and temporary attachment of personnel from other Post offices etc.


There are sufficient numbers of sanctioned posts of Gramin Dak Sevak (GDS) employees in rural areas. In addition, the Department has recently directed for expeditious filling up of all vacant posts of Gramin Dak Sevak Branch Postmasters.

CANNOT CONNECT TO MDE DATABASE : MIGRATION

Can Not Connect To MDE Database

After Restore MDE Backup into Migration Server it may show the error message as cannot connect to MDE Database.

Solution

  • Download attached Tool from PoTools.(MDE Dcl Fix included.)
  • Enter Login Credentials of SQL Server in this Tool.
  • Execute the Tool using "Auto Fix for DCL " Button.
DCL User Auto Fix will Fix for BPRO, BPLOG, POST,SIGN, PROJECT, SOSB, NREGAEMO, MDE and MDE_SIGN databases.

Download

Download

Solution : Method 2

Fix MDE Login Issues Using DB Analyzer ( Thanks To Rajesh H)

Follow these steps
1. Open management studio. Right click on mde database. Rename as offline.
2. Open DB analyzer > DB utilities > Update to SQL 2005. Select database offline and update.
3. Re name offline database as MDE management studio.

Do same steps for mde_sign also.                 

ACCOUNTS MODULE UD REGISTER ERROR AND SOLUTION

Solution For Account UD Register Generation Error

While Generate Report for UD Register in Account Module  under Other Bill option it may show the below error message

Solution

  • Download Duplicate Delete Executor from PoTools.
  • Enter Accounts Server Name, then Execute to delete duplicate records.

Download

R NET COMMUNICATION ROOT ELEMENT IS MISSING

Root Element Is Missing : R Net Communication

R Net Communication configuration file may corrupt due to HDD issues or System may Suddenly down. while execute R Net Communication 
While Click on OK. Additional error may Show like below
Unhandled exception has occurred in your application. If you click continue the application will ignore this error and attempt to continue. If you click Quit,the application will close immediately.
Root element is missing

Solution

  • Download Configuration file generator.
  • Enter SQL Server name and Point of Sale Server Path.
  • Select R Net Communication path to Generate Config File on same location.

Download

SQL SERVER QUERY ANALYZER SHORTCUTS : SQL 2005 / 2008


SQL Server Query Analyzer Shortcuts

ShortcutFunctionShortcutFunction
ALT+BREAKCancel a queryCTRL+SHIFT+F2Clear all bookmarks
ALT+F1Database object informationCTRL+SHIFT+INSERTInsert a template
ALT+F4ExitCTRL+SHIFT+LMake selection lowercase
CTRL+ASelect allCTRL+SHIFT+MReplace template parameters
CTRL+BMove the splitterCTRL+SHIFT+POpen
CTRL+CCopyCTRL+SHIFT+RRemove comment
CTRL+DDisplay results in grid formatCTRL+SHIFT+SShow client statistics
CTRL+DeleteDelete through the end of the lineCTRL+SHIFT+TShow server trace
CTRL+EExecute queryCTRL+SHIFT+UMake selection uppercase
CTRL+FFindCTRL+TDisplay results in text format
CTRL+F2Insert/remove bookmarkCTRL+UChange database
CTRL+F4DisconnectCTRL+VPaste
CTRL+F5Parse query and check syntaxCTRL+WWindow selector
CTRL+GGo to lineCTRL+XDelete
CTRL+HReplaceCTRL+ZUndo
CTRL+IIndex Tuning WizardF1Help for Query Analyzer
CTRL+KDisplay/hide execution planF2Move to next bookmark
CTRL+LDisplay execution planF3Repeat last search
CTRL+NNew query windowF4Object Search
CTRL+OConnectF5Execute a query
CTRL+PPrintF6Switch between query and result panes
CTRL+RShow/Hide results paneF8Show/hide Object Browser
CTRL+SSaveSHIFT+F1Transact-SQL help
CTRL+SHIFT+0Show optionsSHIFT+F2Move to previous bookmark
CTRL+SHIFT+CComment out codeSHIFT+TABDecrease indent
CTRL+SHIFT+DELClear the active Editor paneSHIFT+F6Switch panes
CTRL+SHIFT+FSave results to fileTABIncrease indent