6 Replies Latest reply on Aug 7, 2014 10:44 PM by Francisco Amores

    FDMEE 11.1.2.3 Check Report Returns Blank

    Reach87

      Hi Everyone -

       

      Experiencing an issue with our FDMEE 11.1.2.3.500 application where check reports are returning entirely blank. Not only is the check rule metadata returning blank (e.g. tile, sub title, target accounts, rules), but the entire report, including header information, which is part of the check report template.  If it was just the check rule information returning blank I would believe it was an improper set up of the check rule logic, but I find it odd that ValidationGroup/Location/Category/Period in the header isn't even being returned.  Few screen shots below for reference:

       

       

      Screen Shot 2014-08-05 at 4.34.19 PM.png

       

       

      Screen Shot 2014-08-05 at 4.36.35 PM.png* Note, the rule in this check rule screenshot is simply checking if the POV is = 0.  As no data is being loaded there, it should pass.   Removing the rule has no impact on the issue.

       

      Few items to note:

      - Default check report has been set to 'Check Report' at the system, application, and user level

      - The check rule group has been assigned to the proper locations

      - This has been tested this with multiple check rule groups and default check reports.  This includes reducing the check rule group to one "Title" row to try to rule out an improper set up of the check rule logic.

      - This has been tested on a separate HFM test app with the same result.

      - I looked at the report query for the check report and saw it was pulling from TDATACHECK table.  When doing a select * SQL query from this table, there are no records.  Found this very odd and likely the root cause of the issue, but unclear why this is occurring.

      - Attaching the full log, but note the following section where I believe the error is occurring (starts line 792 on the log).

       

      2014-08-05 15:22:33,110 DEBUG [AIF]: AIFUtil.callOdiServlet - START

      2014-08-05 15:22:33,203 INFO  [AIF]: ******** BEGIN CHECK PROCESS ************

      2014-08-05 15:22:33,266 INFO  [AIF]: *******************CONDITION LOGIC*********************

      2014-08-05 15:22:34,982 INFO  [AIF]: NO DATA

      2014-08-05 15:22:34,997 INFO  [AIF]: CELL DATA FROM TARGET:0

      2014-08-05 15:22:34,997 INFO  [AIF]: EXPRESSION:round(0,2)

      2014-08-05 15:22:35,075 INFO  [AIF]: RESULT:

      2014-08-05 15:22:35,091 INFO  [AIF]: 0.0

      2014-08-05 15:22:35,091 INFO  [AIF]: EXPRESSION:0.0=0

      2014-08-05 15:22:35,169 ERROR [AIF]:

      2014-08-05 15:22:35,169 INFO  [AIF]: *******************DISPLAY LOGIC*********************

      2014-08-05 15:22:35,512 INFO  [AIF]: NO DATA

      2014-08-05 15:22:35,543 INFO  [AIF]: CELL DATA FROM TARGET:0

      2014-08-05 15:22:35,543 INFO  [AIF]: EXPRESSION:round(0,2)

      2014-08-05 15:22:35,621 INFO  [AIF]: RESULT:

      2014-08-05 15:22:35,621 INFO  [AIF]: 0.0

      2014-08-05 15:22:35,621 INFO  [AIF]: EXPRESSION:0.0

      2014-08-05 15:22:35,715 INFO  [AIF]: RESULT:

      2014-08-05 15:22:35,715 INFO  [AIF]: 0.0

      2014-08-05 15:22:35,715 ERROR [AIF]:

      2014-08-05 15:22:35,715 ERROR [AIF]: Error occured while running check rule.

      2014-08-05 15:22:35,731 DEBUG [AIF]: AIFUtil.callOdiServlet - END

      2014-08-05 15:22:35,731 FATAL [AIF]: Error in CommData.checkData

      Traceback (most recent call last):

        File "<string>", line 4730, in checkData

      RuntimeError: java.lang.RuntimeException: Error occured during Check Process.

       

       

      2014-08-05 15:22:35,731 DEBUG [AIF]: CommData.updateWorkflow - START

      2014-08-05 15:22:35,731 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

             

              ,PROCESSSTATUS = 42

                ,PROCESSENTVAL = 0

                ,PROCESSENTVALNOTE = 'Check Error'

              WHERE PARTITIONKEY = 13

              AND CATKEY = 1

              AND PERIODKEY = '2015-12-01'

              AND RULE_ID = 17

       

      Please let me know if you have any questions or need any other information.  Thanks for any help in advance.

       

      - Dan H.

        • 1. Re: FDMEE 11.1.2.3 Check Report Returns Blank
          Francisco Amores

          Hi,

           

          your display value for rules is #ModleRule instead of #ModeRule

           

          Can you fix this and try again?

           

          Also, have you checked ERPIntergator0.log?

           

          Regards

          1 person found this helpful
          • 2. Re: FDMEE 11.1.2.3 Check Report Returns Blank
            Francisco Amores

            For example, the following check group is working perfectly:

            checkrule.png

            • 3. Re: FDMEE 11.1.2.3 Check Report Returns Blank
              Reach87

              Thanks for the input Francisco.  Unfortunately correcting the mode list label produces the same result of a blank check report.  I recreated a version of your check rule (minus the last rule) to see if there was anything in the check rule itself that would be causing the issue, unfortunately I get the same result (screen shot below for reference).

               

              Screen Shot 2014-08-06 at 10.33.50 AM.png

               

              I'm posting a section of the ERPIntegrator Log below.  I noted the line "ODI-1217: Session COMM_LOAD_BALANCES (534501) fails with return code 7000."  This was resolved on another OTN post for ODI ODI-1217: (6003) fails  with return code 7000. but it's not clear at the moment if/how that could be resolved via FDMEE.

               

               

               

               

              [2014-08-06T09:44:11.204-04:00] [ErpIntegrator0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 21] [userId: <anonymous>] [ecid: 0000KUfZiHK5UcG6yzV^6G1JsE0v00001L,1:21960:1] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HFMService] [SRC_METHOD: pd]  [HFMService] Info:[checkData:355,Jun - 2014] END (java.lang.RuntimeException: Error occured during Check Process.)

              [2014-08-06T09:44:11.204-04:00] [ErpIntegrator0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 21] [userId: <anonymous>] [ecid: 0000KUfZiHK5UcG6yzV^6G1JsE0v00001L,1:21960:1] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.util.AIFUtil] [SRC_METHOD: getFileName] File name \\TEST-HYPFND01\fdmdata\FDMEE\outbox\logs\RCAPHFM_355.log

              [2014-08-06T09:44:11.204-04:00] [ErpIntegrator0] [NOTIFICATION] [] [oracle.apps.erpi.ui] [tid: 21] [userId: <anonymous>] [ecid: 0000KUfZiHK5UcG6yzV^6G1JsE0v00001L,1:21960:1] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.servlet.ODIServlet] [SRC_METHOD: doPost] response msg:java.lang.RuntimeException: Error occured during Check Process.

              [2014-08-06T09:44:12.078-04:00] [ErpIntegrator0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 102] [userId: <anonymous>] [ecid: 0000KUfZiHK5UcG6yzV^6G1JsE0v00001L,1:21960:1] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [SRC_METHOD: invoke_odi_process] Extract id:534501, status:Session Failed :534501 : ODI-1217: Session COMM_LOAD_BALANCES (534501) fails with return code 7000.[[

              ODI-1226: Step FAILED - Check Data fails after 1 attempt(s).

              ODI-1232: Procedure COMM Finalize Process execution fails.

              Caused By: org.apache.bsf.BSFException: exception from Jython:

              Traceback (most recent call last):

                File "<string>", line 13, in <module>

                File "<string>", line 162, in finalizeProcess

              RuntimeError: ODI-1226: Step COMM Check Data fails after 1 attempt(s).

              ODI-1232: Procedure COMM Check Data execution fails.

              Caused By: org.apache.bsf.BSFException: exception from Jython:

              Traceback (most recent call last):

                File "<string>", line 9, in <module>

                File "<string>", line 4730, in checkData

              RuntimeError: java.lang.RuntimeException: Error occured during Check Process.

               

               

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

                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:27)

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

                at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

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

                at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

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

                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: Traceback (most recent call last):

                File "<string>", line 9, in <module>

                File "<string>", line 4730, in checkData

              RuntimeError: java.lang.RuntimeException: Error occured during Check Process.

               

               

                at org.python.core.PyException.fillInStackTrace(PyException.java:70)

                at java.lang.Throwable.<init>(Throwable.java:181)

                at java.lang.Exception.<init>(Exception.java:29)

                at java.lang.RuntimeException.<init>(RuntimeException.java:32)

                at org.python.core.PyException.<init>(PyException.java:46)

                at org.python.core.PyException.doRaise(PyException.java:200)

                at org.python.core.Py.makeException(Py.java:1166)

                at org.python.core.Py.makeException(Py.java:1170)

                at org.python.core.Py.makeException(Py.java:1174)

                at org.python.core.Py.makeException(Py.java:1178)

                at org.python.pycode._pyx1195.checkData$37(<string>:4759)

                at org.python.pycode._pyx1195.call_function(<string>)

                at org.python.core.PyTableCode.call(PyTableCode.java:165)

                at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

                at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

                at org.python.core.PyFunction.__call__(PyFunction.java:385)

                at org.python.core.PyMethod.__call__(PyMethod.java:215)

                at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

                at org.python.core.PyMethod.__call__(PyMethod.java:206)

                at org.python.core.PyObject.__call__(PyObject.java:432)

                at org.python.core.PyObject.__call__(PyObject.java:436)

                at org.python.pycode._pyx1228.f$0(<string>:9)

                at org.python.pycode._pyx1228.call_function(<string>)

                at org.python.core.PyTableCode.call(PyTableCode.java:165)

                at org.python.core.PyCode.call(PyCode.java:18)

                at org.python.core.Py.runCode(Py.java:1204)

                at org.python.core.Py.exec(Py.java:1248)

                at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                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 oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

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

                at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

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

                ... 9 more

               

               

               

               

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

                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:27)

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

                at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

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

                at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

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

                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: Traceback (most recent call last):

                File "<string>", line 13, in <module>

                File "<string>", line 162, in finalizeProcess

              RuntimeError: ODI-1226: Step COMM Check Data fails after 1 attempt(s).

              ODI-1232: Procedure COMM Check Data execution fails.

              Caused By: org.apache.bsf.BSFException: exception from Jython:

              Traceback (most recent call last):

                File "<string>", line 9, in <module>

                File "<string>", line 4730, in checkData

              RuntimeError: java.lang.RuntimeException: Error occured during Check Process.

               

               

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)

                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:27)

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

                at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

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

                at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

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

                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: Traceback (most recent call last):

                File "<string>", line 9, in <module>

                File "<string>", line 4730, in checkData

              RuntimeError: java.lang.RuntimeException: Error occured during Check Process.

               

               

                at org.python.core.PyException.fillInStackTrace(PyException.java:70)

                at java.lang.Throwable.<init>(Throwable.java:181)

                at java.lang.Exception.<init>(Exception.java:29)

                at java.lang.RuntimeException.<init>(RuntimeException.java:32)

                at org.python.core.PyException.<init>(PyException.java:46)

                at org.python.core.PyException.doRaise(PyException.java:200)

                at org.python.core.Py.makeException(Py.java:1166)

                at org.python.core.Py.makeException(Py.java:1170)

                at org.python.core.Py.makeException(Py.java:1174)

                at org.python.core.Py.makeException(Py.java:1178)

                at org.python.pycode._pyx1195.checkData$37(<string>:4759)

                at org.python.pycode._pyx1195.call_function(<string>)

                at org.python.core.PyTableCode.call(PyTableCode.java:165)

                at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

                at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

                at org.python.core.PyFunction.__call__(PyFunction.java:385)

                at org.python.core.PyMethod.__call__(PyMethod.java:215)

                at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

                at org.python.core.PyMethod.__call__(PyMethod.java:206)

                at org.python.core.PyObject.__call__(PyObject.java:432)

                at org.python.core.PyObject.__call__(PyObject.java:436)

                at org.python.pycode._pyx1228.f$0(<string>:9)

                at org.python.pycode._pyx1228.call_function(<string>)

                at org.python.core.PyTableCode.call(PyTableCode.java:165)

                at org.python.core.PyCode.call(PyCode.java:18)

                at org.python.core.Py.runCode(Py.java:1204)

                at org.python.core.Py.exec(Py.java:1248)

                at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                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 oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

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

                at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

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

                ... 9 more

               

               

               

               

                at org.python.core.PyException.fillInStackTrace(PyException.java:70)

                at java.lang.Throwable.<init>(Throwable.java:181)

                at java.lang.Exception.<init>(Exception.java:29)

                at java.lang.RuntimeException.<init>(RuntimeException.java:32)

                at org.python.core.PyException.<init>(PyException.java:46)

                at org.python.core.PyException.doRaise(PyException.java:200)

                at org.python.core.Py.makeException(Py.java:1166)

                at org.python.core.Py.makeException(Py.java:1170)

                at org.python.pycode._pyx1193.finalizeProcess$6(<string>:164)

                at org.python.pycode._pyx1193.call_function(<string>)

                at org.python.core.PyTableCode.call(PyTableCode.java:165)

                at org.python.core.PyBaseCode.call(PyBaseCode.java:297)

                at org.python.core.PyBaseCode.call(PyBaseCode.java:191)

                at org.python.core.PyFunction.__call__(PyFunction.java:385)

                at org.python.core.PyMethod.__call__(PyMethod.java:215)

                at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

                at org.python.core.PyMethod.__call__(PyMethod.java:206)

                at org.python.core.PyObject.__call__(PyObject.java:367)

                at org.python.core.PyObject.__call__(PyObject.java:371)

                at org.python.pycode._pyx1229.f$0(<string>:13)

                at org.python.pycode._pyx1229.call_function(<string>)

                at org.python.core.PyTableCode.call(PyTableCode.java:165)

                at org.python.core.PyCode.call(PyCode.java:18)

                at org.python.core.Py.runCode(Py.java:1204)

                at org.python.core.Py.exec(Py.java:1248)

                at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                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 oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

                at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

                at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

                at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

                at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

                at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

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

                at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

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

                ... 9 more

               

               

              ]]

              ####<Aug 6, 2014 9:46:12 AM EDT> <Info> <JDBC> <TEST-HYPFND01> <ErpIntegrator0> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1407332772985> <BEA-001128> <Connection for pool "odiMasterRepository" has been closed.>

              ####<Aug 6, 2014 9:46:12 AM EDT> <Info> <JDBC> <TEST-HYPFND01> <ErpIntegrator0> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1407332772985> <BEA-001128> <Connection for pool "odiMasterRepository" has been closed.>

              • 4. Re: FDMEE 11.1.2.3 Check Report Returns Blank
                Francisco Amores

                Hi,

                 

                after reviewing your log:

                 

                2014-08-05 15:22:33,110 DEBUG [AIF]: CommData.updateWorkflow - END

                2014-08-05 15:22:33,110 DEBUG [AIF]: AIFUtil.callOdiServlet - START

                2014-08-05 15:22:33,203 INFO  [AIF]: ******** BEGIN CHECK PROCESS ************

                2014-08-05 15:22:33,266 INFO  [AIF]: *******************CONDITION LOGIC*********************

                2014-08-05 15:22:34,982 INFO  [AIF]: NO DATA

                2014-08-05 15:22:34,997 INFO  [AIF]: CELL DATA FROM TARGET:0

                2014-08-05 15:22:34,997 INFO  [AIF]: EXPRESSION:round(0,2)

                2014-08-05 15:22:35,075 INFO  [AIF]: RESULT:

                2014-08-05 15:22:35,091 INFO  [AIF]: 0.0

                2014-08-05 15:22:35,091 INFO  [AIF]: EXPRESSION:0.0=0

                2014-08-05 15:22:35,169 ERROR [AIF]:

                2014-08-05 15:22:35,169 INFO  [AIF]: *******************DISPLAY LOGIC*********************

                2014-08-05 15:22:35,512 INFO  [AIF]: NO DATA

                2014-08-05 15:22:35,543 INFO  [AIF]: CELL DATA FROM TARGET:0

                2014-08-05 15:22:35,543 INFO  [AIF]: EXPRESSION:round(0,2)

                2014-08-05 15:22:35,621 INFO  [AIF]: RESULT:

                2014-08-05 15:22:35,621 INFO  [AIF]: 0.0

                2014-08-05 15:22:35,621 INFO  [AIF]: EXPRESSION:0.0

                2014-08-05 15:22:35,715 INFO  [AIF]: RESULT:

                2014-08-05 15:22:35,715 INFO  [AIF]: 0.0

                2014-08-05 15:22:35,715 ERROR [AIF]:

                2014-08-05 15:22:35,715 ERROR [AIF]: Error occured while running check rule.

                 

                It seems that there are issues with your check rules. Have you checked them carefully?

                HFM data is inserted into TDATACHECK based on your definition.

                Please try with a simple rule for one account. Use the wizard to create the rule so you don't miss any field

                 

                Regards

                • 5. Re: FDMEE 11.1.2.3 Check Report Returns Blank
                  Reach87

                  You are correct.  I made the cardinal sin of not reading from the admin guide, from the 'Add Rule Logic' of the Check Rule section:

                  Screen Shot 2014-08-07 at 12.43.37 PM.png

                   

                  Updated the rule logic and entire report returns fine.  I tried finding potentially something else that could have caused the issue since I tried the rule a few different ways (greater than, less than) when troubleshooting - possibly the misspelling in my initial set up.  So takeaway for others is any problems in the check report logic returns a totally blank report, and make sure the check your spelling and read the admin guide before posting on OTN

                   

                  Thanks for the assistance!

                  • 6. Re: FDMEE 11.1.2.3 Check Report Returns Blank
                    Francisco Amores

                    Glad to see issue is solved.

                    Honestly I skipped that from the error log:

                    2014-08-05 15:22:35,091 INFO  [AIF]: 0.0

                    2014-08-05 15:22:35,091 INFO  [AIF]: EXPRESSION:0.0=0


                    There is 0.0=0 and then the error is raised.

                    Thanks for sharing your feedback

                     

                    Regards