My Oracle Support Banner

Propagation of AWT Cache Group Transactions Fails With ORA-1438 When Cache Group Contains TT_TINYINT Columns (Doc ID 1451841.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.9.0 to 11.2.1.9.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 -given an AWT cache group containing  tt_tinyint columns: if CacheAWTMethod is enabled than propagation of rows from TimesTen to Oracle will cause tt_tinyint data values to be distorted, such that the propagation may fail with ORA-1438 numeric precision violations.

-errors similar to to the following will be issued in the ttmesg.log file for the TimesTen instance:

.


  TT5107: Oracle(OCI) error in INSERT INTO "OWNER"."TT_ISSUE_TEST" "XXX_ID","XX_ID","VXX_USAGE","Q_LXXXIT_TYPE","XXX_USAGE","XXX_BALANC
E","XXX","XX_DAY","XX_DURATION","XXX","XXX","XX_
OPT_OUT","RC_XXXX_STATUS","LAST_RESET_TS","XXX_LAST_STATUS")
VALUES (1,2,4,30723,5,6,7,NULL,8,NULL,2569,2826,11,NULL,'12')
: ORA-01438: value larger than specified precision allowed for this column --
file "bdbTblH.c", lineno 1462, procedure "bdbAWTPlSqlWithMetaExecDirect()"


 TT5130: Error executing the following statement on Oracle: AWT PL/SQL BLOCK
WITH META DATA -- file "bdbTblH.c", lineno 1493, procedure
"bdbAWTPlSqlWithMetaExecDirect()"
 TT5059: Cannot apply Awt changes to Oracle.  The Oracle transaction will be
rolled back. -- file "bdbTblH.c", lineno 3876, procedure "ttBDbStmtForce()"

.


Note that the problem only occurs when ini parameter CacheAWTMethod=1; a possible workaround is to disable CacheAWTMethod, although doing so may have a significant impact on cache performance.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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