...
| Info |
|---|
If when running there is a message in the logger that says “Failed to retrieve fc_tqmgr_transaction_id_seq.nextval from the FLOWCAL Oracle database” - this is an issue in the FLOWCAL database. FLOWCAL Support will need to be contacted. |
Tables Used:
Gas Records uses FC_TRANSACTION_SNAPSHOT to hold the meter config data and FC_TRANSACTION_QUEUE for everything else.
Liquids use:
FC_TQ_METER_ALARM, FC_TQ_METER_EVENT, FC_TQ_METER_BATCH_REPORT to replace FC_TRANSACTION_QUEUE.
FC_TQ_METER_CONFIG to replace FC_TRANSACTON_SNAPSHOT
FC_TQ_MANAGER essentially holds the information to link the meter to all of it’s events in the other tables. Every event, alarm, config and batch record has a row in FC_TQ_MANAGER as well as it’s own table.