DB Recovery Tool for Post Office

Database Recovery Tool for Post Offices by Dinesh- We can Recover suspected Databases like Accounts, eCounter, NICPLI, Postman, BPLOG,BPRO,POST, SIGN, PROJECT, SOSB, Counter, eMO, eMOBackup, Subaccounts,SupplySubaccounts, Subtreasury, Treasury, Schedule, POSPCC, POSPCC Backup.

It helps you to recover you corrupt SQL database using queries mentioned in it. A backup is obviously preferred but if that doesn't work, this tool may help you! Click here to download it or click here for latest updates.

Download link:  DOWNLOAD



Collected from :POTOOLS
Thanks to:

Dinesh Kumar Asotra
Contact No.: 94181-79515

NL_Upgradation error

 I went to upgrade the Sanchaypost Version to a Sub Post Office. I faced one error at the time of Negative List up gradation. I sent message to SDC. They have given me one solution and it has solved my problem.

                                                       Negative List Up gradation Error

         

 Solution Patch: DOWNLOAD

 

Procedure: Unzip the Solution patch and copy it to DBAnalyzer folder and run it from the same location. Then run the latest Negative list patch from the website. This will solve your problem.

USB Printing for Meghdoot Millennium

Meghdoot Millennium Applications Software’s Support USB Printing.
 Most of us are not aware of this . Some of the servers available with
 Post offices only support usb printing. They does not have LPT1
 or COM Ports.Yesterday in one of my office solved this USB printing problem with a simple tweak.

For USB Printing

To enable USB Printing for Meghdoot Applications. First Install
 the printer with USB port. We can select the port by arrow
 keys while installing. Or we can configure the port after installation of printer in LPT.

eMO Client Error??? Error no 701 Login failed for user NRega

While running the emo client in update 5 and 6 an error or message occurs. It shows that "Cannot open database requested in login NREGAEMO. Login failed for user NREGA". While sending this error . The solution provided by CEPT mysore is given below.

Click here to download solution
Unzip the file and copy it to DBAnalyzer folder and run it from the same location. This will solve your problem.

NB. Please backup the database before running the solution

Repair Suspected Database

Repairing Suspect SQL Database

I'm not a DBA but I have a real life experience repairing a suspect databases twice. I guess I can say that I was unlucky at that time as I was presented in a tough situation where I was still in the process of learning how things work and we didn't have a DBA resource (remember I am a developer), but still consider it lucky as even some experienced DBAs might not have even experienced this situation. I experienced a similar situation before, and restoring it was easy before as we have, but that was easier as I have the proper restore points.

Now in this situation, the backups had failed so the last clean backup we had was 2 weeks old, so I could only rely on that one plus the current transaction log which is not backed up for now. So the first thing that came to my mind was to backup the transaction log so I could easily restore the full lot. I tried to backup the transaction log, but I had to remove the suspect status first by running this TSQL:

Collapse | Copy Code

sp_resetstatus 

Now it was not a suspect anymore, I was hoping to run the backup of transaction log by using this TSQL:

Collapse | Copy Code

UPDATE-3 POSTMAN NAME CHANGE ERROR

After update  Meghdoot7.0 with  Update 3 if you modify  Postman name in Supervisor. The postman name appears twice while taking returns (Old Postman Name+New Postman Name). Because of this bug day end cannot be done. Now CEPT MYsore has Provided two exl to solve this issue, One Exe and Two dll to solve this issue.

DOWNLOAD