6 Replies Latest reply: Sep 5, 2012 5:55 PM by 937835 RSS

    Need help in setting up SDK remotely for Hyperion 11.1.2.2

    937835
      Hello Everybody,

      I have recently installed Hyperion 11.1.2.2(Foundation Services and Interactive Reporting) in our environment.
      The installation and configuration are successful. Also when I ran a sample BQY it works fine.

      If I try to run the sample programs on the Hyperion server in their actual location, they work fine.
      I am having problem setting up the SDK remotely and run the sample program.
      I am getting the following error when trying to run the sample Login.java provided in /EPMSystem11R1/products/biplus/SDK/samples/java/

      GsmNotFound
      com.brio.one.services.globalservicemanager.GSMException: GsmNotFound

      com.sqribe.rm.ReportMartException: GsmNotFound
      at com.sqribe.rm.SessionImpl.convertError(Unknown Source)

      I am using this Login.java program which comes as part of the Hyperion 11.1.2.2 installation.
      Its available in the samples folder, if I run it from there it works perfectly fine.
      I pass in the username, password, hostname and portnumber(6800).
      All the details I pass to the program are correct, bec it works if I run it from the samples location.
      But when I try to set it up remotely on my desktop or even at a different location on the same server, it gives the error.
      I am sure it has something to do with the setup/classpath or something else, I am not sure what.
        • 1. Re: Need help in setting up SDK remotely for Hyperion 11.1.2.2
          937835
          Sample program I am using

          import com.sqribe.rm.*;

          import java.util.Properties;

          /**
          * example class to show how to establish connection with Hyperion Performance Suite
          */

          public class Login
          {
          public Login(String [] args)
          {
          try
          {
          Session session;

          //--------------------------------------------------------------------
          // obtain session connection based on the number of args passed
          //--------------------------------------------------------------------


          switch (args.length)
          {
          case 2:
          session = SessionFactory.getInstance(args[0], args[1]);
          break;


          case 3:
          session = SessionFactory.getInstance(args[0], args[1], args[2]);
          break;

          case 4:
          session = SessionFactory.getInstance(args[0], args[1], args[2], new Integer(args[3]).intValue());
          break;

          default:
          throw new IndexOutOfBoundsException();
          }


          System.out.println("connection established");


          //--------------------------------------------------------------------
          // close the session when you no longer need it
          //--------------------------------------------------------------------


          session.close();


          System.out.println("connection closed");
          }
          catch (ReportMartException e)
          {
          e.printStackTrace();
          }
          }

          /**
          * program entry point
          *

          * @param String [] args - command line arguments
          */


          public static void main(String [] args)
          {
          try
          {
          new Login(args);
          }
          catch (IndexOutOfBoundsException e)
          {
          System.err.println("usage: Login <acct> <pwd> [ <host> <port> ]");
          }
          }
          }
          • 2. Re: Need help in setting up SDK remotely for Hyperion 11.1.2.2
            937835
            Full error below, I left out the WARNING msgs earlier

            Aug 01, 2012 8:55:08 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51067
            Aug 01, 2012 8:55:08 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51068
            Aug 01, 2012 8:55:08 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            Aug 01, 2012 8:55:08 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: Registry exception during initialization
            com.hyperion.hit.registry.exceptions.RegistryException: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            at com.brio.one.config.utils.RegistryUtil.fetchRegistryComponentsForServices(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.<init>(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.getInstance(Unknown Source)
            at com.brio.one.security.KeysStore$DefaultKeysStore.getKey(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getIGSM(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getGSM(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory$ClientFactoryInitializer.connect(Unknown Source)
            at com.brio.one.client.ClientFactory.getClientFactoryConnect(Unknown Source)
            at com.brio.one.client.ClientFactory.connect(Unknown Source)
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)

            Aug 01, 2012 8:55:09 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51067
            Aug 01, 2012 8:55:09 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51068
            Aug 01, 2012 8:55:09 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            Aug 01, 2012 8:55:09 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: Registry exception during initialization
            com.hyperion.hit.registry.exceptions.RegistryException: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            at com.brio.one.config.utils.RegistryUtil.fetchRegistryComponentsForServices(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.<init>(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.getInstance(Unknown Source)
            at com.brio.one.security.KeysStore$DefaultKeysStore.getKey(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getIGSM(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getGSM(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory$ClientFactoryInitializer.connect(Unknown Source)
            at com.brio.one.client.ClientFactory.getClientFactoryConnect(Unknown Source)
            at com.brio.one.client.ClientFactory.connect(Unknown Source)
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)

            Aug 01, 2012 8:55:10 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51067
            Aug 01, 2012 8:55:10 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51068
            Aug 01, 2012 8:55:10 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            Aug 01, 2012 8:55:10 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: Registry exception during initialization
            com.hyperion.hit.registry.exceptions.RegistryException: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            at com.brio.one.config.utils.RegistryUtil.fetchRegistryComponentsForServices(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.<init>(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.getInstance(Unknown Source)
            at com.brio.one.security.KeysStore$DefaultKeysStore.getKey(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getIGSM(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getGSM(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory$ClientFactoryInitializer.connect(Unknown Source)
            at com.brio.one.client.ClientFactory.getClientFactoryConnect(Unknown Source)
            at com.brio.one.client.ClientFactory.connect(Unknown Source)
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)

            Aug 01, 2012 8:55:12 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51067
            Aug 01, 2012 8:55:12 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51068
            Aug 01, 2012 8:55:12 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            Aug 01, 2012 8:55:12 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: Registry exception during initialization
            com.hyperion.hit.registry.exceptions.RegistryException: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            at com.brio.one.config.utils.RegistryUtil.fetchRegistryComponentsForServices(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.<init>(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.getInstance(Unknown Source)
            at com.brio.one.security.KeysStore$DefaultKeysStore.getKey(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getIGSM(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getGSM(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory$ClientFactoryInitializer.connect(Unknown Source)
            at com.brio.one.client.ClientFactory.getClientFactoryConnect(Unknown Source)
            at com.brio.one.client.ClientFactory.connect(Unknown Source)
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)

            Aug 01, 2012 8:55:13 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51067
            Aug 01, 2012 8:55:13 AM com.hyperion.hit.registry.utils.JDBCTemplate executeQueryOptimized
            SEVERE: EPMREG-51068
            Aug 01, 2012 8:55:13 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            Aug 01, 2012 8:55:13 AM com.brio.one.config.utils.RegistryUtil fetchRegistryComponentsForServices:?
            WARNING: Registry exception during initialization
            com.hyperion.hit.registry.exceptions.RegistryException: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component
            at com.brio.one.config.utils.RegistryUtil.fetchRegistryComponentsForServices(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.<init>(Unknown Source)
            at com.brio.one.config.utils.RegistryUtil.getInstance(Unknown Source)
            at com.brio.one.security.KeysStore$DefaultKeysStore.getKey(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.utils.ORBSocketServer.connect(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getIGSM(Unknown Source)
            at com.brio.one.services.globalservicemanager.GSMFactory.getGSM(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory$ClientFactoryInitializer.connect(Unknown Source)
            at com.brio.one.client.ClientFactory.getClientFactoryConnect(Unknown Source)
            at com.brio.one.client.ClientFactory.connect(Unknown Source)
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)

            Aug 01, 2012 8:55:14 AM com.sqribe.rm.ReportMartException <init>:?
            WARNING: GsmNotFound
            Aug 01, 2012 8:55:14 AM com.sqribe.rm.AASessionImpl open:?
            FATAL: GsmNotFound
            Aug 01 08:55:14.158
            GsmNotFound
            com.brio.one.services.globalservicemanager.GSMException: GsmNotFound
            at com.brio.one.services.globalservicemanager.GSMFactory.getGSM(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory.<init>(Unknown Source)
            at com.brio.one.client.ClientFactory$ClientFactoryInitializer.connect(Unknown Source)
            at com.brio.one.client.ClientFactory.getClientFactoryConnect(Unknown Source)
            at com.brio.one.client.ClientFactory.connect(Unknown Source)
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)
            com.sqribe.rm.ReportMartException: GsmNotFound
            at com.sqribe.rm.AASessionImpl.createService(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)

            Aug 01, 2012 8:55:14 AM com.sqribe.rm.SessionImpl convertError:?
            WARNING: GsmNotFound
            Aug 01, 2012 8:55:14 AM com.sqribe.rm.AASessionImpl internalInit:?
            WARNING: ReportMartException
            com.sqribe.rm.ReportMartException: GsmNotFound
            at com.sqribe.rm.SessionImpl.convertError(Unknown Source)
            at com.sqribe.rm.AASessionImpl.open(Unknown Source)
            at com.sqribe.rm.AASessionImpl.internalInit(Unknown Source)
            at com.sqribe.rm.AASessionImpl.<init>(Unknown Source)
            at com.sqribe.rm.SessionFactory.getInstance(Unknown Source)
            at Login.<init>(Login.java:40)
            at Login.main(Login.java:70)
            • 3. Re: Need help in setting up SDK remotely for Hyperion 11.1.2.2
              Vivek Chetiaparath
              WARNING: No RA_FRAMEWORK components found in Registry or there is no DATABASE_CONN child for RA_FRAMEWORK component

              It may not able to reach the HSS registry(as this is working from server)

              Edited by: Vivek Chetiaparath on Aug 2, 2012 1:28 PM
              • 4. Re: Need help in setting up SDK remotely for Hyperion 11.1.2.2
                937835
                Even if I try running the sample program on the same server but from a different location, it gives the same error.
                I am not sure if I need to add something specific in the classpath for it to find the registry.
                I already have the reg.properties file and the default-domain.cfg in the classpath.

                I can understand that if I am doing it from a different machine, there could be some connectivity or firewall ports issue.
                But it should at least work outside of the samples folder.
                • 5. Re: Need help in setting up SDK remotely for Hyperion 11.1.2.2
                  Vivek Chetiaparath
                  yes then it should be something in the classpath...Better to have an SR open with Oracle support so that the properties/bat files can be analysed.
                  • 6. Re: Need help in setting up SDK remotely for Hyperion 11.1.2.2
                    937835
                    Got resolved by adding the following jars to classpath

                    foundation.jar
                    rmapi.jar
                    iona63.jar
                    comutil1_01.jar
                    bqservice.jar
                    wldb2.jar
                    wlsqlserver.jar
                    dms.jar
                    ojdbc6dms.jar
                    ojdl.jar
                    oraclepki.jar
                    commons-lang-2.3.jar
                    xercesImpl.jar
                    wlsybase.jar
                    wlinformix.jar
                    fmwgenerictoken.jar
                    mysql-connector-java-commercial-5.1.17-bin.jar
                    registry-api.jar
                    wlpool.jar