Back
5. Invoice & Billing
Closing user sessions displays incorrect invoice details

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:
    • Power Failure.
    • User/Administrator restarted/shutdown the system directly without closing the server application.
    • 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. After repairing the database of a Power Fluctuated PC, the compact & repairs deletes the corrupted entries and Tables causing a Data mismatch with tCustomerSession and tCustomerSessionTerminal.
  2. When starting the customer Session it will show the right terminal information, but when closing the customer session it shows 2 internet activities(double entry of session usage) made in that session.
Solution Provided:-

Steps to resolve the issue are as follows:

  1. When starting the customer session it shows right session information.
  2. Once the customer completes his activity, while closing the customer session it shows that the given session have made multiple usage.
  3. This could be because, the customer session might have double entries or there is some mismatch in the customer session information in the database.
  4. The session information will not show the exact amount of the current activity in the Double entries, the session information might change according to the database entry.
  5. Here, close the customer session by giving a discount.
  6. Close the Café Manager Console, after taking a backup.
  7. Now the next step is to repair the database for which get in touch with the AM Support Team. The Am Support Team will follow the below mentioned steps:
  8. Now go to c:\Program Files\Ideacts\Clinck Cyber Café Manager\Database.
  9. Open the password protected database.
  10. Open tCustomerSession table and tCustomerSessionTerminal table.
  11. Here you will find a Mismatch in the Number of sessions that is present in both the tables.
  12. The tCustomerSessionTerminal table will be showing that CustomerSessionID Column has restarted the session IDs of the customer from first. For Ref. the please seen the screenshot.
  13. You may find this due to some recent corruption in the database which might have deleted the tCustomerSession table.
  14. The Structure of database only contain the Skeleton of the tCustomerSession table, once there is a activity done in a system it will start entering the data in the tCustomerSession. But as the tCustomerSessionTerminal still has the old Activity, once a session activated and closed, the tInvoice will get the Session Information from both the previous and current activity.
  15. As every session has different Customer Session ID, the database will gather the Customer ID’s session information and completes the invoice.
  16. Here we need to replace both the tCustomerSession and tCustomerSessionTerminal table from a database backup which doesn’t contains this Session mismatch.
  17. To replace a table from backup database to the problematic database are as follows:
    1. Open CCM.c3m file from C:\Program Files\Ideacts\Clinck Cyber Café Manager\Database.
    2. Now open a Backup Database.
    3. Copy tCustomerSession table from the backup database.
    4. Paste it in the database where you wanted the changes to happen.
    5. Pasting table will prompt with 3 options.
  • Structure only
  • Structure and data
  • Append data to existing table.
  1. Select the Structure and Data click ok, this will again prompt with a window asking for the replacement of tCustomerSession table.
  2. Clicking yes will replace the tCustomerSession with the data inside it.
  3. Now Copy tCustomerSession table from the backup database.
  4. Paste it in the database where you wanted the changes to happen.
  5. Pasting table will prompt with 3 options.
  • Structure only
  • Structure and data
  • Append data to existing table.
  1. Select the Structure and Data click ok, this will again prompt with a window asking for the replacement of tCustomerSession table.
  2. Clicking yes will replace the tCustomerSessionTerminal with the data inside it.
  3. Now Close both the databases and open Cafe Manager Console, this should resolve the Double session Entries problem.
  4. Also the table replacement from old/backup database will give you less data loss.