Activity Disappearing When Using ActivitySequence Process. (Doc ID 2100793.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.1.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 10.1.2.6 version, Activity

Activity disappearing when using ActivitySequence process.

 ActivitySequence is used to spawn multiple activities on the same entity. When processing the activity it disappears.

the activity is in the database but its status code is 72, and for spawned activities it is 71.

ERROR
-----------------------
com.adminserver.utl.exception.AsExceptionUtl: java.sql.SQLException: Conversion failed when converting from a character string to uniqueidentifier.
at com.adminserver.bll.EntityLockBll.acquireEntityLocks(EntityLockBll.java:157)
at com.adminserver.bll.EntityLockBll.acquireEntityLocks(EntityLockBll.java:108)
at com.adminserver.pas.bll.tasks.ActivitySequenceTaskBll.processActivitySequence(ActivitySequenceTaskBll.java:126)
at com.adminserver.pas.bll.ActivityProcessHelper.processActivitySequenceTaskDcl(ActivityProcessHelper.java:1466)
at com.adminserver.pas.bll.ActivityProcessHelper.doActivitySequenceProcessing(ActivityProcessHelper.java:1456)
at com.adminserver.pas.bll.ActivityProcessHelper.processActivity(ActivityProcessHelper.java:187)
at com.adminserver.pas.bll.ActivityBll.process(ActivityBll.java:2784)
at com.adminserver.pas.bll.ActivityBll.process_aroundBody0(ActivityBll.java:2763)
at com.adminserver.pas.bll.ActivityBll$AjcClosure1.run(ActivityBll.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
at com.adminserver.extensibility.helper.aspects.ExtensibilityAspectExecutionHelper.executeReturningExtension(ExtensibilityAspectExecutionHelper.java:62)
at com.adminserver.sre.aspects.BaseSreExtensibilityAspect.executeReturningExtension(BaseSreExtensibilityAspect.java:109)
at com.adminserver.pas.bll.aspects.SreForwardProcessingExtensibilityAspect.ajc$superDispatch$com_adminserver_pas_bll_aspects_SreForwardProcessingExtensibilityAspect$executeReturningExtension(SreForwardProcessingExtensibilityAspect.java:1)
at com.adminserver.pas.bll.aspects.SreForwardProcessingExtensibilityAspect.instrumentActivityBll_process(SreForwardProcessingExtensibilityAspect.java:30)
at com.adminserver.pas.bll.ActivityBll.process(ActivityBll.java:2761)
at com.adminserver.pas.bll.ActivityBll.process(ActivityBll.java:2736)
at com.adminserver.pas.bll.ActivityBll.process(ActivityBll.java:3289)
at com.adminserver.pas.uip.helper.ActivityHelper.processActivity(ActivityHelper.java:29)
at com.adminserver.pas.uip.GroupCustomerActivityUip.processProcessAction_aroundBody14(GroupCustomerActivityUip.java:547)
at com.adminserver.pas.uip.GroupCustomerActivityUip.processProcessAction_aroundBody15$advice(GroupCustomerActivityUip.java:62)
at com.adminserver.pas.uip.GroupCustomerActivityUip.processProcessAction(GroupCustomerActivityUip.java:1)
at com.adminserver.pas.web.GroupCustomerActivityPage.processProcessAction(GroupCustomerActivityPage.java:431)
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:606)
at com.sun.el.parser.AstValue.invoke(AstValue.java:187)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:99)
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:774)
at javax.faces.component.UICommand.broadcast(UICommand.java:372)
at com.icesoft.faces.component.panelseries.UISeries$RowEvent.broadcast(UISeries.java:634)
at com.icesoft.faces.component.panelseries.UISeries.broadcast(UISeries.java:296)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:50)
at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.renderCycle(ReceiveSendUpdates.java:167)
at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.service(ReceiveSendUpdates.java:108)
at com.icesoft.faces.webapp.http.core.RequestVerifier.service(RequestVerifier.java:65)
at com.icesoft.faces.webapp.http.servlet.BasicAdaptingServlet.service(BasicAdaptingServlet.java:51)
at com.icesoft.faces.webapp.http.servlet.SessionVerifier.service(SessionVerifier.java:62)
at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:55)
at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:100)
at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:55)
at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:205)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:67)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLException: Conversion failed when converting from a character string to uniqueidentifier.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:637)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:779)
at net.sourceforge.jtds.jdbcx.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:58)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at com.adminserver.dal.jdbc.JdbcDataAccessHelper.executeStoredProcedure(JdbcDataAccessHelper.java:267)
at com.adminserver.dal.jdbc.JdbcDataAccessHelper.executeStoredProcedure(JdbcDataAccessHelper.java:357)
at com.adminserver.dal.jdbc.JdbcDataAccessHelper.executeStoredProcedure(JdbcDataAccessHelper.java:318)
at com.adminserver.dal.EntityLockDal.lockByOwnerGuid(EntityLockDal.java:194)
at com.adminserver.dal.EntityLockDal$$FastClassByCGLIB$$625ec579.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.adminserver.dal.EntityLockDal$$EnhancerByCGLIB$$55c1f30e.lockByOwnerGuid()
at com.adminserver.bll.EntityLockBll.acquireEntityLocks(EntityLockBll.java:149)
... 67 more





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. log in to the application.
2. Find account.
3. Go to Account Activities tab and
4. Process pending activity.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot find the correctly processed activities.

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