EPMA Interface area definition problem..

650739

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

JohnGoodwin

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

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

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

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

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

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

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/