Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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.

Tags (1)
7 Replies
Not applicable

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!

przemyslaw_zuko
Not applicable

Re: Google BigQuery Connection Error

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

Not applicable

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.

wizardo
Not applicable

Re: Google BigQuery Connection Error

hi,

has anyone got a fix for this?

i have created everything as instructed but i get the same error

"could not load file or assembly system.web version 4.0.0.0 "

im trying to test the new Bigquery connector but am unsuccessful

rajeshvaswani77
Not applicable

Re: Google BigQuery Connection Error

Hi,

Has anyone been able to get past this error?

thanks,

Rajesh Vaswani

rajeshvaswani77
Not applicable

Re: Google BigQuery Connection Error

Hi,

Has anyone been able to get past this error?

thanks,

Rajesh Vaswani

mountaindude
Not applicable

Re: Google BigQuery Connection Error

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..