Saturday, August 20, 2011

DB Analyzer dated 18/08/2011

DB Analyzer dated 18/08/2011

Posted: 19 Aug 2011 09:48 AM PDT

Recent additions in DBAnalyzer
1. Reports - BPL Accounts
2. Agreement - Sanchay Post & V2SBCO data
3. Miscellaneous - Balance Verification List for RD accounts
4. Database Discrepancies - PPF - HUF Accounts (3 reports)
5. Reports - Signatures exceeding 150 kb
6. Reports - List of Live RD Accounts allotted to Closed Agents
7. Separate LoT for NREGS / IGNOAPS / IGNWPS / IGNDPS for HO & SOs

Download

You are subscribed to email updates fro

Friday, August 19, 2011

Solution for Error in loading DLL.doc

Dear System Administrator,

Re-Register the required Dao360.dll file and the Msado15.dll file

You may have to register the Dao360.dll file and the Msado15.dll file by using the Regsvr32.exe program. To do this, follow these steps:

1. Click Start, and then click Run.

2. In the Run dialog box, type the following commands in the Open box, and then click OK:

Regsvr32.exe "<>"
Regsvr32.exe "<>"

The <> placeholder is the absolute path of the Dao360.dll file.

The<> placeholder is the absolute path of the Msado15.dll file.

The following examples show how you may specify an absolute path:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"

If the Dao360.dll file is successfully registered, you receive a message that is similar to the following message:

DllRegisterServer in C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll succeeded.



If the Msado15.dll file is successfully registered, you receive a message that is similar to the following message:

DllRegisterServer in C:\Program Files\Common Files\system\ado\Msado15.dll succeeded.

3. Click OK.

Tuesday, August 16, 2011

Meghdoot 7.0 - Point Of Sale - Circle Master Updation error

Meghdoot 7.0 - Point Of Sale - Circle Master Updation error

0 comments






Problem:
After Up gradation of Meghdoot 7.0

While choosing the Circle name in POS->Super-> Environment the circle name is not available.

Solution:
Please Download the attached file Update Circle and Barcode Number Prefix Data Updation.exe


Run the exe file and provide the Point of Sale SQL server name
Login as supervisor to Point of Sale and
go to menu My Office -> Environment, then
Select your Circle Name.

-
With Regards

Help Desk

THANKS TO : sapost.blogspot.com

Issue in eMOClient setup Installation (meghdoot version 7.0)

Issue in eMOClient setup Installation (meghdoot version 7.0)

0 comments






Issue in eMOClient setup Installation (meghdoot version 7.0)

The offices where installation done from new emoclient setup has reported some errors in receiving emos.

Such offices may replace existing eMOClient exe with eMOClient.exe available in ftp://ftp.ptcinfo.org/Meghdoot7/Updates/eMO/ Then they need to request for resend emos through divisional administrator web login.


With Regards

Help Desk, PTC

THANKS TO : sapost.blogspot.com

Thursday, August 11, 2011

MEGHDOOT MODULES PROBLEMS AND SOLUATIONS

Problem: RPLI transactions cannot be booked.Solution:


1. Problem: ‘Stored procedure missing’ error or ‘too many arguments specified’ error while doing Submit Account.Solution: Ecounter, EMO and counter database upgradation has to be done in a sequence. If the sequence is not followed, this error will appear. Upgrade Ecounter, then EMO and then do counter upgradation.

3. 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 followingRegister the dll by entering the following in the Run dialog box window.(Start - Run)Regsvr32 ApplicationPath\dllnameeg.Regsvr32 H:\POS\cash.dll

4. While doing submit accounts ‘Server not configured for RPC’Solution: Run the following query using query analyzer (replace ‘myserver’ with your server name):exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'goexec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'goNote: The above error is related to SQL Server configuration settings and not related to the application. (RPC is Remote Procedure Call).

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

6. While booking MO Videsh, Countries and currencies are not coming Solution : Download the below file and apply.Download

7. While performing Day End the following error is encountered:‘Multiple step operation generated errors. Check each status value’Solution: Download the zip file. Unzip it and follow the instruction given in readme.

8. Invalid object name 'ECounter..ENVIRONMENT'.Solution : Upgrade eCounter database9. Point of sale Day end error while sending DET.If there is an error of Point Of Sale dayend, while sending the Accounts MIS download the below exl file and run it. After that try to transmit the data. Download


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 (replace ‘myserver’ with your server name):exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'goexec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'goNote: The above error is related to SQL Server configuration settings and not related to the application.

2. Accounts Heads not comingSolution: Please run treasury130410.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. eg: if the date is 06/04/2010 then ddmmyy will be 060410After that prepare the HO summary afresh


DESPATCH
1. While performing Day End the following error is encountered:‘Multiple step operation generated errors. Check each status value’Solution: 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. Fetch local articles for delivery through Postman module. The data will be correctly reflected 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 day only.In such a situation, even if you don’t fetch today, all these local articles will be treated as "Despatched" in DET. Hence please use the Fetch from Counter option on the date of invoicing the articles to postman.

SUB ACCOUNTS
Day end in SubAccounts the error is ---------------------------SubAccounts---------------------------Run-time error '-2147217900 (80040e14)': [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'pliotl'.---------------------------
Solution: Pl. download the attached file http://www.sendspace.com/file/39m2e1 and run with script tool executor.. After this.. Please execute the query mentioned below in SQL Query Analyzer ... in Treasury databaseupdate_megh66_accountheads_bydate '030510' Perform Day Begin .... for 04th May ...Pl. also check the option 'Convert Temporary Fields' under tools menu through supervisory login .. If the missing heads are listed, then make them permanent ...

2. For any type of error not covered in the above paras please 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 CEPT.

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.

2. All EDSOs are downgraded to BOs; How eMOs for these offices will be handled .Concerned divisions are expected to give the new PIN Code info in respect of these offices, so that the PIN Code database is updated. Presently we are getting many faxes asking us to change the pincode of payee/remitter (wrong pincode). In order to tide over this problem, two options are provided to Divisional administrators 'Change the Payee Pincode' and 'Change Remitter Pincode' under Tools Menu.

eMO MIS The new URL for eMO MIS is https://services.ptcmysore.gov.in/emomis The complete details of eMO not received, eMO not Printed and eMO not Paid are available for analysis. You are requested to please login and check the status of eMO on daily basis. The legacy data of eMO must be updated before 10.12.2010. If any problem or pending eMO not coming in disaster paid entry then please follow the following instructions:-
1. Please download the latest exe available at ftp://ftp.ptcinfo.org/Meghdootv6.6/Updates/eMO/ .
Download the file eMOupdate.zip , unzip the file and follow the procedure detailed in the readme.txt file.
2.Please download the file emodr.exl from http://www.sendspace.com/file/39lbwy . Execute the script file using script tool. Apply for disaster request through emo supervisor and run emo client. once files are received, update details through disaster paid entry option of emo operator and then later do disaster paid verification in emo supervisor.
3. If the problem is not solved after following the steps detailed above, please forward the eMO database backup with TXD/RXD folders and PNR details for analysis to PTC, Mysore (ptcdesk@gmail.com) under copy to this office.

SCHEDULE AND MEGHDOOT-NICPLI
1. Error Screen shot :Solution: Use the latest Schedule.exe dated 13.04.2010

2. Error Screen shot:Solution: Please re-run the application.

3. Error screen shot:Solution: Download the csv files from NIC website again. Upgrade the NICPLI database using Service Pack 1. After that upgrade the schedule database. Use new Meghdoot-NIC PLI Bridge software and then transfer the records from the files.While transferring the records, first select the “Delete old records and insert new records” option button, transfer records and then subsequently select “Append records” option button for transferring other types of master records.

4. Error Screen short Solution: Until the cashbook is generated, you will not be able to see the account heads and consequently, you will not be able to tally the cashbook. So, generate the cashbook and then generate the schedule.

5. Premium cannot be edited in the Schedule module’s transaction screen.Solution: According to the requirements premium is not editable for the policies which are available in the NICPLI database. If the premium in the NICPLI database itself is wrong, then what should be done - this issue is under correspondence with PLI Directorate. Only After clarification from the PLI Directorate, this issue will be resolved.

6. Default fee and Rebate are not coming in the Premium Report:Solution: As per the Directorate orders, Default fee and Rebate will come in separate report. Default fee will come in ‘Other Than Premium’ Report on receipt side and Rebate will come in ‘Rebate’ report on payment side.

7. Account head is not seen while going for generation of Premium report.Solution: Since there have been major changes in the account heads, the restriction of tallying schedule with cashbook has been removed and you will get straight away the report of premium transactions for the selected period as it is from schedule database. This report is not tallied with the cashbook. You will have to make sure that it is tallied with the cashbook. The same holds good for Other Than Premium and Rebate report.And also, during the generation of CSV file, Premium transaction will not be asked to tally with the cashbook. They will come as it is from the schedule database in the finally generated csv file. You should make sure that these transactions are tallied with the cashbook. Note: During this month, the new heads and the old heads are coexisting & it is not feasible to tally the schedules with the cashbook through the system. From next month onwards, it is proposed to reintroduce the condition of tallying with the cashbook.

8. Screenshot:Solution: Re-download the csv files from nic website.Upgrade the NICPLI and then Schedule database using latest service pack. Transfer the files using new Meghdoot-NICPLI Bridge software. Use new schedule.exe
NPS Error During the booking of new registration for NPS amount does not shown. amount shows "0". SolutionExecute the following command in Query analyzer afer selecting counter database.S_Insert_ServiceChargeForNPS

Accounts MIS File Transmission Error
SolutionCopy the certificate and Registercacft.exe available in the emo installation folder to the accounts mis client installation folder and double click on "REgistercacft.exe". It will solve your problem

Point of Sale – MO Amount and Commission Show (Black) in Windows 7 & Windows VistaOpen the start menu and type Theme Then click Change ThemeChoose the Windows Classic theme and it will automatically apply


Sanchay Post
1. Login failed for user Arrow in Project database (While upgradation of SP R2) or If you recieve error code "Z" If you check the status in DB Analyzer Please Download the Arrow.exe, double click the Arrow.exe and input the login details and press ok. Download Arrow.exeCourtesy : http://andheriho.blogspot.com/




Schedule exe (10/08/2010) is available at PTC ftp site.. ( Download )Problem Solved:Problem of calculation of fractional pli/rpli amount, is rectified in schedule module. Accounts Updates 28/07/2010 : A latest accfix.exe and Account.exe for solving the problem of duplicate records shown in Increment Register is available below.Download and upgrdate the account database by running accountsfix.exe, replace the accounts exe.




F.A.Q. on Meghdoot AccountsMIS Client Application

Error Solution
1 Error message ‘Could not establish secured connectivity ssl/tsl error
Copy the certificate and Registercacft.exe available in the emo installation folder to the accounts mis client installation folder and double click on REgistercacft.exe

2. Unable to continue due to the following error
There is a problem with SQL Server
Could not find procedure arrow_get_data.
This problem is coming due to non upgradation of Treasury database. Upgrade it to Meghdoot 6.6 SP1 by following the procedure.

3 Unable to continue due to the following error
There is some application error
AccountHead Tables not available.
Subaccounts activity did not happen properly or proper date of transaction is not selected

4 There is some error Already Arrow Project information file is available.
Re generating the information is not allowed.
Use the transmit pending files option and then the files will be transmitted.

5 Unable to continue due to the following error..
There is a problem with SQL Server Ambiguous column name 'socode'
please upgrade the treasury database once again. The database is not upgraded properly.


6 Day end not happened in Sanchay Post
Please ensure that Sanchay Post 6.5 with all latest patches is installed. The project database will be updated from the date on which all Sanchaypost patches are installed as stated above.

7 Day end not happened in Point of Sale/Postman/Despatch/ Treasury
Day End in these modules is compulsory before running AccountsMIS for any Date

9 Error in communication “remote name could not be resolved”
This problem is due to problem in internet connectivity, please check the connectivity at your end.

10AccountsMISCommn-sendData1A :Error in Transmitting file in txd.
Please search and delete the file trxcheck.log from your system and then transmit the files.

11 Accounts MIS Error in communication Index was outside the bounds of the array.
Please check Log file to see whether there are any other specific errors.
Delete all the files available in data folder and re-generate the files once again selecting the transaction date.

12
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
If you are using sql server 2005 enable named pipes.
Go to SQL Server Configuration Manager in Configuration Tools
Select SQL Native Client Configuration Then Select Client Protocols In that check whether TCP/IP and Named Pipes are enabled or not. If not enabled then enable them.

13 Sub Query returned more than one value
Please forward the backup of Treasury database to PTC Mysore [Applicable in the case of HO only]

14 The required resource can't be accessed.
access to path C:\ProgramFiles\PTC Mysore\AccountsMIS Client Setup\AccountHeads.xml' is denied. The windows user is not having permission to access the file. Please give proper permission for the user.


15 Time Out Expired
This error is related to SQL Server Connectivity or lack of response from the SQL Server. Please check SQL Server connectivity .

16 Error in communication Unable to connect to the remote server
Please check your internet connectivity.

17 One of the following dependency is missing.
The missing item is : Required folders in Project database.
This is a critical error
Please check up Log files to see whether there are any other specific errors.
This error is either due to the non availability of the project database or the relevant table in project database. Please contact SDC chennai for further guidance.

18 unable to continue-Object reference not set to an instance an object
Please use latest accountsMIS.exe available in ftp site in SP1 and provide proper information in configuration.

19 Underlying connection was closed
Please register the certificate. If still not solved copy the regcft.exe file from the MM 6.6 CD eMO client installation folder and register it once again.
AccountsMIS Client Setup & Patch
AccountsMIS Website LinkAccountsMIS Client Setup AccountsMIS Client Patches
Visit : http://sapost.blogspot.com/