This discussion is archived
7 Replies Latest reply: Oct 7, 2013 2:22 PM by user5449503 RSS

Ad hoc analysis not available in Smart View Panel after connect

NelsonSantos Newbie
Currently Being Moderated

Hi everyone,

 

I have a strange issue when I try to make ad hoc analysis with Smart View using a LDAP User configured in Shared Services:

 

I open Excel and go to Smart View Panel, I connected to Shared Connections without problems, but when I choose a DB and make connect (it seems to be succeed  because no errors appears), but after that ad hoc analysis option not get visible in Smart View Panel.

 

I turned on the Log Messages in Smart View Options with the option "Profile" and I got the following error message", (but i didn't understand because the message ask to check log for details, This is the log file (SmartViewLogs.log)  !!! or exists another one ? )

 

[2013-09-30T14:16:10][SVC][ERROR:1][SVC10000][SVC][ecid: 2ca0613e-1c61-473a-9c8e-0d3b2bd59229,0]Operation Failed. Check log for details.[[Error in IHypConnection::initServices]]

 

Trying to connect with VBA, using the same user, after use HypCreateConnection, without errors, when I try to user HypConnect appears the logon form and It not get connected.

 

I tested the user, connecting for example to Shared Services Link and it access without problems.

 

When a native user of Hyperion everything works fine.

 

Somebody can help me ?

 

Regards,

Nelson

  • 1. Re: Ad hoc analysis not available in Smart View Panel after connect
    Celvin Kattookaran Oracle ACE
    Currently Being Moderated

    Is the webform enabled for ad-hoc? Can you try with Private Connection?

     

    Check Planning Adhoc Analysis Does Not Work On Hyperion Planning Ad-Hoc Enabled Webforms

     

     

    Regards

     

     

    Celvin

    http://www.orahyplabs.com

  • 2. Re: Ad hoc analysis not available in Smart View Panel after connect
    NelsonSantos Newbie
    Currently Being Moderated

    Hi Celvin,

     

    I'm not connecting with Planning, I'm using SmartView to explore a Essbase Database only.

     

    Creating a Private Connection directly, I got an error, but with any user.

     

    I forgot to say the version I'm using is 11.1.2.2.

     

    Regards,

    Nelson Santos

  • 3. Re: Ad hoc analysis not available in Smart View Panel after connect
    Celvin Kattookaran Oracle ACE
    Currently Being Moderated

    What options are there after you connect?

    What is the access level of the user in Essbase?

     

    Regards

     

     

    Celvin

    http://www.orahyplabs.com

  • 4. Re: Ad hoc analysis not available in Smart View Panel after connect
    NelsonSantos Newbie
    Currently Being Moderated

    The options available after connect are:

     

    Add to Private Connections

    Disconnect

    New Smart Query Sheet

     

    This user belongs to a Essbase Group with "Read" Access.

     

    Regards,

    Nelson Santos

  • 5. Re: Ad hoc analysis not available in Smart View Panel after connect
    NelsonSantos Newbie
    Currently Being Moderated

    Hi Celvin and everyone !!!

     

    Someone can help me with this issue, I can't find the problem.

    I don't know if it is a user access or a connection issue.

    Is possible to give specific access to SmartView, to not let available add hoc analysis for example?

     

    Regards,

    Nelson Santos

  • 6. Re: Ad hoc analysis not available in Smart View Panel after connect
    Celvin Kattookaran Oracle ACE
    Currently Being Moderated

    Never heard of a Smart View specific access. Is that specific to a system or user? Can you test the same user id on a different system (one which was not attached to a dual monitor, there are some issues if you are using dual monitor) and a different user id on same system.

     

    Regards

     

     

    Celvin

    http://www.orahyplabs.com

  • 7. Re: Ad hoc analysis not available in Smart View Panel after connect
    user5449503 Newbie
    Currently Being Moderated

    Hi,

    I have the same problem. In Application Provider Services the log shows:

     

    [2013-10-07T20:26:01.280+01:00] [AnalyticProviderServices0] [ERROR] [] [oracle.EPMOHPS] [tid: 44] [ecid: disabled,0] [APP: APS] [SID: 78068AE3305D7D9141156C174F65E4] [[
    java.lang.reflect.InvocationTargetException
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
            at java.lang.reflect.Method.invoke(Method.java:611)
            at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:282)
            at org.apache.commons.digester.CallMethodRule.end(CallMethodRule.java:626)
            at org.apache.commons.digester.Rule.end(Rule.java:253)
            at org.apache.commons.digester.Digester.endElement(Digester.java:1222)
            at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
            at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
            at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
            at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
            at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
            at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
            at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
            at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
            at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
            at org.apache.commons.digester.Digester.parse(Digester.java:1785)
            at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
            at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
            at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
            at com.essbase.smartview.xml.EssbaseSmartView.doPost(Unknown Source)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
            at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
            at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
            at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
            at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
            at java.security.AccessController.doPrivileged(AccessController.java:310)
            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
            at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
            at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
            at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
            at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
            at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
            at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
            at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
            at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
            at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
            at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
            at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
            at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
            at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
            at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
            at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)
            at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)
            at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)
            at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
            at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
            at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
            at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
            at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
            at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
            at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
            at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
            at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1646)
    Caused by: java.lang.NoClassDefFoundError: org.apache.commons.pool.KeyedPoolableObjectFactory
            at java.lang.J9VMInternals.verifyImpl(Native Method)
            at java.lang.J9VMInternals.verify(J9VMInternals.java:72)
            at java.lang.J9VMInternals.initialize(J9VMInternals.java:134)
            at com.hyperion.css.spi.impl.ldap.JNDIHelper.getURLContext(JNDIHelper.java:355)
            at com.hyperion.css.spi.impl.ldap.JNDIHelper.getURLContext(JNDIHelper.java:342)
            at com.hyperion.css.spi.impl.ldap.LDAPProvider.authenticate(LDAPProvider.java:356)
            at com.hyperion.css.facade.impl.CSSAbstractAuthenticator.authenticateUser(CSSAbstractAuthenticator.java:613)
            at com.hyperion.css.facade.impl.CSSAPIAuthenticationImpl.authenticate(CSSAPIAuthenticationImpl.java:69)
            at com.hyperion.css.facade.impl.CSSAPIImpl.authenticate(CSSAPIImpl.java:102)
            at com.hyperion.css.facade.CSSAPIFacade.authenticate(CSSAPIFacade.java:119)
            at com.hyperion.dsf.server.framework.HyperionCss.authenticate(Unknown Source)
            at com.hyperion.dsf.server.framework.HyperionCss.authenticateUser(Unknown Source)
            at com.essbase.smartview.provider.EdsProviderImpl.getCssToken(Unknown Source)
            at com.essbase.smartview.admin.CSSProvider.initializeAndRetrieveCssToken(Unknown Source)
            at com.essbase.smartview.admin.EssbaseProvider.openApplication(Unknown Source)
            at com.essbase.smartview.admin.ApsHandler.openApplication(Unknown Source)
            ... 57 more
    Caused by: java.lang.ClassNotFoundException: org.apache.commons.pool.KeyedPoolableObjectFactory
            at java.net.URLClassLoader.findClass(URLClassLoader.java:434)
            at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:191)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:660)
            at com.ibm.ws.bootstrap.ExtClassLoader.loadClass(ExtClassLoader.java:111)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:626)
            at com.ibm.ws.classloader.ProtectionClassLoader.loadClass(ProtectionClassLoader.java:62)
            at com.ibm.ws.classloader.ProtectionClassLoader.loadClass(ProtectionClassLoader.java:58)
            at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:511)
            at java.lang.ClassLoader.loadClass(ClassLoader.java:626)
            ... 73 more

    ]]

     

    It works ok with Native users but not with LDAP ones. Ad hoc analysis is only available for Native users, with LDAP it doesn´t appear.

     

    Thanks

Legend

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