8 Replies Latest reply on Feb 8, 2013 8:15 AM by JohnGoodwin

    Planning Locale: en_US ,unable to load dimension.

    988310
    988310 Feb 7, 2013 8:02 AM
      Hi,

      When i load meta data by command prompt,after enter password.I faced following issue.
      Any help will be appreciated.



      Planning locale: en_US
      using java.library.path: C:\Oracle\Middleware\EPMSystem11R1/products/Planning/li
      b64
      EPM_ORACLE_HOME (C:\Oracle\Middleware\EPMSystem11R1) is set from JVM property "E
      PM_ORACLE_HOME".
      using Java property for Hyperion Home C:\Oracle\Middleware\EPMSystem11R1
      For non-DP app, Request dimension not needed
      EPM_ORACLE_INSTANCE (C:\Oracle\Middleware\user_projects\epmsystem1) is set from
      JVM property[EPM_ORACLE_INSTANCE].


      Loaded Version of Essbase RTC: 0xb1221
      [Thu Feb 07 12:34:09 PKT 2013]Unable to obtain dimension information and/or perf
      orm a data load: Unable to find specified load dimension "Account/L:c:/outlineLo
      ad.log" in "Outsourc" application.
      [Thu Feb 07 12:33:59 PKT 2013]Command line arguments: /A:Outsourc /U:admin /I:c:
      \accounts.csv /D:Account/L:c:/outlineLoad.log /X:c:/outlineLoad.exe
      Successfully logged into "Outsourc" application, Release 11.122, Adapter Interfa
      ce Version 5, Workforce supported and not enabled, CapEx not supported and not e
      nabled, CSS Version 3
      [Thu Feb 07 12:34:09 PKT 2013]Successfully located and opened input file "c:\acc
      ounts.csv".
      [Thu Feb 07 12:34:09 PKT 2013]Header record fields: Account, Parent, Data Storag
      e, Description, Data Type, Account Type, Aggregation(Plan1)
      [Thu Feb 07 12:34:09 PKT 2013]Unable to obtain dimension information and/or perf
      orm a data load: Unable to find specified load dimension "Account/L:c:/outlineLo
      ad.log" in "Outsourc" application.
      [Thu Feb 07 12:34:09 PKT 2013]Examine the Essbase log files for status if Essbas
      e data was loaded.
      [Thu Feb 07 12:34:09 PKT 2013]Planning Outline data store load process finished
      with exceptions: not all input records were read due to errors (or an empty inp
      ut file). 0 data records were read, 0 data records were processed, 0 were succes
      sfully loaded, 0 were rejected.





      Thank You.

      Edited by: 985307 on Feb 7, 2013 12:02 AM
        • 1. Re: Planning Locale: en_US ,unable to load dimension.
          JohnGoodwin
          JohnGoodwin Feb 7, 2013 8:31 AM (in response to 988310)
          Can you post the actual command line you used.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Planning Locale: en_US ,unable to load dimension.
            988310
            988310 Feb 7, 2013 8:58 AM (in response to JohnGoodwin)
            "C:\>cd c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1

            c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>
            c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:
            Outsourc /U:admin /I:c:\accounts.csv /D:Account/L:c:/outlineLoad.log /X:c:/outli
            neLoad.exe "
            press enter then system says
            Enter Password.

            I entered password and get mentioned above error.
            • 3. Re: Planning Locale: en_US ,unable to load dimension.
              JohnGoodwin
              JohnGoodwin Feb 7, 2013 9:20 AM (in response to 988310)
              If that has been pasted correctly the first thing I see is that it needs a space between - /D:Account/L:c:/outlineLoad.log and probably not the best to use .exe as the exception log
              e.g. OutlineLoad /A:Outsourc /U:admin /I:c:\accounts.csv /D:Account /L:c:/outlineLoad.log /X:c:/outlineLoad.exc

              Cheers

              John
              http://john-goodwin.blogspot.com/
              • 4. Re: Planning Locale: en_US ,unable to load dimension.
                988310
                988310 Feb 7, 2013 10:22 AM (in response to JohnGoodwin)
                c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:
                Outsourc /U:admin /I:c:\accounts.csv /D:Account /L:c:/outlineLoad.log /X:c:/outl
                ineLoad.exc
                Enter password:
                Planning locale: en_US
                using java.library.path: C:\Oracle\Middleware\EPMSystem11R1/products/Planning/li
                b64
                EPM_ORACLE_HOME (C:\Oracle\Middleware\EPMSystem11R1) is set from JVM property "E
                PM_ORACLE_HOME".
                using Java property for Hyperion Home C:\Oracle\Middleware\EPMSystem11R1
                For non-DP app, Request dimension not needed
                EPM_ORACLE_INSTANCE (C:\Oracle\Middleware\user_projects\epmsystem1) is set from
                *JVM property[EPM_ORACLE_INSTANCE].*


                Loaded Version of Essbase RTC: 0xb1221
                *[Thu Feb 07 15:17:11 PKT 2013]Unable to obtain dimension information and/or perf*
                orm a data load: Unrecognized column header value(s), refer to previous messages
                *. (Note: column header values are case sensitive.)*




                Now it is...

                Following first line is my flat file header.And second line is first record of the file.

                Account                         Parent     Data Storage     Description         Data Type       Account Type     Aggregation(PPlan1)
                Income Statement      Account     Dynamic Calc     P and L Statement     Currency     Revenue     ~
                • 5. Re: Planning Locale: en_US ,unable to load dimension.
                  JohnGoodwin
                  JohnGoodwin Feb 7, 2013 11:30 AM (in response to 988310)
                  You may need a space at Aggregation (PPlan1)

                  Account,Parent,Data Storage,Description,Data Type,Account Type,Aggregation (PPlan1)

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/
                  • 6. Re: Planning Locale: en_US ,unable to load dimension.
                    988310
                    988310 Feb 8, 2013 5:31 AM (in response to JohnGoodwin)
                    Thank you So much Sir :) It helped me ,some accounts details are loaded,but some are not.Kindly again identify issue.The meta data file i have created with the help of *"Getting Started with Oracle Hyperion Planning "* PDF book.


                    c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:
                    Outsourc /U:admin /I:c:\accounts.csv /D:Account /L:c:/outlineLoad.log /X:c:/outl
                    ineLoad.exc

                    Enter password:
                    Planning locale: en_US
                    using java.library.path: C:\Oracle\Middleware\EPMSystem11R1/products/Planning/li
                    b64
                    EPM_ORACLE_HOME (C:\Oracle\Middleware\EPMSystem11R1) is set from JVM property "E
                    PM_ORACLE_HOME".
                    using Java property for Hyperion Home C:\Oracle\Middleware\EPMSystem11R1
                    For non-DP app, Request dimension not needed
                    EPM_ORACLE_INSTANCE (C:\Oracle\Middleware\user_projects\epmsystem1) is set from
                    JVM property[EPM_ORACLE_INSTANCE].


                    Loaded Version of Essbase RTC: 0xb1221
                    Reaquired task list lease: Fri Feb 08 10:21:37 PKT 2013: 1360300897243
                    [Outsourc] Valid userId: 50001 found in session: [1862242825, admin, native://DN
                    =cn=911,ou=People,dc=css,dc=hyperion,dc=com?USER
                    com.hyperion.planning.InvalidMemberException: The member Net Income before taxes
                    does not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Net Income From Operati
                    ons does not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Gross Profit does not e
                    xist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Gross Profit does not e
                    xist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Net Income From Operati
                    ons does not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member SG&A does not exist or
                    you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member SG&A does not exist or
                    you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member SG&A does not exist or
                    you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Net Income before taxes
                    does not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Net Income before taxes
                    does not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    java.lang.IllegalArgumentException: Invalid value for field Account Type: Liabil
                    ities.
                    at com.hyperion.planning.db.HspHALDBImpl.saveMember(HspHALDBImpl.java:36
                    9)
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:9041)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Liabilities does not ex
                    ist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Liabilities does not ex
                    ist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.HspRuntimeException: Exchange Rate must be None if Data Ty
                    pe is Non-Currency, Percentage, Smart List, Date, or Text. Member: Statistical
                    Drivers
                    at com.hyperion.planning.db.HspDEDBImpl.validateAndSetAccountMemberInfor
                    mation(HspDEDBImpl.java:6659)
                    at com.hyperion.planning.db.HspDEDBImpl.saveMember(HspDEDBImpl.java:2871
                    )
                    at com.hyperion.planning.db.HspDEDBImpl.saveMember(HspDEDBImpl.java:2651
                    )
                    at com.hyperion.planning.db.HspHALDBImpl.saveMember(HspHALDBImpl.java:57
                    1)
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:9041)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Statistical Drivers doe
                    s not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    com.hyperion.planning.InvalidMemberException: The member Statistical Drivers doe
                    s not exist or you do not have access to it.
                    at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
                    gBean.java:8977)
                    at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
                    oad.java:801)
                    at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
                    utlineLoad.java:542)
                    at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
                    utlineLoad.java:112)
                    at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
                    ineLoad.java:1303)
                    at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
                    292)
                    • 7. Re: Planning Locale: en_US ,unable to load dimension.
                      988310
                      988310 Feb 8, 2013 5:40 AM (in response to 988310)
                      Net Income before taxes ,Liabilities and statistical drivers etc
                      are present and syntactically are same in .CSV (comma delimited) file.
                      • 8. Re: Planning Locale: en_US ,unable to load dimension.
                        JohnGoodwin
                        JohnGoodwin Feb 8, 2013 8:15 AM (in response to 988310)
                        985307 wrote:
                        Net Income before taxes ,Liabilities and statistical drivers etc
                        are present and syntactically are same in .CSV (comma delimited) file.
                        Is "Net Income before taxes" present as parent in the file or a child, it could be that the file is referencing the member as a parent but it has not been created as a member so it can't find it.

                        Cheers

                        John
                        http://john-goodwin.blogspot.com/