Unable to Save Tab Display Configuration on Upgraded Environment With ORA-01438 Error in Application Serer Log (Doc ID 1392745.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Agile Product Portfolio Management - Version 9.3.1.0 and later
Information in this document applies to any platform.

Symptoms

Tab Display Configuration is not created with below error in Agile Application Server log:

Error
source exception
ORA-01438: value larger than specified precision allowed for this column

java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:94)
at com.agile.pc.cmserver.user.TabDispConfigDAO.createTabDispConfiguration(TabDispConfigDAO.java:117)
at com.agile.pc.cmserver.user.TabDispConfigService.createTabDispConfiguration(TabDispConfigService.java:45)
at com.agile.pc.cmserver.user.UserSessionBean.createTabDispConfiguration(UserSessionBean.java:2750)
at com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl.__WL_invoke_1(Unknown Source)
at com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:32)
at com.agile.pc.cmserver.user.UserSessionBean_qy39gj_EOImpl.createTabDispConfiguration(Unknown Source)
at com.agile.ipa.pc.CMUser.createTabDispConfiguration(CMUser.java:2032)
at com.agile.ui.pcm.admin.ConfigureTabHandler.saveTabDispConfiguration(ConfigureTabHandler.java:143)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at com.agile.ui.web.action.ActionServlet.invokeMethod(ActionServlet.java:1068)
at com.agile.ui.web.action.ActionServlet.handleRequest(ActionServlet.java:672)
at com.agile.ui.web.action.ActionServlet.doPost(ActionServlet.java:309)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:74)
at com.agile.ui.pcm.common.filter.RemoteFSRequestFilter.doFilter(RemoteFSRequestFilter.java:148)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:74)


Steps
The issue can be reproduced at will with the following steps:
1. Log in to Web Client
2. Tool & Setting => Administration => Tab Display Configuration => Create New
3. Now select the following
Name ==> Test
Tab Configuration => ECO
Hidden Tabs ==> Relationships
Assign To ==> Any one
Click Add
4. Tab is not created and Agile Application Server log has above error

Changes

 Upgraded Agile Database

Cause

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