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

Last updated on MARCH 08, 2017

Applies to:

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

Goal

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 (10.1.3.1.0) (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
Call:UPDATE VT_WF_YEARS SET UPDATE_TIME = ?, YEAR_5 = ? WHERE (WF_ID = ?)
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(DatabaseException.java:282)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:660)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:712)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:498)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:4
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms