AnsweredAssumed Answered

Workflow SQL node errors after upgrade to 7.1 p03

Question asked by shakti nayak on Aug 10, 2019
Latest reply on Aug 12, 2019 by Mostafa Helmy

Hello,

After upgrade from 7.0.1 P04 to 7.1 P03 , we are facing issues with some sql select nodes. The workflows gets stuck in these nodes intermittently. The workflow is at "ERROR" state.The error message reads as below. error logs from aveksaserver.log

 

ERROR ([ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)') [com.aveksa.gui.core.MainManager]
java.lang.NullPointerException
    at com.aveksa.gui.pages.admin.workflow.base.WorkflowObjectDetailHelper.getDetailHelper(WorkflowObjectDetailHelper.java:153)
    at com.aveksa.gui.pages.admin.workflow.base.WorkflowObjectDetailHelper.printContent(WorkflowObjectDetailHelper.java:129)
    at com.aveksa.gui.pages.admin.workflow.base.detail.WorkflowObjectDetailPageView.printContent(WorkflowObjectDetailPageView.java:34)
    at com.aveksa.gui.pages.admin.workflow.job.detail.WorkflowJobDetailPageView.printContent(WorkflowJobDetailPageView.java:31)
    at com.aveksa.gui.pages.base.view.MainPageView.printPageContentTable(MainPageView.java:308)
    at com.aveksa.gui.pages.base.view.MainPageView.handlePartialPage(MainPageView.java:178)
    at com.aveksa.gui.pages.base.view.MainPageView.handleRequest(MainPageView.java:50)
    at com.aveksa.gui.pages.base.data.PageData.drawView(PageData.java:141)
    at com.aveksa.gui.pages.base.data.PageData.drawView(PageData.java:130)
    at com.aveksa.gui.pages.base.data.PageData.handleRequest(PageData.java:116)
    at com.aveksa.gui.pages.base.data.main.MainPageData.handleRequest(MainPageData.java:45)
    at com.aveksa.gui.pages.PageManager.forwardRequest(PageManager.java:601)
    at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:405)
    at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:271)
    at com.aveksa.gui.core.MainManager.handleRequest(MainManager.java:184)
    at com.aveksa.gui.core.MainManager.doGet(MainManager.java:128)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:134)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    at com.aveksa.gui.core.filters.LoginFilter.doFilter(LoginFilter.java:62)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    at com.aveksa.gui.util.security.XSSFilter.doFilter(XSSFilter.java:20)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3442)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3408)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
    at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1621)
    at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

Outcomes