Back
3. Client-Server Connectivity Issues
3.3 Connectivity issues due to Database Corruption after Power Failure.
Unable to close Customer Session

Scenarios where the issue occurs:-

The Scenarios where this issue can occur are as follows:

  • Server PC abnormally restarted/shutdown during application session because of the following:
    1. Power Failure.
    2. User/Administrator restarted/shutdown the system directly without closing the server application.
    3. System restarted or shut down abnormally because of hardware failure.
How to Identify the issue:-

Steps that help us to identify the issue are as follows:

  1. While closing customer’s session error displays “Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately”. To see the screen shot click these links (i) http://www.mediafire.com/i/?9qtwavnmaskoxz1 , (ii) http://www.mediafire.com/i/?bsptc1goy2ptbd2 ,(iii) http://www.mediafire.com/i/?eop0my9y9mzexi2 .
  2. When you click for add a Product/Service Sale error displays “Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately”. To see the screen shot click this link http://www.mediafire.com/i/?s9l0v274bnbwk22 .

Solution Provided:-
Steps to resolve the issue are as follows:

  1. While closing the Cafe Manager Console take the backup of the database.
  2. Open the Database folder which is located at “C:/Program Files/iCafeManager/Server/Database”. ( default location if windows in c: drive)
  3. Now Open the CCM.C3M file and follow the below mentioned steps:
    1. For Office 2003
      1. Go to Tools ->Database Utilities->Compact and Repair Database
      2. This will help us remove all the invalid entries and establish the relationship between the tables.
    2. For Office 2007
      1. File (MS Office Logo) ->Manage ->Compact and Repair Database
      2. This will help us remove all the invalid entries and establish the relationship between the tables.
  4. Now open the Cafe Manager Console check by closing Customer’s Session or Try to clinck on Add a Product/Service Sale. If still facing issue then go for next steps.
  5. Now go to Products & Services and check for any invalid entry exist then go for next steps, to see the screen shot click this link http://www.mediafire.com/i/?gtblo59wbvug65d
  6. Because of wrong ItemTypeId entry code which was generated in tItem table of Database and also the SubmitDt there is no submitted date showing. To see the screen shot click this link http://www.mediafire.com/i/?fft6jdl7wf6bupq .
  7.  ItemTypeId entry code for Product is 1 and for Service is 2 so since this was added as a product we will have to set 1 ItemTypeId entry and also will have to set SubmitDt( date of purchasing product).
  8. Now open the Cafe Manager Console check by closing Customer’s Session or Try to clinck on Add a Product/Service Sale.   This will resolve the above given issue.
    Note: to download the db for better understanding of issue to go this link http://www.mediafire.com/?9oci54g4m8eswok .