5 Replies Latest reply on Nov 18, 2019 2:22 PM by AbanoubZaki

    Error during ODI Process Submission.

    AbanoubZaki

      Hello All,

       

      I am gettting the below message when trying to press import/validate/export data in FDMEE

       

      "Error during ODI Process Submission. ODI Connection information may not be correct or ODI Agent may not be running. Please check and resubmit the job"

       

      But when I check the ODI connection and test it says that its connected

       

      In Process Log we get only the first 4 lines and it stays stuck there:

       

      2019-11-14 11:09:50,475 INFO  [AIF]: FDMEE Process: 432, Log Level: 5, Log File: C:\Oracle\Middleware\user_projects\domains\EPMSystem\Home\outbox\logs\DMG_432.log

      2019-11-14 11:09:50,475 INFO  [AIF]: Location     : DMG WF (Partitionkey:21)

      2019-11-14 11:09:50,475 INFO  [AIF]: Period Name  : Sep-19 (Period Key:9/30/19 12:00 AM)

      2019-11-14 11:09:50,475 INFO  [AIF]: Category Name: Actual (Category key:5)

      2019-11-14 11:09:50,475 INFO  [AIF]: Rule Name    : DMG WF (Rule ID:23)

        • 1. Re: Error during ODI Process Submission.
          WPaffhausen

          Hello AbanoubZaki,

           

          There is a bit of confusion here as you are looking at two different concepts.  The AGENT which is suffering an issue is not what you CHECKED in the lower screenshot.  The screenshot in the bottom is pure JDBC connection details, while the AGENT is based upon HTTP/S transport details based on the Oracle HTTP server.

           

          You would need to check the ODIAGENT.LOG in the EPM logs directory ./ErpIntegrator0/servers/logs/odiagent for more details.  You can also try to restart the FDMEE service if necessary.

           

          Thank you,
          Wayne

          • 2. Re: Error during ODI Process Submission.
            AbanoubZaki

            Hello Wayne

             

            please check the below screenshot:

             

            error.png

            please advise.

            • 3. Re: Error during ODI Process Submission.
              AbanoubZaki

              Also please find the below error while trying to start the ODIAgent:

               

               

              Failed to get Messages for target /Farm_EPMSystem/EPMSystem/AdminServer, /Farm_EPMSystem/EPMSystem/AdminServer/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/AdminServer/FMW Welcome Page Application(11.1.0.0.0), /Farm_EPMSystem/EPMSystem/AdminServer/em, /Farm_EPMSystem/EPMSystem/AdminServer/wsil-wls, /Farm_EPMSystem/EPMSystem/AnalyticProviderServices0, /Farm_EPMSystem/EPMSystem/AnalyticProviderServices0/APS(11.1.2.0), /Farm_EPMSystem/EPMSystem/AnalyticProviderServices0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/AnalyticProviderServices0/wsil-wls, /Farm_EPMSystem/EPMSystem/CalcMgr0, /Farm_EPMSystem/EPMSystem/CalcMgr0/CALC(11.1.2.0), /Farm_EPMSystem/EPMSystem/CalcMgr0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/CalcMgr0/wsil-wls, /Farm_EPMSystem/EPMSystem/EPMServer0, /Farm_EPMSystem/EPMSystem/EPMServer0/CALC(11.1.2.0), /Farm_EPMSystem/EPMSystem/EPMServer0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/EPMServer0/SHAREDSERVICES(11.1.2.0), /Farm_EPMSystem/EPMSystem/EPMServer0/WORKSPACE(11.1.2.0), /Farm_EPMSystem/EPMSystem/EPMServer0/proxyservlet(11.1.2.2), /Farm_EPMSystem/EPMSystem/EPMServer0/staticcontent(11.1.2.2), /Farm_EPMSystem/EPMSystem/EPMServer0/wsil-wls, /Farm_EPMSystem/EPMSystem/ErpIntegrator0, /Farm_EPMSystem/EPMSystem/ErpIntegrator0/AIF(11.1.2.0), /Farm_EPMSystem/EPMSystem/ErpIntegrator0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/ErpIntegrator0/odiconsole, /Farm_EPMSystem/EPMSystem/ErpIntegrator0/oraclediagent, /Farm_EPMSystem/EPMSystem/ErpIntegrator0/wsil-wls, /Farm_EPMSystem/EPMSystem/EssbaseAdminServices0, /Farm_EPMSystem/EPMSystem/EssbaseAdminServices0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/EssbaseAdminServices0/EAS(11.1.2.0), /Farm_EPMSystem/EPMSystem/EssbaseAdminServices0/wsil-wls, /Farm_EPMSystem/EPMSystem/FinancialReporting0, /Farm_EPMSystem/EPMSystem/FinancialReporting0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/FinancialReporting0/FINANCIALREPORTING(11.1.2.0), /Farm_EPMSystem/EPMSystem/FinancialReporting0/wsil-wls, /Farm_EPMSystem/EPMSystem/FoundationServices0, /Farm_EPMSystem/EPMSystem/FoundationServices0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/FoundationServices0/SHAREDSERVICES(11.1.2.0), /Farm_EPMSystem/EPMSystem/FoundationServices0/WORKSPACE(11.1.2.0), /Farm_EPMSystem/EPMSystem/FoundationServices0/proxyservlet(11.1.2.2), /Farm_EPMSystem/EPMSystem/FoundationServices0/staticcontent(11.1.2.2), /Farm_EPMSystem/EPMSystem/FoundationServices0/wsil-wls, /Farm_EPMSystem/EPMSystem/Planning0, /Farm_EPMSystem/EPMSystem/Planning0/DMS Application(11.1.1.1.0), /Farm_EPMSystem/EPMSystem/Planning0/PLANNING(11.1.2.0), /Farm_EPMSystem/EPMSystem/Planning0/wsil-wls.

              • 4. Re: Error during ODI Process Submission.
                WPaffhausen

                The screenshot you provided if for the WebLogic Admin Console.... not the ODIConsole.  Two completely different products.  So I cannot comment.

                 

                While I'm sure this issue needs to be resolved as well, it is another post/topic in another forum. 
                I pointed you to where the logs for the ODI Agent are stored:  %EPM_ORACLE_HOME%\user_projects\domains\EPMSystem\servers\<deployment>\logs\oracledi

                 

                Thank you,
                Wayne

                • 5. Re: Error during ODI Process Submission.
                  AbanoubZaki

                  Please find below error from the log file:

                   

                  [2019-11-16T20:30:46.601+02:00] [ErpIntegrator0] [ERROR] [ODI-1131] [] [tid: 15] [userId: <anonymous>] [ecid: 0000Mte_f_h56i15zvH7iW1TnNPp000000,1:18279] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1406: Agent OracleDIAgent started with warning: JDBC connection error occurs while connecting to the work repository FDMEE. Caused by: ODI-10182: Uncategorized exception during repository access.    [[

                  Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: ConnectionFactoryAdapter returned null ODI-1406: Agent OracleDIAgent started with warning: JDBC connection error occurs while connecting to the work repository FDMEE.

                  Caused By: oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.   

                  Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: ConnectionFactoryAdapter returned null

                   

                  please advise.

                  Thank you