9 Troubleshooting

This section describes the failure possibilities that you may encounter during the embarkation day.

Figure 9-1 QCI Sync Failure Points


This figure illustrates the potential failure points when synchronizing the database.

  • Failure 1

    Network connection lost between the shipboard database and the shore-side QCI database.

    • The database synchronization between the ship and the QCI Shore database has stopped.

    • Check and ensure the Oracle Database Listener has started and user ‘UID’ and password exist in the database schema.

    • This does not affect the ship operations and the shore embarkation operation. All the reservation changes made on both databases are logged to CHG table for synchronization at a later stage.

    • The interface tries to reconnect to the shore QCI database every number of seconds, depending on the time interval setup on the interface and synchronization resume after the network connection is restored.

  • Failure 2

    The Ship database server network cable disconnected or database service has stopped.

    • The database synchronization between the ship and the QCI Shore database has stopped.

    • This does not affect the shore embarkation operation and all the reservation changes are logged to CHG table to be synchronized later. The shipboard operation is affected due to the lost connection from the shipboard database server.

    • The error message popup on QCI Synchronizer Interface is "ORA-03114: not connected to ORACLE". The error message popup on ship workstation is "ORA-03113: end-of-file on communication channel".

  • Failure 3

    QCI Shore database server network cable is disconnected or database service has stopped.

    • The synchronization between the ship and the QCI Shore database has stopped. The shipboard operation is not affected and all the reservation changes are logged in the CHG table for synchronization at a later.

    • This affects the shore embarkation operation due to the lost connection from the QCI Shore database server.

    • The error message popup on QCI workstation is "ORA-03113: end-of-file on communication channel".

  • Failure 4

    One of the DMP failed to restore.

    • When the program tries to restore the ‘BKSTG_DINING’ schema, one of the DMP is missing due to certain reason, the import log show ‘IMP-00037: Character set marker unknown’ and ‘IMP-00000: Import terminated unsuccessfully’.

    • This error is written to the QCISyncLog.

    • The ‘Start QCI Offline Mode’ process aborts.

  • Failure 5

    Failed to run Database Installer or Tools Encryption Key Manager.

    • The QCI Sync is shut down, possibly preformed using End Task Program but Offline Mode is still shown ‘Enabled’.

    • You are not allowed to run the DB Installer or Change Encryption Key. A message prompt: 'QCI Sync is running, please stop QCI Sync first'.

    • You are required to run QCI Sync to perform Stop Offline Mode.

  • Failure 6

    QCI Sync returned ‘Error sending to DR’

    • The application tries to send a check-in status to an offline Dining Interface.

    • Verify that the Dining Interface is running.

  • Failure 7

    QCI Sync hang

    • Run the 1st script to find out which session ID could possibly lock the database and the 2nd script to kill that session. For further assistance, contact Customer Support.