1 2 Previous Next 16 Replies Latest reply on Jun 29, 2017 8:59 PM by MAmmar

    FDMEE 11.2.4.210 load text data to HP

    Zhura

      Hi

      I'm trying to load text data from txt file to Hyperion Planning application.

      I use the following instruction: More to life...: Loading non-numeric data to planning using FDMEE

      Data load rule execute successfull (all steps - import, validate, export, check),

      in FDMEE log no errors:

      [Thu Jan 26 13:31:00 MSK 2017]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: dd/MM/yy, sessionId: 39299492

      [Thu Jan 26 13:31:00 MSK 2017]A cube refresh operation will not be performed.

      [Thu Jan 26 13:31:00 MSK 2017]Create security filters operation will not be performed.

      Planning Outline data store load process finished. 1 data record was read, 2 data records were processed, 2 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

      [Thu Jan 26 13:31:00 MSK 2017]Planning Outline data store load process finished. 1 data record was read, 2 data records were processed, 2 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

      2017-01-26 13:31:00,871 INFO  [AIF]: Number of rows loaded: 1, Number of rows rejected: 0

       

      But in Hyperion Planning/Essbase NO data...

        • 1. Re: FDMEE 11.2.4.210 load text data to HP
          SH_INT

          You said the Essbase logs also show data has loaded, is that correct? The logs don't usually lie, if they say the data has been loaded it probably has. Have you checked for the value in both a Planning form and directly from Essbase? Is this being loaded to a base level intersection? Are you 100% certain you are checking the correct intersection?

          • 2. Re: FDMEE 11.2.4.210 load text data to HP
            Dayalan Punniyamoorthy

            The basic check, Is the Evaluation Order set Properly? If you are loading to Account (the text data) make sure the account is selected in the Evaluation Order.

             

            Regards,

            Dayalan P.

            • 3. Re: FDMEE 11.2.4.210 load text data to HP
              Zhura

              Only FDMEE log say that data has loaded, Essbase log nothing say about load.

              In FDMEE schema table tdataseg has this data, but Essbase hasn't, although Data Load Workbench export is successfull completed.

              May be doesn't load because that the target HP application is EPMA, not Classic?

              FDMEE use Outline Load Utility:

              [Thu Jan 26 13:31:00 MSK 2017]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: dd/MM/yy, sessionId: 39299492

              • 5. Re: FDMEE 11.2.4.210 load text data to HP
                Zhura

                Yes, Evaluation Order is set properly, otherwise we would not be able to enter text in form.

                • 6. Re: FDMEE 11.2.4.210 load text data to HP
                  Zhura

                  The point-of-view specified in the source data file has been added to the definition of a data form so I can write a text manually via data form, and text values reflect correctly in the data form.

                  • 7. Re: FDMEE 11.2.4.210 load text data to HP
                    Dayalan Punniyamoorthy

                    So you can enter the text data in the form but when you load the text data via FDMEE its not showing up the loaded texts right?

                    • 9. Re: FDMEE 11.2.4.210 load text data to HP
                      Zhura

                      I try to load data with OLU, but the result is the same.

                       

                      Here is .dat file:

                      Driver Member,Point-of-View,Data Load Cube Name,Value

                      "A_08_10_00_00_00_00","EN_COMP27_NO_DEPT,VER_LOAD_OTHER,KZT_th,DC_NO_DataCategory,DT_LOAD,DA_NO_DA,IP_Periodic,MV_Accrual,PT_NO_Partner,SP_NO_SchedPeriod,SY_NO_SchedYear,SH_NO_StaffHier_FinSrc,PLAN_Jan_FY16_Dec_FY20,FY16,Jan",Budgets,text1111

                       

                      Log:

                      [Thu Jan 26 15:53:21 MSK 2017]Successfully located and opened input file.

                      [Thu Jan 26 15:53:21 MSK 2017]Input file being read with UTF-8 encoding.

                      [Thu Jan 26 15:53:21 MSK 2017]Detected a UTF-8 BOM marker in input file "C:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1\DemoPLN_21.dat".

                      [Thu Jan 26 15:53:21 MSK 2017]Date format pattern "MM-DD-YYYY" specified for date data type loading.

                      [Thu Jan 26 15:53:21 MSK 2017]Header record fields: Driver Member, Point-of-View, Data Load Cube Name, Value

                      [Thu Jan 26 15:53:21 MSK 2017]Located and using "OFADataLoadDimension" dimension for loading data in "DemoPLN" application.

                      [Thu Jan 26 15:53:21 MSK 2017]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.

                      [Thu Jan 26 15:53:21 MSK 2017]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.

                      [Thu Jan 26 15:53:21 MSK 2017]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: M/d/yy, sessionId: 139189775

                      [Thu Jan 26 15:53:21 MSK 2017]A cube refresh operation will not be performed.

                      [Thu Jan 26 15:53:21 MSK 2017]Create security filters operation will not be performed.

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

                      [Thu Jan 26 15:53:21 MSK 2017]Planning Outline data store load process finished. 2 data records were read, 3 data records were processed, 3 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

                       

                      Command:

                      OutlineLoad -f:password.txt /A:DemoPLN /U:admin /M /I:DemoPLN_21.dat /TR /DF:MM-DD-YYYY /L:outlineLoad.log /X:outlineLoad.exc

                      • 10. Re: FDMEE 11.2.4.210 load text data to HP
                        Zhura

                        Essbase continues writing nothing on the OLU load process.

                        DIRECT_DATA_LOAD is set to true.

                        • 11. Re: FDMEE 11.2.4.210 load text data to HP
                          JohnGoodwin

                          Might be worth having a read through the following post - Can't upload data via Outline Load Utility command line

                           

                          Cheers

                           

                          John

                          • 12. Re: FDMEE 11.2.4.210 load text data to HP
                            Zhura

                            No data in planning and essbase directly. Export all essbase data doesn't contain required data. Intersection is correct.

                            • 13. Re: FDMEE 11.2.4.210 load text data to HP
                              Zhura

                              Thank you, John!

                              • 14. Re: FDMEE 11.2.4.210 load text data to HP
                                3354947

                                Hi John,

                                I was facing the same issue, so we applied latest patch on planning server.

                                now i am able to load data via outline load utility but not able to view data in essbase./planning  via smartview.

                                 

                                Import, Validate and export stages are successful, Export file is getting created in outbox directory. But throwing below error in FDMEE log file -

                                When looked in HSP_TEXT_CELL_VALUE was able to view the text id for  the text data loaded. I suppose its getting loaded to planning schema but not to Essbase

                                No arguments were derived from the command line.Submitted (merged) command line:
                                /DF:MM-DD-YYYY /TR /I://EPMSYSD/Oracle/FDMEE/FPACORP/outbox/FPACORP_11440.dat
                                [Tue Mar 14 03:11:27 EDT 2017]Successfully located and opened input file.
                                [Tue Mar 14 03:11:27 EDT 2017]Input file being read with UTF-8 encoding.
                                [Tue Mar 14 03:11:27 EDT 2017]Date format pattern "MM-DD-YYYY" specified for date data type loading.
                                [Tue Mar 14 03:11:27 EDT 2017]Header record fields: Driver Member, Point-of-View, Data Load Cube Name, Value
                                [Tue Mar 14 03:11:27 EDT 2017]Located and using "OFADataLoadDimension" dimension for loading data in "FPACORP" application.
                                [Tue Mar 14 03:11:27 EDT 2017]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.
                                [Tue Mar 14 03:11:27 EDT 2017]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.
                                [Tue Mar 14 03:11:27 EDT 2017]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: M/d/yy, sessionId: 558954876
                                [Tue Mar 14 03:11:28 EDT 2017]Unable to obtain dimension information and/or perform a data load: com.hyperion.planning.olap.NoAvailableOlapConnectionsException: Unable to obtain a connection to Hyperion Essbase.  If this problem persists, please contact your administrator.
                                [Tue Mar 14 03:11:28 EDT 2017]Trace information: com.hyperion.planning.HyperionPlanningBean::createExternalException:10419, com.hyperion.planning.HyperionPlanningBean::endLoad:10107, com.hyperion.planning.utils.HspOutlineLoad::parseAndLoadInputFile:2007, com.hyperion.planning.utils.HspOutlineLoad::halAdapterInfoAndLoad:341, com.hyperion.planning.utils.HspOutlineLoad::loadAndPrintStatus:5496, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImpl:4468, com.hyperion.planning.utils.HspOutlineLoad::outlineLoadAsyncImplWithJobStatus:4391, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:4378, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:4370, com.hyperion.planning.utils.HspOutlineLoad::outlineLoad:4526, sun.reflect.GeneratedMethodAccessor25848::invoke:-1, sun.reflect.DelegatingMethodAccessorImpl::invoke:25, java.lang.reflect.Method::invoke:597, org.python.core.PyReflectedFunction::__call__:175, org.python.core.PyObject::__call__:355, org.python.core.PyMethod::__call__:215, org.python.core.PyMethod::instancemethod___call__:221, org.python.core.PyMethod::__call__:206, org.python.core.PyObject::__call__:367, org.python.core.PyObject::__call__:371, org.python.pycode._pyx15146::performLoadOluFile$2:104, org.python.pycode._pyx15146::call_function:-1, org.python.core.PyTableCode::call:165, org.python.core.PyBaseCode::call:297, org.python.core.PyBaseCode::call:191, org.python.core.PyFunction::__call__:385, org.python.core.PyMethod::__call__:215, org.python.core.PyMethod::instancemethod___call__:221, org.python.core.PyMethod::__call__:206, org.python.core.PyObject::__call__:367, org.python.core.PyObject::__call__:371, org.python.pycode._pyx15148::f$0:8, org.python.pycode._pyx15148::call_function:-1, org.python.core.PyTableCode::call:165, org.python.core.PyCode::call:18, org.python.core.Py::runCode:1204, org.python.core.Py::exec:1248, org.python.util.PythonInterpreter::exec:172, org.apache.bsf.engines.jython.JythonEngine::exec:144, com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor::execInBSFEngine:322, com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor::exec:170, com.sunopsis.dwg.dbobj.SnpSessTaskSql::scripting:2472, oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor::execute:47, oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor::execute:1, oracle.odi.runtime.agent.execution.TaskExecutionHandler::handleTask:50, com.sunopsis.dwg.dbobj.SnpSessTaskSql::processTask:2913, com.sunopsis.dwg.dbobj.SnpSessTaskSql::treatTask:2625, com.sunopsis.dwg.dbobj.SnpSessStep::treatAttachedTasks:577, com.sunopsis.dwg.dbobj.SnpSessStep::treatSessStep:468, com.sunopsis.dwg.dbobj.SnpSession::treatSession:2128, com.sunopsis.dwg.dbobj.SnpSession::treatSession:1930, oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2::doAction:580, oracle.odi.core.persistence.dwgobject.DwgObjectTemplate::execute:216, oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor::doProcessStartScenTask:513, oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask::doExecute:1073, oracle.odi.runtime.agent.processor.task.AgentTask::execute:126, oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1::run:49, org.springframework.core.task.SyncTaskExecutor::execute:49, oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor::executeAgentTask:41, oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor::doExecuteAgentTask:92, oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor::process:83, oracle.odi.runtime.agent.support.DefaultRuntimeAgent::execute:68, oracle.odi.runtime.agent.servlet.AgentServlet::processRequest:564, oracle.odi.runtime.agent.servlet.AgentServlet::doPost:518, 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.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. 13 data records were read, 14 data records were processed, 14 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.
                                [Tue Mar 14 03:11:28 EDT 2017]Planning Outline data store load process finished. 13 data records were read, 14 data records were processed, 14 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

                                1 2 Previous Next