Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODV integration with Google Analytics

Received Response
32
Views
1
Comments
Dmence92
Dmence92 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

ODV integration with Google Analytics

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?

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    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.<init>(GoogleAnalyticsConnector.java:140)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsMetadataImporter.<init>(GoogleAnalyticsMetadataImporter.java:46)oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsProvider.<init>(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 - <html><head><meta http-equiv="Content-Type" content="text/html;charset=utf-8"/><title>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</title></head><body><h2>HTTP ERROR 500</h2><p>Problem accessing /obi-datasrc-server/obiee/javads. Reason:<pre>     [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</pre></p><hr><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.3.8.v20160314</a><hr/></body></html>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":"<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf-8\"/>\n<title>Error 500  [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException\nCause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions\nAction: Contact Oracle Support</title>\n</head>\n<body><h2>HTTP ERROR 500</h2>\n<p>Problem accessing /obi-datasrc-server/obiee/javads. Reason:\n<pre>     [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException\nCause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions\nAction: Contact Oracle Support</pre></p><hr><a href=\"http://eclipse.org/jetty\">Powered by Jetty:// 9.3.8.v20160314</a><hr/>\n\n</body>\n</html>\n"}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":"<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf-8\"/>\n<title>Error 500  [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException\nCause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions\nAction: Contact Oracle Support</title>\n</head>\n<body><h2>HTTP ERROR 500</h2>\n<p>Problem accessing /obi-datasrc-server/obiee/javads. Reason:\n<pre>     [JDSError : 12] Failed to invoke processor method DatasourceService:getTypeOptions - java.lang.reflect.InvocationTargetException\nCause: Internal error java.lang.reflect.InvocationTargetException from processor method DatasourceService:getTypeOptions\nAction: Contact Oracle Support</pre></p><hr><a href=\"http://eclipse.org/jetty\">Powered by Jetty:// 9.3.8.v20160314</a><hr/>\n\n</body>\n</html>\n"}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)