ODV integration with Google Analytics

Question

Summary

Content

Token i get it, and when i try to check my resources and i get "Failed to create data source The internal query error". Anybody know how fix that?

FTisiot · Answer

Hi have the same problem, GA used to work in previous version but now i get the "Create Datasource Failed Internal query error." Below the rows from jetty-0.log file SEVERE: java.lang.Exception Proxy Lookup error: Proxy detection failedoracle.bi.datasource.parser.proxy.JDSDVDesktopProxySelector.toggleProxy(JDSDVDesktopProxySelector.java:288)oracle.bi.datasource.util.JDSProxyUtils.setProxy(JDSProxyUtils.java:25)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsConnector.getConnection(GoogleAnalyticsConnector.java:253)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsConnector.(GoogleAnalyticsConnector.java:140)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsMetadataImporter.(GoogleAnalyticsMetadataImporter.java:46)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsProvider.(GoogleAnalyticsProvider.java:54)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsConnectorMetadata.createProvider(GoogleAnalyticsConnectorMetadata.java:103)oracle.bi.datasource.service.DatasourceServiceProcessor.createProvider(DatasourceServiceProcessor.java:453)oracle.bi.datasource.service.DatasourceServiceProcessor.getTypeOptions(DatasourceServiceProcessor.java:1037)sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)Mar 06, 2017 12:50:53 AM oracle.bi.datasource.logging.ODLLoggerWrapper errorSEVERE: Proxy Detection/Setup FailedMar 06, 2017 12:50:54 AM oracle.bi.datasource.logging.ODLLoggerWrapper errorSEVERE: java.lang.NullPointerExceptionjava.lang.NullPointerException nulloracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsMetadataImporter.getQueryString(GoogleAnalyticsMetadataImporter.java:143)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsProvider.getTypeOptions(GoogleAnalyticsProvider.java:213)oracle.bi.datasource.service.DatasourceServiceProcessor.getTypeOptions(DatasourceServiceProcessor.java:1038)sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)Mar 06, 2017 12:50:54 AM oracle.bi.datasource.logging.ODLLoggerWrapper errorSEVERE: java.lang.reflect.InvocationTargetExceptionjava.lang.reflect.InvocationTargetException nullsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)java.lang.reflect.Method.invoke(Method.java:498)oracle.bi.datasource.rpc.DefaultProcessor.process(DefaultProcessor.java:467)oracle.bi.datasource.service.adf.server.DatasourceServlet$ProcessCaller.call(DatasourceServlet.java:613)oracle.bi.datasource.service.adf.server.DatasourceServlet$ProcessCaller.call(DatasourceServlet.java:592)java.util.concurrent.FutureTask.run(FutureTask.java:266)Mar 06, 2017 12:50:54 AM oracle.bi.datasource.logging.ODLLoggerWrapper errorSEVERE: METHOD_INVOCATION_ERROR [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetExceptionCause - Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptionsAction - Contact Oracle Supportoracle.bi.datasource.rpc.DefaultProcessor.process(DefaultProcessor.java:524)oracle.bi.datasource.service.adf.server.DatasourceServlet$ProcessCaller.call(DatasourceServlet.java:613)oracle.bi.datasource.service.adf.server.DatasourceServlet$ProcessCaller.call(DatasourceServlet.java:592)java.util.concurrent.FutureTask.run(FutureTask.java:266)Mar 06, 2017 12:50:54 AM oracle.bi.web.datasetsvc.external.JDSClient getTypeOptionsXmlSEVERE: getTypeOptionsXml failed - Error 500 [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetExceptionCause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptionsAction: Contact Oracle Support

HTTP ERROR 500

Problem accessing /obi-datasrc-server/obiee/javads. Reason:

     [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetExceptionCause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptionsAction: Contact Oracle Support

Powered by Jetty:// 9.3.8.v20160314

Mar 06, 2017 12:50:54 AM oracle.bi.web.datasetsvc.api.rest.v1.ExternalREST createDatasetWARNING: JDS errororacle.bi.web.datasetsvc.external.exception.JDSException at oracle.bi.web.datasetsvc.external.JDSClient.checkErrors(JDSClient.java:203) at oracle.bi.web.datasetsvc.external.JDSClient.checkErrors(JDSClient.java:168) at oracle.bi.web.datasetsvc.external.JDSClient.getTypeOptionsXml(JDSClient.java:312) at oracle.bi.web.datasetsvc.api.core.v1.ExternalCore.getTypeOptionXML(ExternalCore.java:178) at oracle.bi.web.datasetsvc.api.core.v1.ExternalCore.createExternalDataset(ExternalCore.java:51) at oracle.bi.web.datasetsvc.api.rest.v1.ExternalREST.createDataset(ExternalREST.java:61) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:309) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) at org.glassfish.jersey.internal.Errors.process(Errors.java:315) at org.glassfish.jersey.internal.Errors.process(Errors.java:297) at org.glassfish.jersey.internal.Errors.process(Errors.java:267) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:292) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:460) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:386) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:334) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1689) at oracle.bi.security.filter.DVDesktopRESTSecurityFilter.doFilter(DVDesktopRESTSecurityFilter.java:101) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) at org.eclipse.jetty.server.Server.handle(Server.java:518) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Thread.java:745)Mar 06, 2017 12:50:54 AM oracle.bi.web.datasetsvc.api.rest.v1.ExternalREST createDatasetSEVERE: OutboundJaxrsResponse{status=500, reason=Internal Server Error, hasEntity=true, closed=false, buffered=false} {"code":500101,"message":"JDS - Internal Server error","subMessage":" Error 500 [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException Cause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions Action: Contact Oracle Support

HTTP ERROR 500

Problem accessing /obi-datasrc-server/obiee/javads. Reason:

     [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException
Cause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions
Action: Contact Oracle Support

Powered by Jetty:// 9.3.8.v20160314

"}Mar 06, 2017 12:50:54 AM oracle.bi.tech.services.dataset.DatasetSvsImpl _logResponseErrorSEVERE: Failed to create external dataset. : Internal Server Error - {"code":500101,"message":"JDS - Internal Server error","subMessage":" Error 500 [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException Cause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions Action: Contact Oracle Support

HTTP ERROR 500

Problem accessing /obi-datasrc-server/obiee/javads. Reason:

     [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException
Cause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions
Action: Contact Oracle Support

Powered by Jetty:// 9.3.8.v20160314

"}Mar 06, 2017 12:50:54 AM oracle.bi.tech.services.dataset.StandaloneDatasetService createExternalDatasetWARNING: Failed to create external datasetMar 06, 2017 12:50:54 AM oracle.bi.datasource.logging.ODLLoggerWrapper errorSEVERE: java.util.concurrent.ExecutionException oracle.bi.datasource.exceptions.DatasourceException: [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetExceptionCause - [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetExceptionjava.util.concurrent.FutureTask.report(FutureTask.java:122)java.util.concurrent.FutureTask.get(FutureTask.java:206)oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:442)oracle.bi.datasource.service.adf.server.DatasourceServlet.doPost(DatasourceServlet.java:589)javax.servlet.http.HttpServlet.service(HttpServlet.java:707)