Sabka Dost....... India Post...... DISCLAIMER CERTIFICATE - All the information on this website is published in good faith and for general information purpose only. We do not make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information on our website is strictly at your own risk. And we will not be liable for any losses and damages in connection with the use of our website. From our website, you can visit other websites by following hyperlinks to these sites. While we strive to provide only links to useful and ethical websites, we have no control over the content and nature of these sites and the links to other websites do not imply a recommendation for all the content found on these sites. Please be also aware that when you leave our website, other sites may have different privacy policies

Monday, April 26, 2010

DET figure mismatch

Problem in fetching column no.7 and 51of data extraction toolPostman220410.exl

Point of Sale SP2

The following modification are done in the service pack 2 for PointOfSale6.6 attached herewith.

1.Rectified the error in RPLI receipt printing.
2.Rectified the error in submit account related to MTNL transactions.
3.Rectified the error in submit account related to EPP transactions.
4.FCCode and Register number are made mandatory for NPS transactions.
5.Validations for NPS transactions according to the selection of service type.
Download Here

Friday, April 23, 2010

POS Solution

Point of Sale DayEnd Problem
Download

Monday, April 19, 2010

Local Article DET Problem

If you are having any grievance regarding local articles, then pls run run the enclosed script using the script tool.This postman15042010.exl will eliminate the condition that you should use only one of the two options i.e.,either  fetch from counter option or take receipt using bag details. 
 
Hence after running this exl, you should take receipt of all the local articles using the Bag Details option on the next date.  The DET will not take the receipt of the articles fetched using the fetch from counter option.

Hence pls note that all the local articles should be taken receipt by using the Bag Details option hereafter.
Postman150410 patch Download the Postman150410.exe from here

Thursday, April 15, 2010

FAQ Meghdoot 6.6.1 (Service Pack-1)


Point of Sale
1.      RPLI transactions cannot be booked.
Solution: Do not enter Date Of Acceptance and Agent Code while doing RPLI transactions till a new service pack is supplied.
2.      Stored procedure missing error while doing submit account.
Solution: EMO database upgradation should be done before Counter upgradation. You should do emo database upgradation and then do the counter database upgradation.
3.      The following error log after counter database upgradation.
1. COUNTER
22:36:28:============================================
22:36:28:         SCRIPT EXECUTION DETAILS (counter)
22:36:28:============================================
22:36:29:[Column names in each table must be unique. Column name 'AgentCode' in table 'PostalLifeInsurance' is specified more than once.] : Script Execution Error : While executing statement ALTER TABLE PostalLifeInsurance ADD AgentCode nvarchar(15) NULL
22:36:29:[Column names in each table must be unique. Column name 'FirstYearPremium' in table 'PostalLifeInsurance' is specified more than once.] : Script Execution Error : While executing statement ALTER TABLE PostalLifeInsurance ADD FirstYearPremium money NULL
22:36:29:[Column names in each table must be unique. Column name 'DateOfAcceptance' in table 'PostalLifeInsurance' is specified more than once.] : Script Execution Error : While executing statement ALTER TABLE PostalLifeInsurance ADD DateOfAcceptance datetime

Solution: These error messages will come if counter database is upgraded twice. These error messages  can be ignored.
4.      Active X component cannot create object.
Solution: Reinstall the application after deleting the old installation cab files. If you are getting any error while registering the dlls then do the following

Register the dll by entering the following in the Run dialog box window.(Start - Run)
Regsvr32 ApplicationPath\dllname
eg.Regsvr32 H:\POS\cash.dll

5.      While doing submit accounts ‘Server not configured for RPC’
Solution: Run the following query using query analyzer
exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'
go

in the myserver replace the myserver with your servername.. It will solve the RPC problem

6.      While doing submit accounts error ‘Operation is not allowed when the object is closed’
Solution : Run Counter13042010.exl using script tool.

7.      While booking MO Videsh, Countries and currencies are not coming
Solution :  If countries, currencies are not coming in Movidesh booking then patch is available in ftp site...

8.      While performing Day End, Multiple step operation generated errors. Check each status value
Solution: Please download the zip file from http://www.sendspace.com/file/r7xz78. Unzip it and follow the instruction given in readme.
9.      Invalid object name 'ECounter..ENVIRONMENT'.
Solution : Upgrade eCounter database
TREASURY
1.      In treasury module while entry in postman returns error shown ‘POSTMAN DATA BASE IS NOT AVAILBLE QUITTING’

Solution:  Run the following query using query analyzer
exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'
go

in the myserver replace the myserver with your servername.. It will solve the RPC problem

2.      Accounts Heads not coming
Solution: Please run treasury1.exl using script tool.
After executing the script, run query analyzer and execute the following query selecting treasury database.
update_megh66_accountheads_bydate 'ddmmyy'
ddmmyy stands for the date on which account heads not appeared. ex: if the date is 06/04/2010 then ddmmyy will be 060410

DESPATCH
1.      While performing Day End, Multiple step operation generated errors. Check each status value
Solution: Please download the zip file from http://www.sendspace.com/file/r7xz78. Unzip it and follow the instruction given in readme.
2.      Station articles are not fetching in Despatch
Solution:  Local delivery / Station articles will not be fetched for despatch in the Despatch module.You can fetch local article for delivery through postman module. The data will be correctly fetched in DET.
POSTMAN
1.      Local articles are showing not sent out for delivery in DET
Solution:  The option "Fetch from Counter" should be used on the day of invoicing these articles to Postman beats.  For ex: If you have booked local articles today and you want them to be sent to beats on tomorrow, you should not use the Fetch from Counter option today.  This option to be exercised on the next dayonly.
In such a situation, even if you don’t fetch today, all these local articles will be treated as "Despatched" in DET.  Hence Pls use the Fetch from Counter option on the date of invoicing the articles to postman.
SUB ACCOUNTS
For any type of error coming after upgradation pl.do the following.
Restore the backup of Sub accounts, Sub Treasury, BO Sub accounts taken before upgradation....and continue your work till solution is provided by PTC.
eMO
1.      Object reference not set error while doing paid verification
Solution: Please ensure that eMO Account heads are created properly. SubAccount and SupplySubaccount databases are running and correct treasury server name is given while configuration. Ensure that Socodemapping is done correctly. Ensure that HOAccount date and SOaccount dates are entered correctly both in eMO operator and subaccount modules.

Saturday, April 10, 2010

Meghdoot 6.6 SP1 Solution

If countries, currencies are not coming in Movidesh booking then patch is available in ftp site...
Delete Duplicate Account Head in Subaccounts ( Change into Current Date = ‘yyyy-mm-dd’)

Use Subaccounts
EXECUTE [H_DeleteDuplicate] @TransDate = '2010-04-09'
For treasury problem :
Run the attached Treasury1.exl file using script tool. ( Download )
After executing the script, run query analyzer and execute the following query

Use Treasury
execute update_megh66_accountheads_bydate 'ddmmyy'

Note: ‘ddmmyy’ stands for the date on which account heads not appeared. ex: if the date is 09/04/2010 then ddmmyy will be 090410

For Accounts PBS Problem:

1. If u are getting the error while generating PLI file then

Please run the following query using query analyzer on NICPLI database
select * from NICPLI..NICMASTER where pliorrpli ='P'
see the results, If no record is returned , it means that there are no PLI record in ur NICPLI database and thus u are getting the BOF error. So u will have to transfer the pli records from master csv file, which u have downloaded from website, using bridge software and select "Delete old records and insert new records" option button. Then transfer rpli records using "Append records" option button.

2. If u are getting the error while generating RPLI file then
Please run the following querry using query analyzer on NICPLI database
select * from NICPLI..NICMASTER where pliorrpli ='R'
see the results, If no record is returned , it means that there are no RPLI record in ur NICPLI database and thus u are getting the BOF error.
>So u will have to transfer the pli records from master csv file, which u have downloaded from website, using bridge software and select "Delete old records and insert new records" option button. Then transfer rpli records using "Append records" option button."

Monday, April 5, 2010

All Download

All Downloads
All patches and scripts which may downloaded from here