My Oracle Support Banner

VT_WF_YEARS Does Not Support More Than 999,999 Logins (Doc ID 1543600.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Adaptive Access Manager - Version and later
Information in this document applies to any platform.


How can I increase the number of characters beyond 6 for columns in the VT_WF_YEARS table? I am encountering the following error for all logins beyond my 999,999th login.


In the example below, we see that user ABC123 is triggering an exception because the column cannot handle the size of the incoming data:

2012-11-11 12:12:27,049 ERROR [app=oaam_oarm] [AutoLearningThredPool_0_2] com.bharosa.vcrypt.tracker.autolearning.VCryptTransactionPatternAnalysisRequest - createWFEntries(VCryptPatternWorkFlow, VPatternEntity, VCryptFingerPrint, Long, Long): Error updating WF Entries.
Local Exception Stack:

Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 ( (Build 061004)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
Error Code: 1438
bind => [2012-11-11 12:12:26.976, 1000000, ABC123]
Query:UpdateObjectQuery(wfId={ABC123} objectId={506} entityDefId={1} fingerPrintId={1663691} createTime={Thu Sep 13 14:40:39 CDT 2012} updateTime={Wed Nov 28 12:12:26 CST 2012} year1={0} year2={0} year3={0} year4={0} year5={1000000} year6={0} year7={0} year8={0} )
at oracle.toplink.exceptions.DatabaseException.sqlException(
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeNoSelect(
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.