This discussion is archived
1 2 3 4 5 Previous Next 71 Replies Latest reply: Aug 9, 2013 1:46 PM by user11016624 Go to original post RSS
  • 45. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    I am using E:\Oracle\Middleware\jdk160_29 to compile the EssbaseRuRunTime.java

     

    javac -classpath %CPATH% EssbaseRuRunTime.java

     

    where CPATH = E:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseServer\java\essbase.jar

  • 46. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    #/bin/bash

     

     

    /d01/hyphfm/jdk160_21/bin/javac   ./RunCmd.java

    /d01/hyphfm/jdk160_21/bin/jar cf ./RunCmd.jar ./RunCmd.class

  • 47. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    did exactly,

    then I ran this:

     

    login $1 $2 on $3;

    CREATE or REPLACE FUNCTION $4.'@EssbaseRuRunTime' AS 'EssbaseRuRunTime(String[],String)' SPEC '@EssbaseRuRunTime(expList1,String1)' COMMENT 'executes external process';

    alter system unload application $4;
    alter system load application $4;

     

     

    in the log I do not see that it been register:

     

    [2013-08-08T10:29:02.856-04:00] [RR] [NOTIFICATION:16] [REQ-207] [] [ecid: 1375968265652,0] [tid: 9160] RECEIVED SHUTDOWN COMMAND - SERVER TERMINATING

    [2013-08-08T10:29:05.200-04:00] [RR] [NOTIFICATION:16] [SVR-139] [] [ecid: 1375968545680,0] [tid: 8624]  Essbase Server 64-bit  - Release 11.1.2 (ESB11.1.2.2.100B2166)

    [2013-08-08T10:29:05.200-04:00] [RR] [NOTIFICATION:16] [SVR-35] [] [ecid: 1375968545680,0] [tid: 8624] Starting Essbase Server - Application [RR]

    [2013-08-08T10:29:05.341-04:00] [RR] [NOTIFICATION:16] [CFW-480] [] [ecid: 1375968545680,0] [tid: 8624] Loaded and initialized JVM module

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [CFW-445] [] [ecid: 1375968545680,0] [tid: 8624] External [GLOBAL] function [@ESSBASEALERT] registered OK

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [OBJ-8] [] [ecid: 1375968545680,0] [tid: 8624] Reading Application Definition For [RR]

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [OBJ-9] [] [ecid: 1375968545680,0] [tid: 8624] Reading Database Definition For [PLANNING]

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [OBJ-21] [] [ecid: 1375968545680,0] [tid: 8624] Reading Database Mapping For [RR]

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [OBJ-10] [] [ecid: 1375968545680,0] [tid: 8624] Writing Application Definition For [RR]

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [OBJ-11] [] [ecid: 1375968545680,0] [tid: 8624] Writing Database Definition For [PLANNING]

    [2013-08-08T10:29:05.450-04:00] [RR] [NOTIFICATION:16] [OBJ-22] [] [ecid: 1375968545680,0] [tid: 8624] Writing Database Mapping For [RR]

    [2013-08-08T10:29:05.966-04:00] [RR] [NOTIFICATION:16] [REQ-202] [] [ecid: 1375968545680,0] [tid: 8624] Waiting for Login Requests

    [2013-08-08T10:29:05.966-04:00] [RR] [NOTIFICATION:16] [REQ-205] [] [ecid: 1375968545680,0] [tid: 8624] Received Command [Load Database]

    [2013-08-08T10:29:05.966-04:00] [RR] [NOTIFICATION:16] [OBJ-18] [] [ecid: 1375968545680,0] [tid: 8624] Writing Parameters For Database [PLANNING]

    [2013-08-08T10:29:05.966-04:00] [RR] [NOTIFICATION:16] [OBJ-17] [] [ecid: 1375968545680,0] [tid: 8624] Reading Parameters For Database [PLANNING]

    [2013-08-08T10:29:05.966-04:00] [RR] [NOTIFICATION:16] [OBJ-12] [] [ecid: 1375968545680,0] [tid: 8624] Reading Outline For Database [PLANNING]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [MBR-43] [] [ecid: 1375968545680,0] [tid: 8624] Declared Dimension Sizes = [5226 41 734 1103 6210 2670 325 198 12 29 ]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [MBR-42] [] [ecid: 1375968545680,0] [tid: 8624] Actual Dimension Sizes = [3443 28 292 1097 2454 1664 267 197 11 28 ]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [MBR-125] [] [ecid: 1375968545680,0] [tid: 8624] The number of Dynamic Calc Non-Store Members = [0 0 0 0 0 0 0 0 0 0 ]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [MBR-126] [] [ecid: 1375968545680,0] [tid: 8624] The number of Dynamic Calc Store Members = [0 0 0 0 0 0 0 0 0 0 ]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [MBR-127] [] [ecid: 1375968545680,0] [tid: 8624] The logical block size is [3443]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [SEC-8] [] [ecid: 1375968545680,0] [tid: 8624] Maximum Declared Blocks is [12324976100482308000000] with data block size of [5226]

    [2013-08-08T10:29:06.28-04:00] [RR] [NOTIFICATION:16] [SEC-7] [] [ecid: 1375968545680,0] [tid: 8624] Maximum Actual Possible Blocks is [593339955546827780000] with data block size of [3443]

    [2013-08-08T10:29:06.28-04:00] [RR] [ERROR:32] [CFW-2] [] [ecid: 1375968545680,0] [tid: 8624] Compilation failed

    [2013-08-08T10:29:06.28-04:00] [RR] [WARNING:1] [CAL-121] [] [ecid: 1375968545680,0] [tid: 8624] Error encountered when loading member [YTD Other Comprehensive NI]'s calc string [Sum(Ancestor([Time Periods].CurrentMember, 2).FirstChild.FirstChild:[Time Periods].CurrentMember, [Other Comprehensive Net Income])], ignored

    [2013-08-08T10:29:06.44-04:00] [RR] [NOTIFICATION:16] [OBJ-18] [] [ecid: 1375968545680,0] [tid: 8624] Writing Parameters For Database [PLANNING]

    [2013-08-08T10:29:06.44-04:00] [RR] [NOTIFICATION:16] [OBJ-45] [] [ecid: 1375968545680,0] [tid: 8624] Reading Partition Definition File For Database [PLANNING]

    [2013-08-08T10:29:06.75-04:00] [RR] [NOTIFICATION:16] [OBJ-17] [] [ecid: 1375968545680,0] [tid: 8624] Reading Parameters For Database [PLANNING]

    [2013-08-08T10:29:06.75-04:00] [RR] [NOTIFICATION:16] [IND-13] [] [ecid: 1375968545680,0] [tid: 8624] Index cache size ==> [1048576] bytes, [128] index pages.

    [2013-08-08T10:29:06.75-04:00] [RR] [NOTIFICATION:16] [IND-14] [] [ecid: 1375968545680,0] [tid: 8624] Index page size ==> [8192] bytes.

    [2013-08-08T10:29:06.75-04:00] [RR] [NOTIFICATION:16] [IND-81] [] [ecid: 1375968545680,0] [tid: 8624] Using buffered I/O for the index and data files.

    [2013-08-08T10:29:06.75-04:00] [RR] [NOTIFICATION:16] [IND-83] [] [ecid: 1375968545680,0] [tid: 8624] Using waited I/O for the index and data files.

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [OBJ-19] [] [ecid: 1375968545680,0] [tid: 8624] Reading Data File Free Space Information For Database [PLANNING]...

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [ESMDAT-69] [] [ecid: 1375968545680,0] [tid: 8624] Data cache size ==> [3072] Kbytes, [114] data pages

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [ESMDAT-70] [] [ecid: 1375968545680,0] [tid: 8624] Data file cache size ==> [0] Kbytes, [0] data file pages

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [TMG-53] [] [ecid: 1375968545680,0] [tid: 8624] Free space recovery skipped.  Estimated free space recoverable by RecoverDbFreeSpace: [178904] bytes

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [QX-33] [] [ecid: 1375968545680,0] [tid: 8624] Missing Database Config File [E:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\APP\RR\PLANNING\PLANNING.cfg], Query logging disabled

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [CFW-551] [] [ecid: 1375968545680,0] [tid: 8624] Allocated TRIGMAXMEMSIZE: [4096] Bytes.

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [REQ-205] [] [ecid: 1375968545680,0] [tid: 8624] Received Command [Get Database Volumes]

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [REQ-205] [] [ecid: 1375968545680,0] [tid: 8624] Received Command [Set Database State]

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [OBJ-18] [] [ecid: 1375968545680,0] [tid: 8624] Writing Parameters For Database [PLANNING]

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [OBJ-18] [] [ecid: 1375968545680,0] [tid: 8624] Writing Parameters For Database [PLANNING]

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [REQ-205] [] [ecid: 1375968545680,0] [tid: 8624] Received Command [Get Database State]

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [REQ-205] [] [ecid: 1375968545680,0] [tid: 8624] Received Command [Get Database Info]

    [2013-08-08T10:29:06.91-04:00] [RR] [NOTIFICATION:16] [REQ-205] [] [ecid: 1375968545680,0] [tid: 8624] Received Command [SetApplicationState]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [OBJ-10] [] [ecid: 1375968545680,0] [tid: 8624] Writing Application Definition For [RR]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [OBJ-11] [] [ecid: 1375968545680,0] [tid: 8624] Writing Database Definition For [PLANNING]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [OBJ-22] [] [ecid: 1375968545680,0] [tid: 8624] Writing Database Mapping For [RR]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [TCP-59] [] [ecid: 1375968545680,0] [tid: 9200] Connected from [127.0.0.1]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [TCP-59] [] [ecid: 1375968545680,0] [tid: 8020] Connected from [127.0.0.1]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [TCP-59] [] [ecid: 1375968545680,0] [tid: 8536] Connected from [127.0.0.1]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [TCP-59] [] [ecid: 1375968545680,0] [tid: 6988] Connected from [127.0.0.1]

    [2013-08-08T10:29:06.106-04:00] [RR] [NOTIFICATION:16] [TCP-59] [] [ecid: 1375968545680,0] [tid: 2880] Connected from [127.0.0.1]

  • 48. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    show this file

     

    /oracle/Middleware/essbase1/EssbaseServer/essbaseserver1/java/essfunc.xml 

  • 49. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    -<definitions version="6.2.0"> <macros/> -<functions> -<function javaSpec="com.hyperion.essbase.calculator.EssbaseAlert.send(String, String, String, String, String,String,String,String)" tsmcs="647000" tssec="1375968247" name="@ESSBASEALERT"> -<spec>

    <![CDATA[@ESSBASEALERT(stringArray, stringArray, doubleArray)]]>

    </spec> -<comment>

    <![CDATA[Internal]]>

    </comment> </function> </functions> </definitions>

     

    why EssbaseRuRunTime not there?

  • 50. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    perhaps

       it's right.

    EssbaseRuRunTime  - procedure.


    Can u run Calc with test ?


    RUNJAVA EssbaseRuRunTime "c:\run.bat"


    c:\run.bat

    echo  eeeeeee > c:\ddd.txt

  • 51. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    nope, the screen execute calcualtion is just hangs

     

    [Thu Aug 08 09:53:18 2013]Local/RR/PLANNING/admin@Native Directory/6536/Info(1013167)

    Received Command [Calculate] from user [admin@Native Directory] using [replica.csc]

     

     

    MAXL> display function;

    application         function            class               method
    spec                comment             runtime             state

    +-------------------+-------------------+-------------------+-------------------
    +-------------------+-------------------+-------------------+-------------------

    RR                  @EssbaseRuRunTime
    @EssbaseRuRunTime(e executes external p               FALSE                   0


    WARNING - 1241024 - Possible string truncation in column 2.
    WARNING - 1241028 - Output column defined with warnings.
    WARNING - 1241024 - Possible string truncation in column 3.
    WARNING - 1241028 - Output column defined with warnings.
    WARNING - 1241024 - Possible string truncation in column 4.
    WARNING - 1241028 - Output column defined with warnings.
    WARNING - 1241024 - Possible string truncation in column 5.
    WARNING - 1241028 - Output column defined with warnings.
    WARNING - 1241024 - Possible string truncation in column 6.
    WARNING - 1241028 - Output column defined with warnings.
    OK/INFO - 1241044 - Records returned: [1].

    MAXL>

  • 52. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    try other quest

     

     

     

     

     

    ----------RunCmd.java ----------------

    import java.util.*;

    import java.io.*;

     

     

    public class RunCmd {

    public static int jRun(String argCmd, String[] args)

    {

     

     

    int i,  n = args.length;

    String Str = argCmd;

     

     

    for (i=0; i<n; i++) {

    Str = Str + " " + args[i];

    }

     

    try {Runtime rt = Runtime.getRuntime();

    Process proc = rt.exec(Str);

     

     

    i = proc.waitFor();

     

     

    }

     

     

    catch(Exception e)

    {

    System.out.println(e.getMessage());

    System.out.println(Str);

    }

     

     

    return (i);

     

     

    }

    }

    --------------------------------------

    #/bin/bash

     

     

    /d01/hyphfm/jdk160_21/bin/javac   ./RunCmd.java

    /d01/hyphfm/jdk160_21/bin/jar cf ./RunCmd.jar ./RunCmd.class

    ---------------

    CREATE or REPLACE FUNCTION $4.'@jRunCmd' AS 'RunCmd.jRun(String,String)' SPEC '@jRunCmd(arg1, @List(arg2, arg3,...))

    COMMENT 'executes external process';

        <function name="@jRunCmd" tssec="1369836168" tsmcs="509885" javaSpec="RunCmd.jRun">

          <spec>

            <![CDATA[@jRunCmd(arg1, arg2); @jRunCmd(arg1, @List(arg2, arg3,...));]]>

          </spec>

          <comment>

            <![CDATA[Execute shell command]]>

          </comment>

        </function>

    ---------------------

       SET CREATENONMISSINGBLK ON;

       SET FRMLBOTTOMUP OFF;

     

       FIX ("Age_NA" "D_NA" @RELATIVE(CFO_904,0) "PN_NA"  "BUD"  "AC_NA" "P_Reserv_NA" "CR_NA" "VR_Work" "FRG_NA" "BegBalance" )

     

        "No Year" (

     

       "No Year"=0;

     

       "No Year"= @jRunCmd("c:\run.bat ",

                                 @LIST("p1=pppp",

                                 "p2=rrrr"            )

                                            );

     

        IF ("No Year">0)

            @RETURN ("Error in Running calcKPI  EssbaseServer/java/scripts/_common/log ", ERROR);

         ENDIF

       )

     

       ENDFIX

     

       SET CREATENONMISSINGBLK  OFF;

       SET FRMLBOTTOMUP ON;

  • 53. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    Error: 1200497 Error parsing formula for [FIX STATEMENT] (line 3): unknown member name [CFO_904] in function [@RELATIVE]

  • 54. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

      FIX (  all NA members  )

     

        "No Year" (

     

       "No Year"=0;

     

       "No Year"= @jRunCmd("c:\run.bat ",

                                 @LIST("p1=pppp",

                                 "p2=rrrr"            )

                                            );

     

        IF ("No Year">0)

            @RETURN ("Error in Running calcKPI  EssbaseServer/java/scripts/_common/log ", ERROR);

         ENDIF

       )

     

       ENDFIX

  • 55. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    tried this:

     

    SET CREATENONMISSINGBLK ON;
    SET FRMLBOTTOMUP OFF;
    FIX (  "Accounts", "Time Periods", "Entities", "Locations", "Departments", "Products", "DeliveryC", "Intercompany", "Years", "Scenarios"  )
       "Years" (
       "Years"=0;
       "Years"= @jRunCmd("c:\run.bat ",
                                 @LIST("p1=pppp",
                                 "p2=rrrr"            )
                                            );
        IF ("Years">0)
            @RETURN ("Error in Running calcKPI  EssbaseServer/java/scripts/_common/log ", ERROR);
         ENDIF
       )

       ENDFIX
    SET CREATENONMISSINGBLK  OFF;
    SET FRMLBOTTOMUP ON;

     

    got this error: "Error: 1012016 Cannot calculate dimension member [Years] with restricted member [Years]"

  • 56. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    FIX (  "Accounts", "Time Periods", "Entities", "Locations", "Departments", "Products", "DeliveryC", "Intercompany", "Scenarios"  )

  • 57. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    Error: 1012037 Custom calculation is not allowed for [Label] share member [Years]

  • 58. Re: Essabse ASO write-back send data
    Evgeniy.Rasyuk Journeyer
    Currently Being Moderated

    Use only stored member in the fix

  • 59. Re: Essabse ASO write-back send data
    user11016624 Newbie
    Currently Being Moderated

    how I can find which one is stored?

     

    one more quiestione, if Iever will do this calc script, how SmartView will know when users "Send Data" that it needs to run that calc script, Any aditional setting I need to set?

     

     

    as well I tried to run RunCmd like this and I am getting the erro below:

     

    E:\>e:\Oracle\Middleware\jdk160_29\bin\java ./RunCmd
    Exception in thread "main" java.lang.NoClassDefFoundError: //RunCmd
    Caused by: java.lang.ClassNotFoundException: ..RunCmd
            at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
            at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    Could not find the main class: ./RunCmd.  Program will exit.

    E:\>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points