Gasboy SiteOmat Maintenance Manual - Manual (Page 195)

191 SiteOmat Setup and Maintenance Manual – MDE 4817G
8-4.4.5. Debug Log (debug.log)
This file contains an assortment of entries from different parts of the SiteOmat application.
Please consult with Gilbarco help desk personnel for more specific details on particular entries.
8-4.5. FCC Log Files
This section describes the different types of log files that appear on the FCC. The name of the log
file appears in the header of each section.
All log files appear in the directory /usr/local/orpak/FCC/bin/log.
8-4.5.1. FCC_AUTH.log
Logs all authorization calls from FCC to BOS – same information found in BOS_WEB_COMM
log – this log is from the FCC side.
8-4.5.2. Database Logs (DATA.DB.log, META_DATA.DB.log)
For each database used by the system, there exists a log file that records all queries run on that
particular database. It can be considered as a sort of journal of activity on that database.
The database log files include both SELECT queries, as well as queries that modify the database in
some way.
Note that the database log files are primarily intended for use by development.
8-4.5.2.1. Examples
8-4.5.2.1.1. DATA.DB - Writing Transaction
[2007-12-04 08:47:03.691 00004428] SQL: BEGIN TRANSACTION(007F4C78)
[2007-12-04 08:47:03.691 00004428] SQL: insert into transactions (timestamp,id,date,time,type,
pump,nozzle,hose_number,quantity,sale,ppv,
density,temperature,tag,tank_id,shift_id,
mean_id,cash_customer_id,plate,external_tran_id,trx_seq_no,tank_name,
mean_name,product_code,product_name,pump_id,nozzle_id,
coupon_id,odometer,track2,driver_object_id,fcc_bos_cleared)
values ('2007-12-04
08:47:03',300014567,'2007-12-04','08:47:03','AUTO', 2,4,8,8.870000,19.780000,2.230000,
0.000000,0.000000,'',200000004,300000004, '1','0','','',3038,'Tank4_XM',
'AutoAuth',14,'XM',200000013,200000008, 0,0.000000,'',0,0)(007F4C78)
[2007-12-04 08:47:03.738 00004428] SQL: replace into indexes (id,name) values
(300014567,'transaction')(007F4C78)
[2007-12-04 08:47:03.738 00004428] SQL: COMMIT(007F4C78)au
8-4.5.2.1.2. META_DATA.DB
[2007-03-14 20:34:22.604 00009589] SQL: SELECT temperature FROM density_to_vcf_t
WHERE temperature >= 16.
600000
ORDER BY temperature ASC limit 1
[2007-03-14 20:34:22.633 00009589] SQL: SELECT temperature FROM density_to_vcf_t
WHERE temperature <= 16.
600000
ORDER BY temperature DESC limit 1
[2007-03-14 20:34:22.640 00009589] SQL: SELECT den15 FROM density_to_vcf_t
WHERE temperature = 16.500
000 AND den15 >= 746.300000
ORDER BY den15 ASC limit 1
[2007-03-14 20:34:22.724 00009589] SQL: SELECT den15 FROM density_to_vcf_t
WHERE temperature = 16.500
000 AND den15 <= 746.300000
ORDER BY den15 DESC limit 1
[2007-03-14 20:34:22.962 00009589] SQL: SELECT vcf FROM density_to_vcf_t WHERE
temperature = 16.500000 AND
den15 >= 745.000000
AND den15 <= 745.000100