My Oracle Support Banner

Why do I get TT5107 error reported when Cache tries to use the TT_06_AWT_BLOB_APPEND procedure on Oracle? (Doc ID 1479424.1)

Last updated on FEBRUARY 03, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Goal

 The goal is to explain the TT5107 error contained in the below set of error messages:

 

15:21:25.91 Err : REP:  4582: [1113524544, 0, Awt] RTTFMP:receiver.c(7794): TT16187: Transaction 1341249042/2643347; Error: transient 0, permanent 1 state 2 error message :
15:21:25.94 Err : REP:  4582: [1113524544, 0, Awt] RTTFMP:receiver.c(8971): TT16039: Failed to commit transaction for caller: rxCommitTx()
15:21:25.94 Err : REP:  4582: RTTFMP:receiver.c(8971): TT5107: TT5107: Oracle(OCI) error in BEGIN TT_06_AWT_BLOB_APPEND('SELECT "VALUE" FROM "<USER>"."TEST" WHERE "ID" = 4 FOR UPDATE',1,'34'); END; : ORA-06550: line 1, column 7: PLS-00201: identifier 'TT_06_AWT_BLOB_APPEND' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored -- file "bdbTblH.c", lineno 1894, procedure "bdbAWTPlSqlWithMetaExecDirect()"
15:21:25.94 Err : REP:  4582: RTTFMP:receiver.c(8971): TT5130: TT5130: Error executing the following statement on Oracle: AWT PL/SQL BLOCK WITH META DATA -- file "bdbTblH.c", lineno 1925, procedure "bdbAWTPlSqlWithMetaExecDirect()"
15:21:25.94 Err : REP:  4582: RTTFMP:receiver.c(8971): TT5059: TT5059: Cannot apply Awt changes to Oracle.  The Oracle transaction will be rolled back. -- file "bdbTblH.c", lineno 4604, procedure "ttBDbStmtForce()"
15:21:25.95 Err : REP:  4582: [1113524544, 0, Awt] RTTFMP:receiver.c(7794): TT16187: Transaction 1341249042/2643347; Error: transient 0, permanent 1 state 2 error message :

 

This was produced when the customer tried to insert a row into an AWT cachegroup containing a BLOB column. For example:

 

 
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.