Back
3. Client-Server Connectivity Issues
3.3 Connectivity issues due to Database Corruption after Power Failure.
Unhandled exception error on server if Customer Session Pending

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:

As soon as the iCM server application logged in throws error message “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.”

After correctly closing a particular user’s session (registered user/member/user), when we try to login another user error comes “previous customer’s session is pending”

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 if getting the error again then follow the steps given below
  5. Set active entries which are inactive from Complete Invoice in tInvoice table of Database.
  6. Now close Database and open the Cafe Manager Console. This will resolve the issue.

NOTE: This error only generates if Customer Session didn’t complete invoice. So only set it active under Complete Invoice in tInvoice table can resolve the issue.