topic Re: Google BigQuery Connection Error in QlikView

Google BigQuery Connection Error

Tue, 08 Jan 2013 23:21:38 GMT

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:

<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

Wed, 09 Jan 2013 00:05:02 GMT

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

Anonymous — Tue, 15 Jan 2013 09:09:26 GMT

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

Tue, 15 Jan 2013 22:59:23 GMT

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

wizardo — Sun, 19 May 2013 13:08:05 GMT

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

Re: Google BigQuery Connection Error

rajeshvaswani77 — Sat, 02 Nov 2013 04:19:29 GMT

Hi,

Has anyone been able to get past this error?

thanks,

Rajesh Vaswani

Re: Google BigQuery Connection Error

rajeshvaswani77 — Wed, 06 Nov 2013 04:31:51 GMT

Hi,

Has anyone been able to get past this error?

thanks,

Rajesh Vaswani

Re: Google BigQuery Connection Error

mountaindude — Tue, 04 Feb 2014 22:00:21 GMT

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