7 Log Messages

The system logs all messages onto a log file in the following format:

<timestamp><location><message>
For example: <2018-09-11 00:45:11>Ship SELECT statement

Log Message during data sync

Table 7-1 Log Message Type In Data Sync

Log Message Type Log Message Format with Sample Data

Initialization - QCI Sync interface started

Start<HT>Interface Started - (<version number>)(<work station>)(<IP address>) 9/11/2018 12:45:05 AM

Sync Reservation Records

  • Shore->Ship<HT> 3 record(s) to add to Ship DB

Note: There are 3 new reservation found at shore. System detects new reservation by running SELECT statement.

  • Ship-><HT> Adding RES record.

Note: System is creating reservation at shipside. It will sync record in UXP, RES, VIS, SEC, and CRD.

  • Ship->Insert statement.

Note: Insert new IDs into QCI table at ship DB. This table links ship and shore reservation records.

  • <HT>ResAcc - UID sync to Ship DB.

Note: New reservation record with ID UID is created at ship DB.

Sync Posting Records

  • <HT>Shore->SELECT statement

Note: QCI Sync checks number of new records found in POS table at shore DB. If record is found, it will synchronize the record over to ship DB.

Sync Changes

  • Ship->SELECT statement.

Note: Load changes in CHG table at ship and shore DB. It skips log message.

  • Same Update Found, remove old value - 0,key=UXPUXP_A_POS_DEBITUD(UID)

Note: Same update found in CHG tables. Old value = chg_value; key = chg_table, chg_column and chg_record_id. QCI Sync compares CHG records at shore and ship DB. Concatenation of 3 columns - chg_table, chg_column and chg_record_id is used in this comparison. Old value will be removed.

  • <HT> 775 column value to update to Ship DB

Note: There are 775 of changes found in shore.

  • Ship->update statement.

Note: updating changes from shore DB to ship DB.

  • Ship->SELECT statement.

Note: System sync image in sec_image at SEC table.

  • <HT>Update Skip for RES->RES_EMB_PC->UID->TO_DATE('2018-09-11 03:31:25', 'YYYY-MM-DD HH24:MI:SS')->9/10/2018 3:31:25 PM->9/10/2018 9:26:32 PM

Note: QCI Sync skips the update if modify date (9/10/2018 3:31:25 PM) is less than record’s last modified date (9/10/2018 9:26:32 PM).

Error

  • Error<HT>Shore->UpdateChg\Line#\2253\ORA-12899: value too large for column "UID"."UXP"."UXP_A_CITY" (actual: 31, maximum: 30)<CR><LF>chg_id = UID, chg_table = UXP, chg_column = ALL, chg_record_id = UID, chg_value = , chg_moddate = 9/10/2018 11:51:13 AM

Note: We have to make sure columns in both shore and ship database have the same length.

  • <HT> 232 column value to update to Shore QCI DB-Done,AddNew-230,Update--228,Delete-0,Skip-0,Error-230

Note: Summary of records after sync is complete. Data sync will start again after x seconds, it is based on the setting at the interface.