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 |
|
Sync Reservation Records |
Note: There are 3 new reservation found at shore. System detects new reservation by running SELECT statement.
Note: System is creating reservation at shipside. It will sync record in UXP, RES, VIS, SEC, and CRD.
Note: Insert new IDs into QCI table at ship DB. This table links ship and shore reservation records.
Note: New reservation record with ID UID is created at ship DB. |
Sync Posting Records |
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 |
Note: Load changes in CHG table at ship and shore DB. It skips log message.
Note: Same update found in CHG tables. Old value
Note: There are 775 of changes found in shore.
Note: updating changes from shore DB to ship DB.
Note: System sync image in
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 |
Note: We have to make sure columns in both shore and ship database have the same length.
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. |