ORA-02291: integrity constraint (T1_OS_ADMIN_O.OSFRK_OSUSR_WJW_CHATITEM_37739) violated - parent key not foundORA-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:
Sorry, but where can I see the AddedBy I don't have it
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.