1 2 Previous Next 23 Replies Latest reply: Sep 25, 2014 3:20 AM by RMarques Go to original post RSS
      • 15. Re: Cannot load metadata from EBS
        RMarques

        Hi Craig,

         

        I've opened severity 2 SR.

        The are taking too long to answer and I've uploaded everything, including screenshots, ziplogs, validade, etc.

        And the guy said that as he is not a Planning guy he opened a collaborative SR.

        Lets wait,

         

        Thanks

         

        Rafael

        • 16. Re: Cannot load metadata from EBS
          Francisco Amores

          Hi,

           

          have you changed anything in ODI Scenario SCEN_COMM_LOAD_MEMBERS_TO_PLANNING_001.xml?

           

          Also, can you attached the ODI Operator Log for the step where metadata is loaded into planning?

           

          Thanks

          • 17. Re: Cannot load metadata from EBS
            RMarques

            Hi Francisco,

             

            Nothing changed at ODI Scenario.

             

            Odd thing, because he says Unable to connect to Essbase, but it can be done manually in Planning/Refresh

             

            Log:

             

            [Wed Jul 02 19:30:11 EST 2014]Load dimension "Product" has been unlocked successfully.

            [Wed Jul 02 19:30:11 EST 2014]Performing cube refresh...

            [Wed Jul 02 19:30:11 EST 2014]An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

            Verify that Hyperion Essbase is running and check your network connections.

            [Wed Jul 02 19:30:11 EST 2014]An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

            Verify that Hyperion Essbase is running and check your network connections.

            [Wed Jul 02 19:30:11 EST 2014]Unable to obtain dimension information and/or perform a data load: An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

            Verify that Hyperion Essbase is running and check your network connections.

            [Wed Jul 02 19:30:11 EST 2014]Unable to obtain dimension information and/or perform a data load: An error occurred during the cube refresh operation: com.hyperion.planning.HspRuntimeException: Unable to connect to Hyperion Essbase.

            Verify that Hyperion Essbase is running and check your network connections.

            [Wed Jul 02 19:30:11 EST 2014]Trace information: com.hyperion.planning.utils.HspOutlineLoad::parseAndLoadInputFile:1912, com.hyperion.planning.utils.HspOutlineLoad::halAdapterInfoAndLoad:304, com.hyperion.planning.utils.HspOutlineLoad::loadAndPrintStatus:4667, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImpl:3752, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3692, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3810, com.hyperion.aif.webservices.HPLService::loadMetadata:500, sun.reflect.NativeMethodAccessorImpl::invoke0:-2, sun.reflect.NativeMethodAccessorImpl::invoke:39, sun.reflect.DelegatingMethodAccessorImpl::invoke:25, java.lang.reflect.Method::invoke:597, com.hyperion.aif.servlet.ODIServlet::doPost:97, javax.servlet.http.HttpServlet::service:727, javax.servlet.http.HttpServlet::service:820, weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction::run:227, weblogic.servlet.internal.StubSecurityHelper::invokeServlet:125, weblogic.servlet.internal.ServletStubImpl::execute:301, weblogic.servlet.internal.TailFilter::doFilter:26, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.security.jps.ee.http.JpsAbsFilter$1::run:119, oracle.security.jps.util.JpsSubject::doAsPrivileged:324, oracle.security.jps.ee.util.JpsPlatformUtil::runJaasMode:460, oracle.security.jps.ee.http.JpsAbsFilter::runJaasMode:103, oracle.security.jps.ee.http.JpsAbsFilter::doFilter:171, oracle.security.jps.ee.http.JpsFilter::doFilter:71, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.dms.servlet.DMSServletFilter::doFilter:163, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.RequestEventsFilter::doFilter:27, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::wrapRun:3730, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::run:3696, weblogic.security.acl.internal.AuthenticatedSubject::doAs:321, weblogic.security.service.SecurityManager::runAs:120, weblogic.servlet.internal.WebAppServletContext::securedExecute:2273, weblogic.servlet.internal.WebAppServletContext::execute:2179, weblogic.servlet.internal.ServletRequestImpl::run:1490, weblogic.work.ExecuteThread::execute:256, weblogic.work.ExecuteThread::run:221

            [Wed Jul 02 19:30:11 EST 2014]Trace information: com.hyperion.planning.utils.HspOutlineLoad::parseAndLoadInputFile:1912, com.hyperion.planning.utils.HspOutlineLoad::halAdapterInfoAndLoad:304, com.hyperion.planning.utils.HspOutlineLoad::loadAndPrintStatus:4667, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImpl:3752, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3692, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:3810, com.hyperion.aif.webservices.HPLService::loadMetadata:500, sun.reflect.NativeMethodAccessorImpl::invoke0:-2, sun.reflect.NativeMethodAccessorImpl::invoke:39, sun.reflect.DelegatingMethodAccessorImpl::invoke:25, java.lang.reflect.Method::invoke:597, com.hyperion.aif.servlet.ODIServlet::doPost:97, javax.servlet.http.HttpServlet::service:727, javax.servlet.http.HttpServlet::service:820, weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction::run:227, weblogic.servlet.internal.StubSecurityHelper::invokeServlet:125, weblogic.servlet.internal.ServletStubImpl::execute:301, weblogic.servlet.internal.TailFilter::doFilter:26, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.security.jps.ee.http.JpsAbsFilter$1::run:119, oracle.security.jps.util.JpsSubject::doAsPrivileged:324, oracle.security.jps.ee.util.JpsPlatformUtil::runJaasMode:460, oracle.security.jps.ee.http.JpsAbsFilter::runJaasMode:103, oracle.security.jps.ee.http.JpsAbsFilter::doFilter:171, oracle.security.jps.ee.http.JpsFilter::doFilter:71, weblogic.servlet.internal.FilterChainImpl::doFilter:56, oracle.dms.servlet.DMSServletFilter::doFilter:163, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.RequestEventsFilter::doFilter:27, weblogic.servlet.internal.FilterChainImpl::doFilter:56, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::wrapRun:3730, weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction::run:3696, weblogic.security.acl.internal.AuthenticatedSubject::doAs:321, weblogic.security.service.SecurityManager::runAs:120, weblogic.servlet.internal.WebAppServletContext::securedExecute:2273, weblogic.servlet.internal.WebAppServletContext::execute:2179, weblogic.servlet.internal.ServletRequestImpl::run:1490, weblogic.work.ExecuteThread::execute:256, weblogic.work.ExecuteThread::run:221

            Planning Outline data store load process finished. 707 data records were read, 707 data records were processed, 674 were accepted for loading (verify actual load with Essbase log files), 33 were rejected.

            [Wed Jul 02 19:30:11 EST 2014]Planning Outline data store load process finished. 707 data records were read, 707 data records were processed, 674 were accepted for loading (verify actual load with Essbase log files), 33 were rejected.

             

             

            2014-07-02 19:30:11,290 INFO  [AIF]: Product dimension load completed - Records Read: 707, Records Rejected: 33, Records Processed: 707.

            2014-07-02 19:30:11,292 INFO  [AIF]: HPL Metadata Load completed with return status: true

            2014-07-02 19:30:11,309 FATAL [AIF]: Error in CommDim.loadMetadata

            Traceback (most recent call last):

             

            Thanks

             

            Cheers,
            Rafael

            • 18. Re: Cannot load metadata from EBS
              RMarques

              And more... this is an old log, because the new one does not come with the refresh error... just if I go to tmp folder and get the error.

              Seeme that he stopped logging about metadata

              • 19. Re: Cannot load metadata from EBS
                RMarques

                Hi guys,

                 

                Any idea?

                When I try load metadata, Im missing log details.

                Its not working anymore.

                Any place to check?

                Tried log level, etc.

                 

                Thanks

                • 20. Re: Cannot load metadata from EBS
                  RMarques

                  Hi all,

                   

                  Its now working.

                  Oracle guys suggested to change some variables at setCustomParamErpIntegrator.sh and it worked.

                  As I've got some time, I was trying to find the correct change and found at LD_LIBRARY_PATH, that needs to include Planning LD_LIBRARY_PATH.

                  Francisco Amores

                   

                  Cheers,
                  Rafae

                  • 21. Re: Cannot load metadata from EBS
                    RMarques

                    Oracle guys suggested changing setCustomParamErpIntegrator.sh

                    It worked.

                    Making a research on this, figured it out that we just need to change LD_LIBRARY_PATH to the same as Planning + existing path instead of several paths:)

                     

                    Thanks everybody

                    • 22. Re: Cannot load metadata from EBS
                      Francisco Amores

                      Hi RMarques,

                       

                      happy that is working now.

                       

                      Please can you paste content of setCustomParamErpIntegrator.sh so others can see it?

                       

                      Thanks

                      • 23. Re: Cannot load metadata from EBS
                        RMarques

                        Sure!

                        Just changed at LD_LIBRARY_PATH

                         

                        Before:

                        setCustomParamsErpIntegrator.sh

                        #!/bin/sh

                        JAVA_OPTIONS="-Dhyperion.home=/u01/app/oracle/product/epm/EPMSystem11R1 -DHYPERION_HOME=/u01/app/oracle/product/epm/EPMSystem11R1 -DEPM_ORACLE_HOME=/u01/app/oracle/product/epm/EPMSystem11R1 -DEPM_ORACLE_INSTANCE=/u01/app/oracle/product/epm/user_projects/epmprodexa1 -Dlogging.folder=/u01/app/oracle/product/epm/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/ -Dserver.name=ErpIntegrator0 -Dsun.net.inetaddr.ttl=0 -Djava.io.tmpdir=/u01/app/oracle/product/epm/user_projects/epmprodexa1/tmp -Doracle.pki.debug=true -d64 -Djava.security.egd=file:/dev/../dev/urandom -XX:-FlightRecorder -DcomponentId=ceeb4922438ca1caS3608cdce146b2fb3c51S7a33 -DESS_ES_HOME=/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0 -DDOMAIN_HOME=/u01/app/oracle/product/epm/user_projects/domains/EPMSystem -Dcom.hyperion.planning.datamodel=64 -Djava.library.path=/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin: -DPATH=/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin: ${JAVA_OPTIONS}"

                        export JAVA_OPTIONS

                        PRE_PATH="/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin::${PRE_PATH}"

                        export PRE_PATH

                        USER_MEM_ARGS="-Xms128m -XX:PermSize=128m -XX:MaxPermSize=512m -Xmx4096m "

                        export USER_MEM_ARGS

                        EXT_POST_CLASSPATH="/u01/app/oracle/product/epm/odi/odi_misc:${EXT_POST_CLASSPATH}"

                        export EXT_POST_CLASSPATH

                         

                        DOMAIN_HOME="/u01/app/oracle/product/epm/user_projects/domains/EPMSystem"

                        export DOMAIN_HOME

                         

                        LD_LIBRARY_PATH="/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin::${LD_LIBRARY_PATH}"

                        export LD_LIBRARY_PATH

                         

                        =======================================================================================

                         

                        After:

                        setCustomParamsErpIntegrator.sh

                        #!/bin/sh

                        JAVA_OPTIONS="-Dhyperion.home=/u01/app/oracle/product/epm/EPMSystem11R1 -DHYPERION_HOME=/u01/app/oracle/product/epm/EPMSystem11R1 -DEPM_ORACLE_HOME=/u01/app/oracle/product/epm/EPMSystem11R1 -DEPM_ORACLE_INSTANCE=/u01/app/oracle/product/epm/user_projects/epmprodexa1 -Dlogging.folder=/u01/app/oracle/product/epm/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/ -Dserver.name=ErpIntegrator0 -Dsun.net.inetaddr.ttl=0 -Djava.io.tmpdir=/u01/app/oracle/product/epm/user_projects/epmprodexa1/tmp -Doracle.pki.debug=true -d64 -Djava.security.egd=file:/dev/../dev/urandom -XX:-FlightRecorder -DcomponentId=ceeb4922438ca1caS3608cdce146b2fb3c51S7a33 -DESS_ES_HOME=/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0 -DDOMAIN_HOME=/u01/app/oracle/product/epm/user_projects/domains/EPMSystem -Dcom.hyperion.planning.datamodel=64 -Djava.library.path=/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin: -DPATH=/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin: ${JAVA_OPTIONS}"

                        export JAVA_OPTIONS

                        PRE_PATH="/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin::${PRE_PATH}"

                        export PRE_PATH

                        USER_MEM_ARGS="-Xms128m -XX:PermSize=128m -XX:MaxPermSize=512m -Xmx4096m "

                        export USER_MEM_ARGS

                        EXT_POST_CLASSPATH="/u01/app/oracle/product/epm/odi/odi_misc:${EXT_POST_CLASSPATH}"

                        export EXT_POST_CLASSPATH

                         

                        DOMAIN_HOME="/u01/app/oracle/product/epm/user_projects/domains/EPMSystem"

                        export DOMAIN_HOME

                         

                        LD_LIBRARY_PATH="/u01/app/oracle/product/epm/EPMSystem11R1/lib:/u01/app/oracle/product/epm/EPMSystem11R1/products/Planning/lib64:/u01/app/oracle/product/epm/EPMSystem11R1/products/FinancialDataQuality/lib/64-bit:/u01/app/oracle/product/epm/EPMSystem11R1/common/EssbaseRTC-64/11.1.2.0/bin::${LD_LIBRARY_PATH}"

                        export LD_LIBRARY_PATH

                        1 2 Previous Next