cancel
Showing results for 
Search instead for 
Did you mean: 

issue: google big query can't connect to newly created tables error ERROR [42000] [Microsoft]

newly created views (2021-04-19) aren't accessible anymore.  old views are still accessible although they're using almost the same query.

 

error we get from the connector is:

ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API

 

please fix

Status: New
Comments
v-lili6-msft
Community Support

hi

Whta is the complete error message, and also have a check as below document:

Error messages  |  BigQuery  |  Google Cloud

 

Regards,

Lin

 

katoma
Regular Visitor

Hi Lin,

no more information shown - sorry. I'll attach the diagnostics file here for you to have more information.

 

DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:38.6261975Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","ResourceKind":"GoogleBigQuery","ResourcePath":"GoogleBigQuery","HostProcessId":"15884","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft ODBC Driver for Google BigQuery","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0000641"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:38.6262834Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","ResourceKind":"GoogleBigQuery","ResourcePath":"GoogleBigQuery","HostProcessId":"15884","InfoType":"SQL_DRIVER_VER","Value":"2.3.3.1005","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0000317"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:38.6263292Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","ResourceKind":"GoogleBigQuery","ResourcePath":"GoogleBigQuery","HostProcessId":"15884","InfoType":"SQL_DBMS_NAME","Value":"BigQuery","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0000336"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:38.6263761Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","ResourceKind":"GoogleBigQuery","ResourcePath":"GoogleBigQuery","HostProcessId":"15884","InfoType":"SQL_DBMS_VER","Value":"2","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0000272"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:38.6261759Z","Action":"Engine/IO/Odbc/Connection/Info","ResourceKind":"GoogleBigQuery","ResourcePath":"GoogleBigQuery","HostProcessId":"15884","DriverName":"Microsoft ODBC Driver for Google BigQuery","DriverVersion":"2.3.3.1005","DBMSName":"BigQuery","DBMSVersion":"2","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0002554"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:38.6264433Z","Action":"Engine/IO/Odbc/Command/GetColumns","ResourceKind":"GoogleBigQuery","ResourcePath":"GoogleBigQuery","HostProcessId":"15884","CatalogName":"big-query-adwords-cockpit","SchemaName":"Company\\_ROI","TableName":"Facebook Ads Conversion - Runs Trial - 7d Click Attribution","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0010827"}
DataMashup.Trace Error: 24579 : {"Start":"2021-04-26T08:38:40.3445334Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"15884","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: \r\nStackTrace:\n at Microsoft.OleDb.Serialization.PageReaderDataReader.Read()\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.DataTableFrom(IDataReader reader)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.Cache(String[] keyParts, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.UserOverrideOdbcService.UserOverrideOdbcConnection.GetColumns(String catalogName, String schemaName, String tableName)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.<EnsureInitialized>b__15_0(IOdbcConnection connection)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass51_0.<ConnectForMetadata>b__0(IOdbcConnection connection)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass49_0`1.<ConnectForMetadata>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\nDetail: null\r\n\r\n","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0006646"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:33.7192545Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"15884","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:06.6265616"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3458713Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":11,"Duration":"00:00:00.0000562"}
DataMashup.Trace Warning: 24579 : {"Start":"2021-04-26T08:38:40.3458415Z","Action":"SimpleDocumentEvaluator/GetResult","HostProcessId":"15884","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: \r\nStackTrace:\n at Microsoft.OleDb.Serialization.PageReaderDataReader.Read()\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.DataTableFrom(IDataReader reader)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.Cache(String[] keyParts, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.UserOverrideOdbcService.UserOverrideOdbcConnection.GetColumns(String catalogName, String schemaName, String tableName)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.<EnsureInitialized>b__15_0(IOdbcConnection connection)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass51_0.<ConnectForMetadata>b__0(IOdbcConnection connection)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<>c__DisplayClass49_0`1.<ConnectForMetadata>b__0()\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ConnectForMetadata[T](String currentCatalog, Func`2 func)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ConnectForMetadata(Action`1 action)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.EnsureInitialized()\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain.NewQuery(OdbcTableInfo table, FromItem[] fromItems)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTableValue.OdbcTableValueBuilder.CreateTableValue(OdbcTableInfo tableInfo)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTableValue.New(OdbcQueryDomain queryDomain, OdbcTableInfo tableInfo, Boolean createNavigationProperties)\r\n at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value()\r\n at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)\r\n at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)\r\n at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)\r\n at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()\r\n at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.Force(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)\r\n at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)\r\n at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()\r\n at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)\r\n\r\nDetail: null\r\n\r\n","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0015851"}
DataMashup.Trace Warning: 24579 : {"Start":"2021-04-26T08:38:33.6946192Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"15884","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: \r\nStackTrace:\n at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)\r\n\r\nDetail: null\r\n\r\n","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:06.6530790"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3477632Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":11,"Duration":"00:00:00.0000301"}
DataMashup.Trace Warning: 24579 : {"Start":"2021-04-26T08:38:40.3477621Z","Action":"RemotePreviewValueSource/RunStub","HostProcessId":"15884","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: \r\nStackTrace:\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass9_1.<OnBeginGetPreviewValueSource>b__1()\r\n at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n\r\nDetail: null\r\n\r\n","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0010732"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:33.6944454Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","HostProcessId":"15884","evaluationID":"105","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:06.6544165"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3495451Z","Action":"DependencyCompiler/Dispose","HostProcessId":"15884","GoogleBigQuery":"True","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0000133"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3576815Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":11,"Duration":"00:00:00.0004057"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3592094Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"15884","Expression":"let\r\n _t = Section1!#\"Facebook Ads Conversion - Runs Trial - 7d Click Attribution\"\r\nin\r\n if _t is table then Table.FirstN(_t, 1000) meta Value.Metadata(_t)\r\n else if _t is list then List.FirstN(_t, 1000) meta Value.Metadata(_t)\r\n else _t","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0046312"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3639545Z","Action":"DependencyCompiler/RegisterDataSources","HostProcessId":"15884","Kind":"GoogleBigQuery","WasLoaded":"True","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"3f32d248-56cd-4cac-a325-7f33fa04cad9","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":1,"Duration":"00:00:00.0000259"}
DataMashup.Trace Information: 24579 : {"Start":"2021-04-26T08:38:40.3639293Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.92.706.0 (21.04)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":16020,"Tid":11,"Duration":"00:00:00.0003439"}

Akshay_Dutta
Microsoft
katoma
Regular Visitor

@Akshay_Dutta might be the case but connections to other tables in the same account are still working!