Technical data

Problems with conflict checking
6-16 Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide
■ Timestamp does not exist
■ Conflict reporting slows down replication
Column cannot be used for replication timestamp
When attempting to set CHECK CONFLICTS for an element in a CREATE
REPLICATION statement, you may encounter an error similar to the following:
8004: Column REPL.TABS.TS cannot be used for replication timestamp checking if
in an index or added by ALTER TABLE; and must be binary(8) with NULL values
allowed.
In this situation, check:
■ That the timestamp column in the specified table is a nullable column of type
BINARY(8). In the above example, the TS column in the REPL.TAB table should
have a type of BINARY(8).
■ The timestamp column is defined in the original CREATE TABLE statement,
rather than added later using ALTER TABLE.
Timestamp does not exist
You may receive an error similar to the following:
2208: Column TS does not exist in table.
In this situation, confirm that you have specified the correct name for the timestamp
COLUMN in the CHECK CONFLICTS clause and that it exists in the specified table.
Also, make sure the timestamp column is not part of a primary key or index.
Conflict reporting slows down replication
If you have configured replication to check conflicts, TimesTen sends reports to the
local host. You can also configure a report file. See "Diagnostics through SNMP Traps"
in the Oracle TimesTen In-Memory Database Error Messages and SNMP Traps.
If there is a large number of conflicts in a short period of time, subscriber performance
can slow down because of the reporting requirements. You can use store attributes in
the CREATE REPLICATION or ALTER REPLICATION statements to suspend and
resume conflict reporting at specified rates of conflict:
■ CONFLICT REPORTING SUSPEND AT rate
■ CONFLICT REPORTING RESUME AT rate
Information about conflicts that occur while reporting is suspended cannot be
retrieved.
See "Reporting conflicts" in the Oracle TimesTen In-Memory Database TimesTen to
TimesTen Replication Guide.