ORA-02291: integrity constraint (T1_OS_ADMIN_O.OSFRK_OSUSR_WJW_CHATITEM_37739) violated - parent key not found
ORA-06512: at line 1


Environment Information -


at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
at sun.reflect.GeneratedMethodAccessor731.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:367)
at com.sun.proxy.$Proxy1771.execute(Unknown Source)
at outsystems.hubedition.databaseabstractionlayer.adoadapters.ADOCommand.executeStatement(Unknown Source)
at outsystems.hubedition.databaseabstractionlayer.adoadapters.ADOCommand.execute(Unknown Source)
at outsystems.hubedition.extensibility.data.executionservice.BaseExecutionService.executeNonQuery(Unknown Source)
at outsystems.internal.db.Command.$rnb(Unknown Source)
at outsystems.internal.db.Command$$Lambda$3630/1321579302.executeImplLambda(Unknown Source)
at outsystems.hubedition.util.delegates.Func$Func0_Lambda.execute(Unknown Source)
at outsystems.internal.db.DatabaseAccess.executeWithoutRequestTimeout(Unknown Source)
at outsystems.internal.db.Command.executeNonQuery(Unknown Source)
at outsystems.internal.db.Command.executeNonQueryWithoutTransformParametersSyntax(Unknown Source)
at outsystems.internal.db.Command.executeNonQueryWithoutTransformParametersSyntax(Unknown Source)
at osgoscreditsprocess.entities.ENChatItemEntity.createChatItem(Unknown Source)
at osgoscreditsprocess.actions.ActRollbackToUser.executeRollbackToUser(Unknown Source)
at osgoscreditsprocess.processes.ProcExcApplicationComplete$ActExecCheckCreateCardStatusCode.executeDecision(Unknown Source)
at osgoscreditsprocess.processes.ProcExcApplicationComplete$ActExecCheckCreateCardStatusCode.executeMethod(Unknown Source)
at outsystems.hubedition.runtimeplatform.processes.ProcessBase$AbstractProcessActivityBase.startWork(Unknown Source)
at outsystems.hubedition.runtimeplatform.processes.ProcessBase$AbstractProcessActivityBase.startWork(Unknown Source)
at outsystems.hubedition.runtimeplatform.processes.ProcessBase$AbstractProcessActivityBase.executeNextActivity(Unknown Source)
at outsystems.hubedition.runtimeplatform.processes.ProcessBase$AbstractProcessActivityBase.executeNextActivities(Unknown Source)
at outsystems.hubedition.runtimeplatform.processes.ProcessBase$AbstractProcessActivityBase.startWork(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl$5$1.executeImpl(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl$5$1.executeImpl(Unknown Source)
at outsystems.hubedition.util.delegates.Action$Action1.executeImplLambda(Unknown Source)
at outsystems.hubedition.util.delegates.Action$Action1_Lambda.execute(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl.executeActivityWebService(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl.access$1(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl$5.executeImpl(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl$5.executeImpl(Unknown Source)
at outsystems.hubedition.util.delegates.Func$Func1.execute(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl.executeWebService(Unknown Source)
at osgoscreditsprocess.activityactions.ActivityActionsHandlerImpl.executeActivityActionv2(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1751.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at org.jboss.as.webservices.deployers.WSComponentInstanceAssociationInterceptor.processInvocation(WSComponentInstanceAssociationInterceptor.java:49)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
at org.jboss.as.webservices.invocation.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:129)
at org.jboss.wsf.stack.cxf.JBossWSInvoker.performInvocation(JBossWSInvoker.java:177)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:104)
at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:237)
at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:69)
at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:146)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:107)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:249)
at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:97)
at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:131)
at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:88)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:289)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:209)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:136)
at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
at outsystems.hubedition.webwidgets.BaseRequestStartupFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
at outsystems.hubedition.webwidgets.filters.HttpContextFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
at outsystems.hubedition.webwidgets.filters.CacheControlFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:559)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)
   at java.lang.Thread.run(Thread.java:745)


It's an Oracle integrity constraint error. Probably you are trying to create a ChatItem with a User that doesn't exist. Check the AddedBy value.

Dan Pompas wrote:

It's an Oracle integrity constraint error. Probably you are trying to create a ChatItem with a User that doesn't exist. Check the AddedBy value.

 Sorry, but where can I see the AddedBy I don't have it

 

Dan Pompas wrote:

It's an Oracle integrity constraint error. Probably you are trying to create a ChatItem with a User that doesn't exist. Check the AddedBy value.

I find addedby 

 

Yes, AddedBy should be filled with the User Id before creating the ChatItem, for example with GetUserId() function. Also the other parent keys should be filled, e.g. ChatId, ApplicationId, SenderRoleId and ReceiverRoleId.