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

        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

          #/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

            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

              show this file

               

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

              • 49. Re: Essabse ASO write-back send data
                user11016624

                -<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

                  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

                    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

                      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

                        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

                            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

                            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

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

                              • 57. Re: Essabse ASO write-back send data
                                user11016624

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

                                • 58. Re: Essabse ASO write-back send data
                                  Evgeniy.Rasyuk

                                  Use only stored member in the fix

                                  • 59. Re: Essabse ASO write-back send data
                                    user11016624

                                    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:\>