java.sql.SQLException: ORA-12899: value too large for column "FETRNG3_OIM"."REQUEST_APPROVALS"."APPROVAL_STATUS" (actual: 442, maximum: 32)

Oracle Community | 788860 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Custom Approval process for Self Registration

    Oracle Community | 6 years ago | 788860
    java.sql.SQLException: ORA-12899: value too large for column "FETRNG3_OIM"."REQUEST_APPROVALS"."APPROVAL_STATUS" (actual: 442, maximum: 32)
  2. 0

    Error provisioning a resource with custom approval process

    Oracle Community | 5 years ago | 923197
    java.sql.SQLException: ORA-12899: value too large for column "DEV_OIM"."REQUEST_APPROVALS"."APPROVAL_STATUS" (actual: 442, maximum: 32)
  3. 0

    Mediator instance failing in production

    Oracle Community | 7 years ago | user5108636
    java.sql.SQLException: ORA-01653: unable to extend table DEV_SOAINFRA.MEDIATOR_DEFERRED_MESSAGE by 128 in tablespace DEV_SOAINFRA Error Code: 1653 Call: INSERT INTO MEDIATOR_DEFERRED_MESSAGE (CASE_ID, CONTAINER_ID, STATUS, MSG_ID, COMPONENT_DN, OPERATION, LOCK_TIME, PRIORITY, IS_EVENT, QNAME_LOCAL_PART, CREATION_DATE, QNAME_NAMESPACE, CASE_INFO, SOURCE_URI, COMPONENT_STATUS, INSTANCE_CREATED) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [EAD1EEC07F4211DFBF9983F5177F7B66, C99B7BD07D9A11DFBF9783F5177F7B66, 0, EACD5AE07F4211DFBF9983F5177F7B66, default/ProcessData!1.0/Mediator, livefeed, null, 4, 0, null, 2010-06-24 13:45:22.848, null, JMS_ORTD.produce, AVCadDataFeed, null, true] Query: InsertObjectQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage@17765662)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to Create/Update Forms in design console(OIM11G)

    Oracle Community | 6 years ago | Venuy2k
    java.sql.SQLException: ORA-01407: cannot update ("FRO_OIM"."SDK"."SDK_SCHEMA") to NULL
  6. 0

    Error: Unable to insert new audit record for auditee 21 in repository UPA..

    Oracle Community | 8 years ago | 703604
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-12899: value too large for column "FETRNG3_OIM"."REQUEST_APPROVALS"."APPROVAL_STATUS" (actual: 442, maximum: 32)

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1040)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1379)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeUpdate
    1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    1 frame
  4. EclipseLink (non-OSGi)
    UnitOfWorkImpl.writeChanges
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:792)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:867)
    3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:587)
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:530)
    5. org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:914)
    6. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.updateObject(DatasourceCallQueryMechanism.java:715)
    9. org.eclipse.persistence.internal.queries.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:430)
    10. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1141)
    11. org.eclipse.persistence.queries.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:84)
    12. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
    13. org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
    14. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
    15. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:589)
    16. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:109)
    17. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:86)
    18. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2898)
    19. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
    20. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
    21. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1167)
    22. org.eclipse.persistence.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:233)
    23. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:108)
    24. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3260)
    25. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1413)
    26. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1518)
    27. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.writeChanges(UnitOfWorkImpl.java:5499)
    27 frames
  5. oracle.iam.request
    ApprovalPolicyServiceEJB.updateApprovalResultx
    1. oracle.iam.request.repository.ApprovalRepository.updateApprovalInstanceWithOutcome(ApprovalRepository.java:84)
    2. oracle.iam.request.impl.ApprovalManager.approvalInstanceComplete(ApprovalManager.java:111)
    3. oracle.iam.request.impl.ApprovalPolicyServiceImpl.updateApprovalResult(ApprovalPolicyServiceImpl.java:52)
    4. oracle.iam.request.api.ApprovalPolicyServiceEJB.updateApprovalResultx(Unknown Source)
    4 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  7. com.bea.core
    MethodInvocationVisitorImpl.visit
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    7. com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
    7 frames
  8. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  9. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    3. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    4. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    7. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    8. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    8 frames
  10. Unknown
    $Proxy363.updateApprovalResultx
    1. $Proxy363.updateApprovalResultx(Unknown Source)
    1 frame
  11. oracle.iam.request
    ApprovalPolicyService_1nib43_ApprovalPolicyServiceRemoteImpl.updateApprovalResultx
    1. oracle.iam.request.api.ApprovalPolicyService_1nib43_ApprovalPolicyServiceRemoteImpl.updateApprovalResultx(ApprovalPolicyService_1nib43_ApprovalPolicyServiceRemoteImpl.java:330)
    1 frame
  12. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  13. weblogic.ejb.container
    RemoteBusinessIntfProxy.invoke
    1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
    1 frame
  14. Unknown
    $Proxy180.updateApprovalResultx
    1. $Proxy180.updateApprovalResultx(Unknown Source)
    1 frame
  15. oracle.iam.request
    ApprovalPolicyServiceDelegate.updateApprovalResult
    1. oracle.iam.request.api.ApprovalPolicyServiceDelegate.updateApprovalResult(Unknown Source)
    1 frame
  16. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  17. Thor.API.Base
    SecurityInvocationHandler$1.run
    1. Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
    1 frame
  18. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  19. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  20. weblogic.security
    Security.runAs
    1. weblogic.security.Security.runAs(Security.java:41)
    1 frame
  21. Thor.API.Security
    weblogicLoginSession.runAs
    1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
    1 frame
  22. Thor.API.Base
    SecurityInvocationHandler.invoke
    1. Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
    1 frame
  23. Unknown
    $Proxy494.updateApprovalResult
    1. $Proxy494.updateApprovalResult(Unknown Source)
    1 frame
  24. oracle.iam.request
    ApprovalCallBack.completed
    1. oracle.iam.request.workflowcallback.ApprovalCallBack.completed(ApprovalCallBack.java:28)
    1 frame
  25. oracle.iam.platform
    CallbackService.callback
    1. oracle.iam.platform.workflowservice.ws.CallbackServiceImpl.callback(CallbackServiceImpl.java:98)
    2. oracle.iam.platform.workflowservice.ws.wls.CallbackService.callback(CallbackService.java:33)
    2 frames
  26. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  27. weblogic.wsee.jaxws
    WLSInstanceResolver$WLSInvoker.invoke
    1. weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
    2. weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
    2 frames
  28. JAX-WS RI Runtime Bundle
    SEIInvokerTube.processRequest
    1. com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:151)
    2. com.sun.xml.ws.server.sei.EndpointMethodHandlerImpl.invoke(EndpointMethodHandlerImpl.java:265)
    3. com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)
    3 frames
  29. weblogic.wsee.jaxws
    FlowControlTube$1.run
    1. weblogic.wsee.jaxws.tubeline.FlowControlTube$FlowControlAwareTube.processRequest(FlowControlTube.java:155)
    2. weblogic.wsee.jaxws.tubeline.FlowControlTube$1.run(FlowControlTube.java:94)
    3. weblogic.wsee.jaxws.tubeline.FlowControlTube$1.run(FlowControlTube.java:92)
    3 frames
  30. Java RT
    Subject.doAs
    1. javax.security.auth.Subject.doAs(Subject.java:337)
    1 frame
  31. weblogic.wsee.jaxws
    FlowControlTube.processRequest
    1. weblogic.wsee.jaxws.tubeline.FlowControlTube.processRequest(FlowControlTube.java:91)
    1 frame
  32. JAX-WS RI Runtime Bundle
    ServletAdapter.handle
    1. com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:604)
    2. com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:563)
    3. com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:548)
    4. com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:445)
    5. com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:373)
    6. com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:524)
    7. com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:255)
    8. com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:140)
    8 frames
  33. weblogic.wsee.jaxws
    JAXWSServlet.doPost
    1. weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:208)
    2. weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:310)
    3. weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:223)
    4. weblogic.wsee.jaxws.JAXWSServlet.doPost(JAXWSServlet.java:124)
    4 frames
  34. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    1 frame
  35. weblogic.wsee.jaxws
    JAXWSServlet.service
    1. weblogic.wsee.jaxws.JAXWSServlet.service(JAXWSServlet.java:79)
    1 frame
  36. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    1 frame
  37. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  38. oracle.dms.wls
    DMSServletFilter.doFilter
    1. oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)
    1 frame
  39. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
    3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
    3 frames
  40. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  41. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  42. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
    3 frames
  43. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames