Forum Stats

  • 3,734,500 Users
  • 2,246,991 Discussions
  • 7,857,330 Comments

Discussions

Can't upload data via Outline Load Utility command line

JanGLi
JanGLi Member Posts: 649 Bronze Badge
edited Dec 1, 2016 11:29PM in Planning and Budgeting

Hi,

Version: 11.1.2.4.004

I am trying to load data into hyperion planning using command line of Outline load utility.


My data form:

pastedImage_5.png

This is my file 1:

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

1111,Employee Count,"Jan, No Line Item,Actual,First Draft,Local,No Entity,No Asset Class,Common Cost Centre,No Future 1,No Product,Common requsition cost center,Employee Count,Common Employees,FY16",Plan2

I have also tried to load the below file.

This is my file 2:

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

1111,Jan,"No Line Item,Actual,First Draft,Local,No Entity,No Asset Class,Common Cost Centre,No Future 1,No Product,Common requsition cost center,Employee Count,Common Employees,Employee Count,FY16",Plan2

My command:

./OutlineLoad.sh /A:HypUAT1 /U:admin /M /I:/u01/hyperion/fdmee_custom/WF/WF_AUG-16.csv /TR /X:/u01/hyperion/fdmee_custom/WF/WF_AUG-16.exc /L:/u01/hyperion/fdmee_custom/WF/WF_AUG-16.log

My log file:

[Fri Nov 11 16:46:25 PKT 2016]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.

My exception file:

\ufeff[Fri Nov 11 16:46:24 PKT 2016]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.

[Fri Nov 11 16:46:24 PKT 2016]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.

I have also checked the essbase log file. I can't see anything related to data loading or file creation for data loading.

I know that all the members are correct, because i have copy/paste these members in GUI version of OLU and i was able to load data from there.

Kindly help.

Regads

Best Answer

  • JanGLi
    JanGLi Member Posts: 649 Bronze Badge
    edited Dec 1, 2016 11:28PM Accepted Answer

    I raised an SR for this issue and according to Oracle it was a bug. Applying patch 11.1.2.4.005 solved this issue and i was able to load data using file format (Value,Driver Member,Point-of-View,Data Load Cube Name) and using OLU command line utility.

    Regards

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Nov 11, 2016 7:53AM
    JanGLi wrote: I have also checked the essbase log file. I can't see anything related to data loading or file creation for data loading.

    You mean the essbase application log and not the essbase.log? you should be checking the Essbase application log.

    Can you run again and check the essbase application log to confirm there are definite no entries in the log after the utility has been run.

    Cheers

    John

    JanGLi
  • JanGLi
    JanGLi Member Posts: 649 Bronze Badge
    edited Nov 11, 2016 8:06AM

    I have checked these logs...

    1 - user_projects/epmsystem1/diagnostics/logs/essbase/essbase/Essbase.log

    2 - user_projects/epmsystem1/diagnostics/logs/essbase/essbase/app/hypUAT1/hypUAT.1log


    Regards

  • JanGLi
    JanGLi Member Posts: 649 Bronze Badge
    edited Nov 11, 2016 8:14AM

    time i ran the command:

    pastedImage_0.png

    Essbase log from 18:06 onwards:

    [Fri Nov 11 18:05:53 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:06:14 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:06:35 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:06:56 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:17 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:38 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:48 2016]Local/ESSBASE0///140735203493632/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:48 2016]Local/ESSBASE0///140735203493632/Info(1051164)Received login request from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735203493632/Info(1051187)Logging in user [[email protected] Directory] from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735201388288/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735201388288/Info(1051001)Received client request: Get Application FrontEnd Type (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735204546304/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735204546304/Info(1051001)Received client request: Set Application FrontEnd Type (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735200335616/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735200335616/Info(1051001)Received client request: Get Security Mode (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735202440960/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735202440960/Info(1051001)Received client request: Set Application Id For Planning (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735203493632/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735203493632/Info(1051001)Received client request: Get Calc Script List Ex (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735204546304/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735204546304/Info(1051001)Received client request: List Objects (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735200335616/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735200335616/Info(1051001)Received client request: Get Calc Script List Ex (from user [[email protected] Directory])[Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735202440960/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:49 2016]Local/ESSBASE0///140735202440960/Info(1051001)Received client request: List Objects (from user [[email protected] Directory])[Fri Nov 11 18:07:51 2016]Local/ESSBASE0///140735201388288/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:51 2016]Local/ESSBASE0///140735201388288/Info(1051001)Received client request: List Substitution Variables (from user [[email protected] Directory])[Fri Nov 11 18:07:51 2016]Local/ESSBASE0///140735203493632/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:07:51 2016]Local/ESSBASE0///140735203493632/Info(1051001)Received client request: List Substitution Variables (from user [[email protected] Directory])[Fri Nov 11 18:07:56 2016]Local/ESSBASE0///140735199282944/Info(1056797)Incremental security backup started by SYSTEM [DAEMON THREAD]. The file created is /u01/hyperion/application/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/essbasets_1478869676.bak][Fri Nov 11 18:07:56 2016]Local/ESSBASE0///140735199282944/Info(1056800)Validation of back up file [/u01/hyperion/application/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/essbasets_1478869676.bak] completed with status 0[Fri Nov 11 18:07:59 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:08:20 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:08:41 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:09:02 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:09:23 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:09:45 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199]

    Application Log from 18:06 onwards (these are the last lines):

    [Fri Nov 11 17:42:56 2016]Local/HypUAT1///140737284589376/Info(1013220)Supervisor [CONSOLE] has forced user [[email protected] Directory] to logout[Fri Nov 11 17:52:56 2016]Local/HypUAT1///140737284589376/Info(1013220)Supervisor [CONSOLE] has forced user [[email protected] Directory] to logout
  • JanGLi
    JanGLi Member Posts: 649 Bronze Badge
    edited Nov 11, 2016 8:22AM

    same activity done from hyperion planning (import data using import/export utility):

    pastedImage_1.png

    Essbase logs from 18:14 onwards:

    [Fri Nov 11 18:14:39 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:00 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:21 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:42 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Error(1051021)You have been logged out due to inactivity or explicitly by the administrator.[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Warning(1051003)Error -1 processing request [Select Application/Database] - disconnecting[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Warning(1051003)Error -1 processing request [Logout] - disconnecting[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Warning(1051003)Error -1 processing request [Logout] - disconnecting[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Warning(1051003)Error -1 processing request [Logout] - disconnecting[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735200335616/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735200335616/Info(1051164)Received login request from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735200335616/Info(1051187)Logging in user [[email protected] Directory] from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Info(1051001)Received client request: Get Application FrontEnd Type (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Info(1051164)Received login request from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Info(1051187)Logging in user [[email protected] Directory] from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Info(1051001)Received client request: Get Application FrontEnd Type (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Info(1051001)Received client request: Select Application/Database (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Info(1051009)Setting application HypUAT1 active for user [[email protected] Directory][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735200335616/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735200335616/Info(1051001)Received client request: Create Temporary Object (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Info(1051001)Received client request: Lock Object (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735202440960/Info(1053012)Object [40536876] is locked by user [[email protected] Directory][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735201388288/Info(1051001)Received client request: Put Object (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Info(1051001)Received client request: Unlock Object (from user [[email protected] Directory])[Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735204546304/Info(1053013)Object [40536876] unlocked by user [[email protected] Directory][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/ESSBASE0///140735203493632/Info(1051001)Received client request: Delete Object (from user [[email protected] Directory])[Fri Nov 11 18:16:03 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:16:24 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:16:45 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:17:06 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:17:27 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:17:48 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:17:56 2016]Local/ESSBASE0///140735199282944/Info(1056797)Incremental security backup started by SYSTEM [DAEMON THREAD]. The file created is [/u01/hyperion/application/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/essbasets_1478870276.bak][Fri Nov 11 18:17:56 2016]Local/ESSBASE0///140735199282944/Info(1056800)Validation of back up file [/u01/hyperion/application/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/essbasets_1478870276.bak] completed with status 0[Fri Nov 11 18:18:09 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:18:31 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:18:52 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:19:13 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:19:34 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:19:55 2016]Local/ESSBASE0///140735812900608/Info(1042059)Connected from [::ffff:10.0.1.199]

    App Log from 18:14 onwards:

    [Fri Nov 11 17:52:56 2016]Local/HypUAT1///140737284589376/Info(1013220)Supervisor [CONSOLE] has forced user [[email protected] Directory] to logout[Fri Nov 11 18:15:53 2016]Local/HypUAT1///140737284589376/Info(1013214)Clear Active on User [[email protected] Directory] Instance [1][Fri Nov 11 18:15:53 2016]Local/HypUAT1///140737284589376/Info(1013214)Clear Active on User [[email protected] Directory] Instance [1][Fri Nov 11 18:15:53 2016]Local/HypUAT1///140737284589376/Info(1013214)Clear Active on User [[email protected] Directory] Instance [1][Fri Nov 11 18:15:53 2016]Local/HypUAT1///140737284589376/Info(1013214)Clear Active on User [[email protected] Directory] Instance [1][Fri Nov 11 18:15:53 2016]Local/HypUAT1///140734124488448/Info(1013210)User [[email protected] Directory] set active on database [Plan2][Fri Nov 11 18:15:53 2016]Local/HypUAT1///140735974635264/Info(1042059)Connected from [::ffff:10.0.1.199][Fri Nov 11 18:15:53 2016]Local/HypUAT1/Plan2/[email protected] Directory/140735974635264/Info(1019061)Reading Rule SQL Information For Database [Plan2][Fri Nov 11 18:15:53 2016]Local/HypUAT1/Plan2/[email protected] Directory/140735974635264/Info(1019025)Reading Rules From Rule Object For Database [Plan2][Fri Nov 11 18:15:53 2016]Local/HypUAT1/Plan2/[email protected] Directory/140735974635264/Info(1013159)Received Command [Import] from user [[email protected] Directory][Fri Nov 11 18:15:53 2016]Local/HypUAT1/Plan2/[email protected] Directory/140735974635264/Info(1003040)Parallel dataload enabled: [1] block prepare threads, [1] block write threads.[Fri Nov 11 18:15:53 2016]Local/HypUAT1/Plan2/[email protected] Directory/140735974635264/Info(1003037)Data Load Updated [1] cells[Fri Nov 11 18:15:53 2016]Local/HypUAT1/Plan2/[email protected] Directory/140735974635264/Info(1003024)Data Load Elapsed Time : [0.01] seconds
  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Nov 11, 2016 9:24AM

    Let me take an example

    Load file:

    pastedImage_0.png

    Command line:

    OutlineLoad.cmd /A:Vision /U:admin /M /I:E:\Planning\datadrivers.csv /TR /X:E:\Planning\data.err /L:E:\Planning\data.log

    Summary of output:

    [Fri Nov 11 14:10:54 GMT 2016]Successfully located and opened input file.[Fri Nov 11 14:10:54 GMT 2016]Input file being read with UTF-8 encoding.[Fri Nov 11 14:10:54 GMT 2016]Header record fields: Value, Driver Member, Point-of-View, Data Load Cube Name[Fri Nov 11 14:10:54 GMT 2016]Located and using "OFADataLoadDimension" dimension for loading data in "Vision" application.[Fri Nov 11 14:10:54 GMT 2016]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.[Fri Nov 11 14:10:54 GMT 2016]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.[Fri Nov 11 14:10:54 GMT 2016]HspOutlineLoad::dateFormatSpecified is false, SessionHalDateFormat stored on session: null, sessionId: 1856657164[Fri Nov 11 14:10:54 GMT 2016]A cube refresh operation will not be performed.[Fri Nov 11 14:10:54 GMT 2016]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.[Fri Nov 11 14:10:54 GMT 2016]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.

    Form:

    pastedImage_3.png

    If you are loading to plan2 are all the members sourced in plan2 and not from plan1? e.g. account member has a source plan type of plan1

    JanGLi
  • JanGLi
    JanGLi Member Posts: 649 Bronze Badge
    edited Dec 1, 2016 11:28PM Accepted Answer

    I raised an SR for this issue and according to Oracle it was a bug. Applying patch 11.1.2.4.005 solved this issue and i was able to load data using file format (Value,Driver Member,Point-of-View,Data Load Cube Name) and using OLU command line utility.

    Regards

  • JanGLi
    JanGLi Member Posts: 649 Bronze Badge
    edited Dec 1, 2016 11:29PM
This discussion has been closed.