7 Replies Latest reply: Feb 5, 2014 5:18 PM by G�ran Sander RSS

    Google BigQuery Connection Error

      Running Window 7 Prof 64 bit and just installed QlickView x64 and BigQuery connector.

       

      After entering Client Id and Client Secret and click Authorize, I got the follow error, any idea how to get it fixed? Thanks.

       

      ================================

      Unhandled expection has occurred ....

      ...

      Could not load file or assembly 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken= ....' or one of its dependencies.

       

       

      ************** Exception Text **************

      System.IO.FileNotFoundException: Could not load file or assembly 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

      File name: 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' ---> System.IO.FileNotFoundException: Could not load file or assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

      File name: 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'

       

       

      WRN: Assembly binding logging is turned OFF.

      To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

      Note: There is some performance penalty associated with assembly bind failure logging.

      To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       

       

         at System.ModuleHandle.ResolveMethod(RuntimeModule module, Int32 methodToken, IntPtr* typeInstArgs, Int32 typeInstCount, IntPtr* methodInstArgs, Int32 methodInstCount)

         at System.ModuleHandle.ResolveMethodHandleInternalCore(RuntimeModule module, Int32 methodToken, IntPtr[] typeInstantiationContext, Int32 typeInstCount, IntPtr[] methodInstantiationContext, Int32 methodInstCount)

         at System.ModuleHandle.ResolveMethodHandleInternal(RuntimeModule module, Int32 methodToken, RuntimeTypeHandle[] typeInstantiationContext, RuntimeTypeHandle[] methodInstantiationContext)

         at System.Reflection.CustomAttributeData..ctor(RuntimeModule scope, CustomAttributeRecord caRecord)

         at System.Reflection.CustomAttributeData.GetCustomAttributes(RuntimeModule module, Int32 tkTarget)

         at System.Reflection.CustomAttributeData.GetCustomAttributesInternal(RuntimeAssembly target)

         at System.Reflection.RuntimeAssembly.GetCustomAttributesData()

         at System.Reflection.CustomAttributeData.GetCustomAttributes(Assembly target)

         at System.Resources.ManifestBasedResourceGroveler.GetNeutralResourcesLanguage(Assembly a, UltimateResourceFallbackLocation& fallbackLocation)

         at System.Resources.ResourceManager.CommonSatelliteAssemblyInit()

         at System.Resources.ResourceManager..ctor(String baseName, Assembly assembly)

         at DotNetOpenAuth.Messaging.MessagingStrings.get_ResourceManager()

         at DotNetOpenAuth.Messaging.MessagingStrings.get_RequiredProtectionMissing()

         at DotNetOpenAuth.Messaging.Channel.ValidateAndPrepareBindingElements(IEnumerable`1 elements)

         at DotNetOpenAuth.Messaging.Channel..ctor(IMessageFactory messageTypeProvider, IChannelBindingElement[] bindingElements)

         at DotNetOpenAuth.Messaging.StandardMessageFactoryChannel..ctor(ICollection`1 messageTypes, ICollection`1 versions, IChannelBindingElement[] bindingElements)

         at DotNetOpenAuth.OAuth2.ClientBase..ctor(AuthorizationServerDescription authorizationServer, String clientIdentifier, String clientSecret)

         at BigQueryConnector.Authenticate.btnAuth_Click(Object sender, EventArgs e)

         at System.Windows.Forms.Control.OnClick(EventArgs e)

         at System.Windows.Forms.Button.OnClick(EventArgs e)

         at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

         at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

         at System.Windows.Forms.Control.WndProc(Message& m)

         at System.Windows.Forms.ButtonBase.WndProc(Message& m)

         at System.Windows.Forms.Button.WndProc(Message& m)

         at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

         at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

         at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       

       

       

       

       

       

       

       

      ************** Loaded Assemblies **************

      mscorlib

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.296 (RTMGDR.030319-2900)

          CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

      ----------------------------------------

      BigQueryConnector

          Assembly Version: 1.0.0.0

          Win32 Version: 1.0.0.0

          CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/QlikTech/Custom%20Data/QlikView%20Connector%20for%20Google%20BigQuery/BigQueryConnector.exe

      ----------------------------------------

      QvxLibrary

          Assembly Version: 2.0.9993.0

          Win32 Version: 2.0.9993

          CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/QlikTech/Custom%20Data/QlikView%20Connector%20for%20Google%20BigQuery/QvxLibrary.DLL

      ----------------------------------------

      System.Windows.Forms

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.278 built by: RTMGDR

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

      ----------------------------------------

      System.Drawing

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.282 built by: RTMGDR

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

      ----------------------------------------

      System

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.296 built by: RTMGDR

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

      ----------------------------------------

      System.Core

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.233 built by: RTMGDR

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

      ----------------------------------------

      System.Xml

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.233 built by: RTMGDR

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

      ----------------------------------------

      Google.Apis.Authentication.OAuth2

          Assembly Version: 1.2.4507.26288

          Win32 Version: 1.2.4507.26288

          CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/QlikTech/Custom%20Data/QlikView%20Connector%20for%20Google%20BigQuery/Google.Apis.Authentication.OAuth2.DLL

      ----------------------------------------

      Google.Apis.Bigquery.v2

          Assembly Version: 1.2.4507.26269

          Win32 Version: 1.2.4507.26269

          CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/QlikTech/Custom%20Data/QlikView%20Connector%20for%20Google%20BigQuery/Google.Apis.Bigquery.v2.DLL

      ----------------------------------------

      DotNetOpenAuth

          Assembly Version: 4.0.0.11165

          Win32 Version: 4.0.0.11165

          CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/QlikTech/Custom%20Data/QlikView%20Connector%20for%20Google%20BigQuery/DotNetOpenAuth.DLL

      ----------------------------------------

      Google.Apis

          Assembly Version: 1.2.4507.26291

          Win32 Version: 1.2.4507.26291

          CodeBase: file:///C:/Program%20Files%20(x86)/Common%20Files/QlikTech/Custom%20Data/QlikView%20Connector%20for%20Google%20BigQuery/Google.Apis.DLL

      ----------------------------------------

      System.Runtime.Serialization

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

      ----------------------------------------

      System.Configuration

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

      ----------------------------------------

      SMDiagnostics

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll

      ----------------------------------------

      System.Runtime.DurableInstancing

          Assembly Version: 4.0.0.0

          Win32 Version: 4.0.30319.1 built by: RTMRel

          CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.DurableInstancing/v4.0_4.0.0.0__31bf3856ad364e35/System.Runtime.DurableInstancing.dll

      ----------------------------------------

       

       

      ************** JIT Debugging **************

      To enable just-in-time (JIT) debugging, the .config file for this

      application or computer (machine.config) must have the

      jitDebugging value set in the system.windows.forms section.

      The application must also be compiled with debugging

      enabled.

       

       

      For example:

       

       

      <configuration>

          <system.windows.forms jitDebugging="true" />

      </configuration>

       

       

      When JIT debugging is enabled, any unhandled exception

      will be sent to the JIT debugger registered on the computer

      rather than be handled by this dialog box.

        • Re: Google BigQuery Connection Error

          I believe I have solve this issue by installed .NET framework 4.

           

          Here comes the updates,

           

          the document wasn't clear how to create a Client ID, specifically what "application type" on the Google side. I was creating a service account and never be able to find the client secret. Tried "Web Application" (will lead to "Error: redirect_uri_mismatch" after authenticated), and finally got it by creating a Client id for "Installed App".

           

          It was a frustrating 2 hours but I am glad I am able to get it finally!

            • Re: Google BigQuery Connection Error
              Przemysław Żukowski

              Hi Steven,

               

              it seems that I have very similar error as you. But unfortunetaly even newest v ersion of .NET didn't resolve the problem.

               

              This is my configuration:

               

              • .NET 4.5,
              • using Client ID for "Installed APP",
              • QlikView 11 and Google BigQuery Connector installed.

               

              When I click on Authorize in QlikView I see my project from Google but I cannot see any DataSets. Billing (on the Google's side is not enabled). Maybe I should do something more on the Google's side to see sample data sets (eg. natality)? If yes - can you tell me how can I connect to sample data sets without enabling Billing?

               

              Thanks in advance

              Przemek

                • Re: Google BigQuery Connection Error

                  I have billing enabled on google side. For your problem, I will first make sure you are truely authenticated. 

                   

                   

                  I'm putting this experiment on hold due to other work priorities. My comment/conclusion at this point is both Qlik BigQuery and BigQuery are not very mature yet. The demo clips make the entire integration looks easy, but it is not easy at all in my experience. They are interesting products, but better be prepared to spend lots of extra hours.

                  • Re: Google BigQuery Connection Error
                    G�ran Sander

                    Edit

                    Solved it: How to set up Google BigQuery access with Direct Discovery

                     

                    --------------------------

                    I am seeing similar symptoms (i.e. after authenticating I see my Google project, but get a QV exception when clicking on the Google project in the dialog box shown by the BigQuery connector).

                     

                    The exception says:

                    System.NullReferenceException: Object reference not set to an instance of an object.

                       at BigQueryConnector.Authenticate.lstProjects_SelectedIndexChanged(Object sender, EventArgs e)

                       at System.Windows.Forms.ListBox.OnSelectedIndexChanged(EventArgs e)

                       at System.Windows.Forms.ListBox.WmReflectCommand(Message& m)

                       at System.Windows.Forms.ListBox.WndProc(Message& m)

                       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

                       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

                       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

                     

                    Which does not really tell much, unless you have access to the source code...

                     

                    Anyone else seen this? Or been able to use BigQuery with QV?

                    The connector feels a bit shaky so far..