Oracle SOA Business rule Fact not found in the rule engine working memory

The following error comes sometimes in Oracle SOA suite business rule.

Fact not found in the rule engine working memory, rule session execution failed. This is most likely a rule modeling error.

I was facing the same issue while working on business rule. The error was coming due to schema issues or namespace issues in schema. If you create a separate application and test this using the same schema the chances of error would be very less. I just created a new XSD with new target namespace and copy pasted the existing elements/complex elements into new xsd not namespaces, then it started working fine. 

Read More

Oracle BPM 12c vacation rule

Recently I was trying to use Oracle BPM 12c vacation rule but it was not working for me. I also posted on Oracle community and following was the detailed problem.

 Oracle BPM 12c vacation rule issue

How it worked for me then? So go to your .task file of that user like manager in my case as shown below in snapshot.

Now double click on default.DefaultPerformet activity and go to properties. Then from General tab select names and expression from Build a list of participants from using dropdown list. Now at the bottom under participant name create a new participant i.e manager in my case as shown below.

Now save all the changes and redeploy the application. This time vacation rule will work fine. 

Read More

Oracle SOA BPEL Email error Could not connect to SMTP host: smtp.gmail.com

I configured email server in Enterprise Manger and then I used email activity in BPEL to send notifications. But I was facing the below issue. After much troubleshooting I figured it out as network issue. My server was behind proxy server and it was blocking such type traffic then I have to check it with network guy who unblocked this port and then my emails started working properly.

<Warning> <oracle.sdpinternal.messaging.driver.email.outbound.EmailOutboundConnection> <SDP-26106> <Failed to send the e-mail message
javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465;
  nested exception is:
        java.net.ConnectException: Connection timed out
        at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1934)

Read More

Oracle BPM 12c error ADF_FACES-60097, ADF_FACES-60096 server exception during PPR #15

Recently I was working on Oracle BPM 12.1.3 and I was constantly getting the following error

Error ADF_FACES-60097, ADF_FACES-60096 server exception during PPR #15

I also asked on Oracle community page and somehow got ride but for just short time and its started appearing again and again. If you are facing the same issue in 12.1.3 then raise an SR and you will be asked to apply a patch to fix this bug. I was too facing issues like that and after applying patch it started working fine.

Error detail from log file

[2015-02-26T12:35:06.794+05:00] [soa_server1] [ERROR] [] [oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: initiator] [ecid: a3b8db13-d7c5-47c9-a9e1-c0dd3894eacc-00000427,0] [APP: OracleBPMWorkspace] [DSID: 0000Kj4naO1FKAWFLzuHOA1KvgQ7000004] ADF_FACES-60096:Server Exception during PPR, #2[[

java.lang.NullPointerException

  at oracle.adfinternal.view.faces.util.rich.PartialResponseUtils$ExtendedPartialResponseWriter.redirect(PartialResponseUtils.java:279)

  at oracle.adfinternal.view.faces.util.rich.PartialResponseUtils.writeRedirect(PartialResponseUtils.java:212)

  at oracle.adfinternal.view.faces.config.rich.XmlHttpServletResponse.sendRedirect(XmlHttpServletResponse.java:110)

  at oracle.help.web.rich.OHWFilter.doFilter(OHWFilter.java:381)

  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

  at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

Read More

Oracle BAM 12C error(BEA-240003,SPI:260112) while updating OracleBamAdapter

While updating Oracle BAM 12 adpater OracleBamAdapter I was facing the below error. After troubleshooting I figured out that OracleBamAdapter was not targeted to any server. To resolve this issue go to Deployments, then click on OracleBamAdapter and then select Targets from top menu bar of OracleBamAdapter  setting. From the servers list select any server like bam_server1 and hit save. Now try to update OracleBamAdapter  again and you will not face this issue. Hope this will help.

<Jun 2, 2015 1:15:21 PM PKT> <Error> <Console> <BEA-240003> <Administration Console encountered the following error: java.lang.IllegalArgumentException: [J2EE Deployment SPI:260112]Unable to determine application name from null or empty TargetModuleID list.
        at weblogic.deploy.api.internal.utils.ConfigHelper.getAppName(ConfigHelper.java:218)
        at weblogic.deploy.api.spi.deploy.internal.UpdateOperation.setupPaths(UpdateOperation.java:86)
        at weblogic.deploy.api.spi.deploy.internal.BasicOperation.run(BasicOperation.java:177)
        at weblogic.deploy.api.spi.deploy.internal.RedeployOperation.run(RedeployOperation.java:50)
        at weblogic.deploy.api.spi.deploy.WebLogicDeploymentManagerImpl.update(WebLogicDeploymentManagerImpl.java:395)
        at com.bea.console.actions.app.update.Flow.finish(Flow.java:790)
        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 org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870)
        at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
        at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
        at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
        at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
        at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
        at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
        at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
        at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:64)
        at org.apache.beehive.netui.pageflow.interceptor.action.ActionInterceptor.wrapAction(ActionInterceptor.java:184)
        at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.invoke(ActionInterceptors.java:50)
        at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:58)
        at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:87)
        at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
        at com.bea.console.internal.ConsolePageFlowRequestProcessor.processActionPerform(ConsolePageFlowRequestProcessor.java:264)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
        at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
        at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
        at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
        at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
        at com.bea.console.internal.ConsoleActionServlet.process(ConsoleActionServlet.java:262)
        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
        at com.bea.console.internal.ConsoleActionServlet.doGet(ConsoleActionServlet.java:134)
        at org.apache.beehive.netui.pageflow.PageFlowUtils.strutsLookup(PageFlowUtils.java:1199)
        at org.apache.beehive.netui.pageflow.PageFlowUtils.strutsLookup(PageFlowUtils.java:1129)
        at com.bea.portlet.adapter.scopedcontent.framework.internal.PageFlowUtilsBeehiveDelegate.strutsLookupInternal(PageFlowUtilsBeehiveDelegate.java:43)
        at com.bea.portlet.adapter.scopedcontent.framework.PageFlowUtils.strutsLookup(PageFlowUtils.java:108)
        at com.bea.portlet.adapter.scopedcontent.ScopedContentCommonSupport.executeAction(ScopedContentCommonSupport.java:707)
        at com.bea.portlet.adapter.scopedcontent.ScopedContentCommonSupport.processActionInternal(ScopedContentCommonSupport.java:141)
        at com.bea.portlet.adapter.scopedcontent.PageFlowStubImpl.processAction(PageFlowStubImpl.java:108)
        at com.bea.portlet.adapter.NetuiActionHandler.raiseScopedAction(NetuiActionHandler.java:111)
        at com.bea.netuix.servlets.controls.content.NetuiContent.raiseScopedAction(NetuiContent.java:181)
        at com.bea.netuix.servlets.controls.content.NetuiContent.raiseScopedAction(NetuiContent.java:167)
        at com.bea.netuix.servlets.controls.content.NetuiContent.handlePostbackData(NetuiContent.java:225)
        at com.bea.netuix.nf.ControlLifecycle$2.visit(ControlLifecycle.java:180)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:324)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)
        at com.bea.netuix.nf.ControlTreeWalker.walk(ControlTreeWalker.java:130)
        at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:399)
        at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:361)
        at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:352)
        at com.bea.netuix.nf.Lifecycle.runInbound(Lifecycle.java:184)
        at com.bea.netuix.nf.Lifecycle.run(Lifecycle.java:159)
        at com.bea.netuix.servlets.manager.UIServlet.runLifecycle(UIServlet.java:465)
        at com.bea.netuix.servlets.manager.UIServlet.doPost(UIServlet.java:291)
        at com.bea.netuix.servlets.manager.UIServlet.service(UIServlet.java:219)
        at com.bea.netuix.servlets.manager.SingleFileServlet.service(SingleFileServlet.java:275)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
        at com.bea.console.utils.MBeanUtilsInitSingleFileServlet.service(MBeanUtilsInitSingleFileServlet.java:64)
        at weblogic.servlet.AsyncInitServlet.service(AsyncInitServlet.java:125)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
        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 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:3436)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
        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:2285)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)
        at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

Read More

SQLDeveloper is not connecting to remote database

I have already written a post on SQL Developer connectivity problem. But recently I got one new error while connecting SQLDeveloper to remote database. First as I mentioned in my last post set proxy if you are using any in your SQLDeveloper and then try to connect it. But If it still gives the error then tried this workaround and I hope it will be helpful too. Sometime when we are connecting more than one internet connection due to any reason like client sides visit, home, office etc, our network connection get increased under network and sharing center and at a time more than one network remain Enable even if they are not connected to any network, so here comes the problem. Disable all of your network you are not using currently like I did in below screenshot and just Enable only network you are currently working with. After doing this try to connect your SQLDeveloper with remote DB again and it should work now and I hope it will be helpful too.

Read More

Linux command to set ORACLE_HOME temporary

When someone is newbie, these types of command are really helpful. I just want to share how to set  ORACLE_HOME path easily. Following is the command.

export ORACLE_HOME=/Oracle/Middleware/Oracle_Home

To check ORACLE_HOME use the following command

echo $ORACLE_HOME
It should be:

/Oracle/Middleware/Oracle_Home

Read More