Tuesday 11 August 2015

INSTALLATION OF SANCHAY POST 7.5 WITH PATCHES ORDER WISE IN SECOND TIME

Installation Of Patches On Second Time/ Server Configuration

1) Uninstall Sanchay Post 7.5
2) Rename the SP5 folder as "SP5old"
3) Install Sanchay Post version 7.5 again (from the link given below)

4) DO NOT RUN upgrade DB

5) Install Service Pack 1 (from the link given below)

https://drive.google.com/folderview?id=0B25bTWT2-kXgdlcwVGE3clF4MEU&tid=0B25bTWT2-kXgZjZxMVk1cHQxOFE

6) DO NOT RUN UpgradeDB RD PPF

7) Install the revised patch 5 dated 07_Nov_2014 (given in the link )

8) Install Patch 6 dated 23-09-2014

9) Install Patch 8 dated 20-11-2014,

10) Do NOT run KVP Tool again

11) Install Patch 8.1

12) Install Patch 7 (available in SDC site )

13) Install Patch 10

14 ) Do NOT run SSA_Upgrade again

15) Install Patch 10.1

16) Do NOT run SSA_Deposit_Upgrade again

17) Install Patch 11

18) DO NOT run Patch11 upgrade again

19) Install Patch 12

20) DO NOT run Patch 12 Upgrade again

21) Install Patch 13

22) DO NOT run Patch 13 Upgrade again

EPAYMENT COMMUNICATION REGISTRATION ISSUES AND SOLUTION

EPayment Client Registration Issues

The latest version of ePayment Communication 7.9.2 was installed either in the non upgraded offices of ePayment(i.e Version not updated 7.9.2 of ePayment Client) offices or ePayment Re registered offices show the following error message.
"Some of your machine parameters have been changed, kindly contact divisional administrator to register the office" 

Solution

It was noticed that you have changed the machine. Now please do the following. 
1. Update new latest version of Version of ePayment v7.0.9.2 
2. Kindly check all the pending files inside RXD and Data folders are cleared. 
3. Run the attached .exl using script tool. 
4. Then call ePayment client.

Download


SPEED NET COMMUNICATION FILE TRANSMISSION ISSUES AND SOLUTION

SpeedNet Communication Transmission Issues

In Some of the Post offices having issues with Speed Net communication Module while transmitting the files / receiving the files from central server. Last Call status  of Speed Communication was updated in Speed Net MIS but the files neither transmit nor receive.

Solution

  1. Check the Internet connectivity if any i.e temporary internet problem.
  2. If Internet connectivity is OK then follow the below steps to overcome the above issues.
  3. Open the hosts file (c:\windows\system32\drivers\etc) 
  4. Check for an entry as shown like speednetmsg.ptcmysore.gov.in, If exists delete it.
  5. Add a fresh entry as shown below: 
103.244.127.226 speednetmsg.ptcmysore.gov.in
Save the hosts file on same location. Now Execute the Speed Net communication Module once again. 

POSTMAN STORED PROCEDURE ERROR AND SOLUTION

Stored Procedure Error Of Postman And Its Solution

Issues:

[Microsoft][ODBC SQL Server Driver] [ SQL Server] Could not find stored procedure a.  MO_Insert_WithBORemarks, b.  MO_Select_EnquiryFromBOArticlesTable,
c.  MO_Update_WithBORemarks,
d.  Par_Insert_BOArticles,
e.  Par_Insert_WithBORemarks,
f.  Par_Select_EnquiryFromBOArticlesTable,
g.  Par_Update_WithBORemarks,
h.  Reg_Insert_BOArticles,
i.  Reg_Insert_WithBORemarks,
j.  Reg_Select_EnquiryFromBOArticlesTable,
k.  Reg_Update_WithBORemarks,
l.  RegNet_Msg_BOArticlesDelivered,
m.  RegNet_Msg_BOArticlesUnDelivered,
n.  RegNet_Msg_BOParcelsDelivered,
o.  RegNet_Msg_BOParcelsUnDelivered

Solution

  1. Take backup of Postman Database and Kept it in Separately.
  2. Ensure that all the Modules related to Postman should be Closed.
  3. Execute the BOTransaction_date.exl which is available in MMUpdate8Solution folder.
  4. Then Execute all the updates upto Postman 7.9.2.

All the scripts were provided by CEPT, Admin PoTools is not responsible for data corruption.

CLARIFICATION REGARDING CBS FROM DIRECTORATE

1. It may please be clarified whether SB pay in slip is required to be collected OR NOT , when maturity amount of a scheme is transferred to SB account? It will be also be considered as NON CASH TRANSACTION.
Clarification-NOT REQUIRED
2. Similarly whether pay in slip is required to be collected from the agents when agent commission is automatically deposited to their SB accounts and these transactions will also be treated as non cash transaction?

Clarification-NOT REQUIRED

3. Agents are required to write AAR number on ACG-17 used for taking commission earned on investments made by them ( SB order no 6/2013 dated 25.04.2013). If it is not done, the investment will be treated as direct investment and commission will not be paid. In the CBS environment commission earned will be automatically credited to agent's SB account directly.

In these circumstances, Where the agent has to write AAR number?. No provision is also made in Account opening form to write AAR number by the agent. Provision to write AAR number is to be made in Account opening form.

Clarification-TAKING ACG-17 has not been discontinued yet.

Speed Net 4.3 Bill Generation Issues And CEPT Solution

Speed Net 4.3 Bill Generation Issues And CEPT Solution

Generation of Monthly Bills of BNPL Customers : Error during creation of XML invoice file. Error Details : -2147217900-[Microsoft][ODBC SQL Server Driver][SQL Server]
Stored procedure Error
Could not stored procedure 'POSPCC..AAK_Gen_XMLInvoice_For_Amazon'

Solution

  1. Download attached Script from PoTools which is given by CEPT.
  2. Execute using the MM Script Tool.
Pre-requisite : SQL 2005/2008

Download

Supreme Court refers Aadhar card matter to Constitution Bench

The Supreme Court today referred to a Constitution Bench a batch of petitions challenging the Centre's ambitious scheme to provide Aadhar card to all citizens and decide whether right to privacy is a fundamental right.

Allowing the Centre's plea, a three-judge bench comprising Justices J Chelameswar, S A Bobde and C Nagappan, framed various questions, including as to whether right to privacy is a fundamental right, to be decided by the larger Constitution Bench.

"If yes, then what would be contours of the right to privacy," the apex court said while referring the matter to Chief Justice H L Dattu for setting up the larger bench.

Attorney General Mukul Rohatgi, appearing for the Centre, had earlier said that the matters requires elaborate debate and an authoritative pronouncement in view of the fact that there have been inconsistent decisions as to whether right to privacy is a fundamental right.

He had cited two judgements, pronounced by six and eight- judge benches, which had held that right to privacy is not a fundamental right.

Subsequently, smaller benches had held contrary view and, hence this matter needed to be decided by a larger bench, AG had said.

"Whether right to privacy is a fundamental right guaranteed under Part III of the Constitution of India, in the light of express ratio to the contrary by an eight-judge bench in M P Sharma case and also by a six-judge bench of this court in Kharak Singh's case" has to be decided, he had said.

Earlier, the Centre had sought transfer of pleas against Aadhar to a larger bench, saying that a two-judge or a three- judge bench cannot decide it.

Referring to pronouncements made in historic cases like A K Gopalan, Maneka Gandhi and bank nationalisation, the top law officer had said that inconsistencies with regard to interpretation of certain fundamental rights can only be "squared up" by a larger bench.
Earlier, the government had opposed a plea seeking initiation of contempt proceedings against it, Reserve Bank of India (RBI) and others for allegedly insisting on Aadhar cards to grant benefits of various schemes to citizens, saying it was not mandatory.

In pursuance of earlier orders, the Centre has conveyed to states and authorities concerned not to make Aadhar cards, issued by Unique Identification Authority of India (UIDAI), mandatory for availing various schemes, Additional Solicitor General Pinky Anand had told the court.

The bench is hearing a batch of pleas against decisions of some states to make Aadhar cards compulsory for a range of activities including salary, provident fund disbursal, marriage and property registration.


The government had also said that persons, having Aadhar cards, were being asked to provide it to authorities but this was optional.


Senior advocate Gopal Subramanium, appearing for Mathew Thomas, one of the PIL petitioners, had filed an application seeking initiation of contempt proceedings against the Centre and others, including RBI, and the Election Commission.

He had alleged that the government and others were in violation of earlier orders that had said that no person should be denied any benefit or suffer for not having Aadhar cards.


Source : The Economic Times

SQL SERVER MANAGEMENT STUDIO KEYBOARD SHORTCUTS


Ctrl + A
select all
Ctrl + B
change list-box position
Ctrl + C
copy
Ctrl + D
clear text
Ctrl + E
Edit SQL using editor
Ctrl + F
find
Ctrl + G
show/hide data grid
Ctrl + H
view SQL history
Ctrl + I
go to line
Ctrl + L
lower case
Ctrl + M
capitalize text
Ctrl + N
open another SQL window
Ctrl + O
open query
Ctrl + P
print SQL
Ctrl + R
replace
Ctrl + S
save query
Ctrl + T
switch to another table
Ctrl + U
upper case
Ctrl + V
paste
Ctrl + X
cut
Ctrl + W
line wrap
Ctrl + Y
redo
Ctrl + Z
undo
Ctrl + F5
go to results window
Ctrl + F7
export to table
Ctrl + F11
comment text
Ctrl + F12
uncomment text
Ctrl + Shift + F5
search table
F1
help
F2
build column list for query table
F4
select current statement
F5
run SQL
F6
check syntax
F7
export data
F8
explain SQL
F9
display query table
F12
find matching bracket
Shift + F2
toggle bookmark
Shift + F3
next bookmark
Shift + F4
previous bookmark
Shift + F12
select to matching bracket
Shift + Delete
cut
Shift + Insertpaste