Permanent Oracle Database Errors Reported by TimesTen

Insert, update, or delete errors that occur while applying changes to Oracle Database are saved in an error file located in the database directory with the following name:

DataSourceName.awterrs

Errors reported to this file are permanent errors. TimesTen does not retry the transaction. The errors may be reported in the AWT error file long after the commit to TimesTen occurs.

The format of the messages in the AWT error file is similar to those generated for conflict and transaction errors in replication. Oracle Database error messages are also reported in the support log and the user log. The Oracle Database errors are prefixed with ORA-. The TimesTen error messages are prefixed with TT. .

If a constraint violation occurs when a cache group update is propagated to the Oracle database, the message in the AWT error file is similar to the following:

Error occurred 14:48:55 on 03-22-2011
Datastore: c:\temp\cgDSN
Oracle Id: system1
Transmitting name: cgDSN
Error message: 
  TT5210: Oracle unique constraint violation error in OCIStmtExecute(): 
ORA-00001: unique constraint (GUSER.SYS_C00357240) violated rc = -1 -- file
 "bdbTblH.c", lineno 1205, procedure "ttBDbStmtForce()"
  TT5025: Commit failure in Oracle. Transaction must be rolled back in TimesTen. 
-- file "bdbConnect.c", lineno 885, procedure "ttBDbXact()"

Operation that caused the error:
Insert into table TESTUSER.T1 <9,1000>

Failed transaction:
Insert into table TESTUSER.T1 <9, 1000>
End of failed transaction

If an object that TimesTen has placed on the Oracle database is dropped, the message in the AWT error file is similar to the following:

May 04 18:12:36 HOST1 TimesTen Replication 11.2[2136]: 
[Err ] DEFAULT:meta.c(639): 
TT16062: Failed to compile command:
select p.commit_timestamp, p.commit_seqnum, p.protocol from owner1.TT_06_REPPEERS 
p where p.replication_name = :rname and p.replication_owner = :rowner and 
p.tt_store_id = :oid and p.subscriber_id = :sid

May 04 18:12:36 HOST1 TimesTen Replication 11.2[2136]: 
[Err ] DEFAULT:meta.c(639): 
TT5221: TT5221: Oracle syntax error in OCIStmtExecute(): 
ORA-00942: table or view does not exist rc = -1 -- file "bdbStmt.c", lineno 1041, 
procedure "getOraOutTypesNLengths()"

In this example, the TT_06_REPPEERS table does not exist. To recover from this error, perform the following tasks:

  1. Stop the replication agent.

  2. Drop and recreate the cache group.

  3. Restart the replication agent.