This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,982 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

EPMA Interface area definition problem..

650739
650739 Member Posts: 27
edited Sep 29, 2008 6:11AM in Planning and Budgeting
Hi,

I'm trying to define new "Data Interface Table Definition" in Data Synchronizer. In data interface area mapping wizard window, i get below error message right after choosing an interface area and i cannot see any of the table.
I'm using EPMA 9.3.1.1.0.186 (by the way i have installed all the patches available, but still it seems 9.3.1.1 in "About Hyperion" menu.)


Error : java.lang.NullPointerException
(com.hyperion.awb.web.common.DMEServiceException)

Trace: com.hyperion.awb.web.datasync.dme.Action.getDBTableNames(Action.java:303)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)

Exception com.hyperion.awb.web.common.DMEServiceException rethrown
com.hyperion.awb.web.datasync.dme.Service.enumDBTables(Service.java:203)
com.hyperion.awb.web.datasync.dme.Action.getDBTableNames(Action.java:289)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

Exception org.apache.axis.AxisFault rethrown

Thanks,

Taha

Edited by: Taha on Sep 26, 2008 4:09 AM

Answers

  • JohnGoodwin
    JohnGoodwin http://john-goodwin.blogspot.com/Member Posts: 30,471 Blue Diamond
    Hi,

    Make sure the following is definitely running :- Hyperion S9 EPM Architect Data Synchronization ATS5

    Also make sure you have created the interface through the configuration utility :- "Interface Datasource Configuration" and check the option to create the tables

    Cheers

    John
    http://john-goodwin.blogspot.com
  • 650739
    650739 Member Posts: 27
    Hi John,

    Data Synchronization service is up and running. I have also tried restarting all epma services couple of times.

    Interface database was already defined in configuration utility with create tables option selected.
    I tried creating another interface database in configuration utility and it succeed too. But still i'm getting same error in data sync..

    Regards,

    Taha
  • JohnGoodwin
    JohnGoodwin http://john-goodwin.blogspot.com/Member Posts: 30,471 Blue Diamond
    Hi,

    If you go into the registry

    HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\EPMAWebTier\HyS9EPMAWebTier\SysOutFile

    Add something like C:\Hyperion\logs\BPMA\web.log

    Restart Hyperion S9 EPM Architect Web ATS5

    Then go the interface section again where you get the error and then check the log file.

    Find where the error starts and try posting here to see if anybody can help.

    Cheers

    John
    http://john.goodwin.blogspot.com/
  • 650739
    650739 Member Posts: 27
    Hii,
    I enabled log files from registry for both epma web and data synch. Here is what i got, it seems it's db connection problem. It's weird because all other features of all components are working fine and they all access same oracle db..

    java.sql.SQLException: [Hyperion][Oracle JDBC Driver]Error establishing socket. Connection refused: connect
    at hyperion.jdbc.base.BaseExceptions.createException(Unknown Source)
    at hyperion.jdbc.base.BaseExceptions.getException(Unknown Source)
    at hyperion.jdbc.oracle.OracleImplConnection.makeConnectionHelper(Unknown Source)
    at hyperion.jdbc.oracle.OracleImplConnection.makeConnection(Unknown Source)
    at hyperion.jdbc.oracle.OracleImplConnection.open(Unknown Source)
    at hyperion.jdbc.base.BaseConnection.connect(Unknown Source)
    at hyperion.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
    at hyperion.jdbc.base.BaseConnection.open(Unknown Source)
    at hyperion.jdbc.base.BaseDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.hyperion.awb.datasync.dbexplorer.ConnectDatabase.getConnection(ConnectDatabase.java:70)
    at com.hyperion.awb.datasync.dbexplorer.DMEWebServiceImplORA.getTables(DMEWebServiceImplORA.java:25)
    at com.hyperion.awb.datasync.dbexplorer.DataMEngineService.getTables(DataMEngineService.java:15)
    at com.hyperion.awb.datasync.DMEngineImpl.enumDBTables(DMEngineImpl.java:487)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
    at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
    at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Unknown Source)
    java.lang.NullPointerException
    at com.hyperion.awb.datasync.dbexplorer.DMEWebServiceImplORA.getTables(DMEWebServiceImplORA.java:29)
    at com.hyperion.awb.datasync.dbexplorer.DataMEngineService.getTables(DataMEngineService.java:15)
    at com.hyperion.awb.datasync.DMEngineImpl.enumDBTables(DMEngineImpl.java:487)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
    at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
    at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Unknown Source)
  • JohnGoodwin
    JohnGoodwin http://john-goodwin.blogspot.com/Member Posts: 30,471 Blue Diamond
    Hi,

    It may be worth trying to create a new interface to see if that helps, also check what access privileges the oracle account you are using has.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 650739
    650739 Member Posts: 27
    Hi,

    I've tried creating new interface dbs, i got same error even when they don't have interface tables. I've also granted dba privilage to the user but it didn't work neither.

    What i'm suspecting is, port number used to access oracle might be hardcoded in the datasynch web application because my oracle db uses 1533 port instead of 1521. And when i searched the "oracle jdbc connection refused" error on the net, all i got was it can be either machine name or port number misspelling.

    Regards,

    Taha
  • JohnGoodwin
    JohnGoodwin http://john-goodwin.blogspot.com/Member Posts: 30,471 Blue Diamond
    Hi,

    It may well be a bug then which is not suprising with EPMA, there is a case on Metalink3 that sounds similiar to your problem.

    Bug 7307976: ERROR USING EPMA DATA INTERFACE TABLE DEFINITION


    Hope this is useful

    John
    http://john-goodwin.blogspot.com/
This discussion has been closed.