Problem in Printing eMO - Database Corrupted

Problem in Printing eMO (Database Corrupted) While printing the eMOS, an error occurs. The screen shot is shown. The error shows Attempt to fetch logical page in database eMO belongs to object eMO Inward not to object eMO Offices While checking the databases. The database is not in suspect state. While checking the Check db it shows There are some consistency errors.. Then I tried to repair the database with query. This worked for me The query for corrupted database(Not for Suspected database) with minimum data loss is given below DBCC checkdb(‘yourDBname’) ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE yourDBname SET MULTI_USER while While reporting the matter with PTC Mysore They give a solution. While running the exl file It completed with on error. While consulting the matter with PTC they replied thatIt can occur to some reasons like, network issue and excess size of log files. Please check for network connectivity. if everything is fine please try to shrink the database and check. While clearing the log file and restarting the server the query worked. COURTESY : SAPARAVUR Share and Care For Latest Updates Always visit http://satish24k.blogspot.in For Beautiful Wallpapers Always visit http://24ksatish.blogspot.in

Thanks to All, We are more than 1000 members now...

Hi Friends, we have created a Facebook group 'System Administrators DOP', which is exclusively meant for Postal Technological Issues. It gives us immense pleasure that we have more than 1000 members now. We are very much thankful to all for making this possible. The main purpose of this group is to solve technological problems we are facing in day-to-day work. Whenever you face any errors or facing difficulty in installation or updation of softwares please feel free to post your problems, we try our level best to give an earliest solution in this group. Please co-operate with us by adding Postal Friends to this group. To visit the group Click Here Share and Care For Latest Updates Always visit http://satish24k.blogspot.in For Beautiful Wallpapers Always visit http://24ksatish.blogspot.in

Troubleshooting Problems in Postal Applications - 8

Sanchay Post §     Online transactions – wrong entry of transactions-current day ·        If the operator enters wrong account number or wrong amount for a transaction, the Supervisor can initially pass the transaction and later use the ledger corrections option to correct the entry.  ·        In case of RD accounts, transaction itself can be deleted.  ·        If an account is wrongly transferred out, the same option can be used by the Supervisor to undo the transfer.  ·        Similarly, if a wrong account is closed, the Supervisor can undo the transaction using the ledger correction menu. §     Online transactions – wrong issue of certificates Correction of such wrong issue can be done only on the date of transaction and not on the subsequent days.  The Supervisor can use the option Cancel certificates, both in NSC and KVP to cancel the transaction.  However, the certificate that has already been marked as issued as per the transaction cannot be reused.  This certificate will have to be physically cancelled and forwarded to Postal accounts with the cancelled report Online transactions – correction of balance of a previous date There may arise situations where a transaction that has been performed on an earlier date needs to be corrected.  You may also have to correct a balance of an old date to restore an unaccounted transaction.  Sanchay Post provides an option called Balance correction and interest rectification to perform such corrections.  Currently Sanchay provides this option to all types of accounts except RD and SCS.  Three users are involved to perform this transaction – the operator, the SBCO PA and the Supervisor.  The procedure of correction is explained here with reference to SB accounts.  For corrections to other types, you can test this with the help of the instructor during training in the lab. The operator calls this form, enters the date of LOT and presses enter key. The transaction type frame appears.  The operator can either select Balance correction or Interest correction.  On such selection, press enter key and click Add button to get a row.  In this row, enter the account number and the date of transaction.  Sanchay Post will display the current balance in the account.  Enter the new balance that should come up after the correction and press Enter key.  The OBC type(Debit or credit) and the difference amount appears.  Enter the reason for the correction and click Send button.  The transaction will now move over to SBCO and not to Supervisor. The SBCO PA now has to login and select SB scheme.  On such selection, he has to choose whether the transaction belongs to counter or not.  Sanchay Post now displays a message of pending OBC.  He has to now click OK and in the next window, click the button OBC and IR.  Now, the SBCO PA has to enter the date for which correction is afforded, press Enter key, select whether the correction is Balance correction or Interest rectification and press Enter key again.  The transaction of correction sent by the operator is now available for agreement.  The SBCO PA has to click the check box Agreed, should save the change and exit. The Supervisor should now login to the Online transactions module, select the scheme and Balance and Interest correction option, call a new form, enter the date for which corrections were given, press enter key,  select the type of transaction and press enter key once again.  Sanchay Post will now display the corrected transaction duly agreed by the SBCO.  The Supervisor has no role to play but to merely send the transaction. The balance for the day stands corrected in the ledger card.  No corresponding debit or credit will appear in the current day’s LOT.  Such corrections are to be manually added for the day’s LOT currently. Online transactions – cheque realized and posted but bounced – Sometimes, an operator enters an out of account sent for realization as realized and posts it but finds that the cheque is actually bounced.  In such cases, the option Bounced cheque can be used to mark the cheque as bounced.  This will reverse the entry of deposit in the ledger card charging the dishonour fee. Online transactions – When selecting a form by Supervisor for passing, message ‘Form already taken up for processing’ appears In such situation, the Supervisor can use the Release stuck forms available in the Day begin/end group to solve the problem Online transactions – Account conversion when one of the joint depositors expires and balance is beyond single account limits in MIS In such cases, when the intimation of death is made known, use the Excess withdrawal option in the MIS group to return the balance beyond the limit.  Sanchay Post will recover excess portion of interest, if any, paid beyond the date of death.  After making payment of the excess withdrawal to the surviving depositor, the supervisor has to convert the account to single account using the Common – Account type conversion Online transactions – RD – Depositor of an account on inward transfer presents deposit in the transferee office before transfer In such cases, the operator has to use the option Write as unposted in RD group to accept the deposit and the same will appear in LOT.  When the accounted transferred to the office, the Supervisor has to use the option Regularise unposted in the same group, select the unposted transaction and enter the new account number for clearing the UP Online transactions – SB – cheque withdrawal – Old cheque is presented While doing the data entry, normally the unused cheques in the current series alone are normally initialized.  The customer or any other person may present a cheque in the SB account for withdrawal against which no initialization exists.  In such cases, the operator has to use the option Regularise old cheques to process the cheque Online transactions – Passbook printing If for any reason, the page in which printing is done is spoilt, cancel the printed page, use the tab Transaction from a date in the passbook printing window, enter account number and enter the date from which printout was taken in the current page spoiled and generate printout in a new page.  Now you will be able to correctly print the subsequent transactions later SOSB online – correction of wrong posting of transaction by operator Similar to the ledger corrections option in online transactions module, the supervisor while verifying SB or PPF LOT postings, can correct the postings using the Corrections option in the LOT verification window.  In case of SCS accounts Ledger correction option has to be used.  Also, as in the case of online transactions, use the Balance and interest corrections option to correct transactions of old date for SB, MIS, PPF and TD accounts Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/

Troubleshooting Problems in Postal Applications - 7

MO compilation §     Wrong entry of SO MO issue/paid data Delete the wrong entry and make correct entry afresh §     MO compilation entries of the past dates If the MO compilation work was not attended to for the past few dates and all such entries will have to be done on the current day, select the appropriate HO date (summary date) and the corresponding SO date correctly for making entries for the relevant dates.  If, after such entries, the total of value and commission figures for MO issue returns does not agree with the cash book figures, appropriate corrections will have to be carried out in the HO cash book using the menu Cash book – Edit MO commission. Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/

Troubleshooting Problems in Postal Applications - 5

Subaccounts §     To modify daily account data entry for the current day To either correct a wrong entry or to make corrections suggested by other branches, select the daily account concerned in the data entry menu and carry out suitable corrections making corresponding accounting adjustment to ensure that the balance reported in the daily account is not altered.  Such corrections can be carried out before the summary is printed for the day. §     To modify daily account data of a previous date If corrections are suggested by branches or otherwise, in the SO summary of a previous date, corrections should be done for the SO figures in the HO cash book using Adjustments option.  The correction should not have the effect of altering the CB. §     While viewing summary data an error “Sub query returned…” comes up and viewing and printing is not possible This error comes if the operator selects the daily account date wrongly using the option Additional DA in the daily account posting dialog box.  Approach the administrator to solve this problem.  The administrator will have to proceed as below ·        Ensure that all PAs and Supervisor have logged out of Subaccounts module ·        Please download the query titled Subqueryproblem.sql along with the concerned read me file ·        Please go through the readme file and understand the procedure for solving the problem ·        The administrator to login to server and open the SQL server query anyalyser ·        Select the database SUBACCOUNTS or BOSUBACCOUNTS if the problem relates to SO summary or BO summary respectively ·        Using the file – open menu, open the subqueryproblem.sql query and execute the query ·        On completion of execution of the query, select the menu File – New and in the New dialog box, select Blank query window and click OK button ·        In the new query window type the query “Execute  H_DeleteDuplicate  '2006/11/02'” where the date should be the date of SO/BO summary(HO/Account office date) and execute the query.  The date should be typed in YYYY/MM/DD format On completion of execution, inform the operators to continue working Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/

Troubleshooting Problems in Postal Applications - 4

SB cash §     Cancelling a cheque drawn In HOs, if cheques drawn are directly shown in the SB cash module and when the operator has made a wrong entry of a cheque drawn, such entry can be cancelled using the menu Tools – Edit Drawn from bank.  Such cancellation should be done by the operator before the submit account is performed and verified by the Supervisor.  In case such cheque is spoiled before issue and after cancellation, the treasury supervisor can be requested to mark the cheque as spoiled §     A cheque transferred by treasurer erroneously was received  The operator can return such cheque using the menu Tools – Returning cheques, select the appropriate cheque and click OK button.  The cheque transfer entry will now be reverted and becomes part of the treasurer’s balance Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/

Troubleshooting Problems in Postal Applications - 1

1.     Point of Sale §     Error in connection When the system where Point of sale in working is switched on or you run the application, if you get error ‘Error no. 52’ the reason is that the Point of Sale application is unable to connect to the server.  Try any of the following as solutions Ø  Check whether the Server is switched on and is running Ø  Check whether the hub is switched on Ø  Check whether the LAN connection of your system is working; This can be tested by observing whether the LAN connection icon is appearing in the taskbar; If this is not available, the LAN connection might have been disabled; Request the system administrator to enable the same Ø  Check whether the network cable connected to the network adapter is not snapped from the connector at the back of your system; If disconnected, please reconnect Ø  Check whether the network cable from your system is connected to one of the slots in the hub/switch remains firmly connected; Otherwise request the administrator to reconnect Ø  On completion of these checks and correcting the problem, if any, try to run the application again; If it does not work still, inform the administrator Ø  The administrator to check the following o   Check whether Point of Sale can run from any other system; If so, open the config.xml file in the path C:\Program files\Meghdoot Millennium Point of Sale folder and check whether the server name and share name of the server component as configured initially has not been altered; If you observe any alteration, enter the correct path, save changes and run the application o   If the above step does not work or you did not notice any change, Open the drive where the Point of Sale server component is installed and check whether the Server component is shared; If the sharing has been removed or the share name had been changed, share the folder again or change the share name; Also check the permission and ensure that it is not set to only ‘Read’; If you notice this change the permission appropriately §     If the error is ‘Application installation is not proper’ If this error is observed, chances are that either the Point of Sale server component is removed in the server or the Counter.mdb is removed from this folder.  The administrator should check these points.  If the Point of Sale server component had been removed from the server, the same can be reinstalled, the server component shared and the counter.mdb file can be copied from backup location to this folder.  While this is being attempted to, users should not try to connect to Point of Sale §     Printer not installed error When you run the Point of sale module, if this error comes up report this to the administrator.  The administrator to open the printers folder and check whether the default printer is available or deleted.  If deleted, the administrator can logoff as the current user and login as administrator and install the printer.  There is also a possibility that the network printer might have been set as default printer.  In such cases, set the local printer as the default printer to solve the problem. §     Username of counter PA does not appear at shift begin Approach the supervisor in such cases.  The Supervisor would not have either done the shift begin and allotted the work or the work allocation would not be from the time required.  The Supervisor should view the current allocation for the PA.  If the from time is a future time and the PA has to start working immediately, the Supervisor can use the tab delete in the work allocation screen, select the PA and delete the entry.  Now the Supervisor can again allot the work from the current time.  The PA can now go to his/her system, click the Refresh (…) button in the login screen and move ahead §     Username of counter PA does not appear at the end of shift In this case, the supervisor would have set the ending time of the shift of the PA earlier than the time required.  When the shift time is over the name of PA disappears and the PA will not be able to complete the work.  When this happens, the PA should inform the supervisor and the supervisor should use the Modify tab in the work allocation dialog box, select the user, click the OK button and in the subsequent frame, change the To time to a suitable time beyond the current setting and click OK button; Now the name of operator will appear in the login screen and the work can be continued. §     In transaction screen OK button appears instead of Print The Supervisor to login to Point of Sale, Click the menu Tools – Receipt printing and click Yes in the message box that follows §     Weighing scale not connected but unable to enter weight for articles Access the menu Tools and check whether the menu Weighing machine is checked.  If so, click the menu and in the confirmation message box click Yes to turn the weighing to manual mode.  Now, you can enter the weight for the articles booked manually in the transaction screen. §     Weighing scale is available but weight is not captured Check whether the weighing scale is switched on and turn it on.  If this does not solve the problem, check whether the data cable from the weighing scale has not been disconnected from the communication port on the back of the system.  If disconnected, reconnect and try to weight the article §     When transaction screen for booking articles is accessed, error message ‘Port already open’ pops up This error may be due to the fact that in the machine where Point of Sale is installed, modem is also connected and the modem is installed either in Communication Port 1 or the default setup value ‘all available ports’ is selected while installing modem.  The administrator should remove the modem and can re install the modem in the second port in the system. §     Printout and alignment of receipts not proper This may be due to change in the default settings of printer options for generating the receipts.  When such a situation arises, the counter PA should select the option Tools – Printer options and in the dialog box that follows, click on Default button to restore default configuration.  You can again open the dialog box and click on Test button to test the print out of receipt. Share and Care

For Latest Updates Always Visit http://satish24k.blogspot.com/