Back
3. Client-Server Connectivity Issues
3.3. Connectivity issues due to Database Corruption after Power Failure.
Missing DB Entries

Scenarios where the issue occurs:-

The Scenarios where this issue can occur are as follows:

  1. Power Failure.
  2. Unexpected Server Machine Restart or Shutdown.
How to Identify the issue:-

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

  1. Client is not showing connected on the server machine.
  2. We are getting the ping response between the server and the client however still the client is not showing connected in the Café Manager Console.
  3. The C3M Server Logs shows that the terminal is communicating with the server application however it is not showing connected in the console.
Solution Provided:-

Steps to resolve the issue are as follows:

  1. Check if the Client Server connectivity is established through the ping command.
  2. Go to the following path “C:/Program Files/Ideacts/Clinck Cyber Cafe Manager/Logs and then check the file UDP Send to Client and UDP Received from Client for the following info:
    1. In UDP Send to Client file check if the “Server’s IP address and the Café Code is mentioned”
    2. In UDP Received from Client file check if “Clients IP Address, Terminal Name, Café Code is mentioned”
  3. The above step will help us to check for the Server Client connectivity.
  4. Close the Café Manager Console.
  5. Open the Database folder and take a backup of CCM.C3M file which is located at “C:/Program Files/Ideacts/Clinck Cyber Café Manager/Database”.
  6. 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.
  1. 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.
  1. Now open the Cafe Manager console and see if this resolves the issue and the connectivity is established between the server and that Affected Terminal.
  2. If the issue is still not resolved then go to Step 9.
  3. Open the Database and check for the following table which may have invalid Entries.
    1. “tTerminal” table
    2. “tTempSession” table
  4. If any of the above mentioned tables have invalid entries (###-Symbol) then remove all the rows which have those entries in the table.
  5. Now close the database.
  6. Now open the Café Manager console and the issue should be resolved.