Malina Voicu Posted June 21, 2022 Share Posted June 21, 2022 (edited) Hi, I need some help with the error below that i recceive when when I try to create an information link to combine 2 different set of data sources: Anyone knows how i should fix this Error message: Could not open information link. ImportException at Spotfire.Dxp.Data: Failed to create DataTable (HRESULT: 80131500) Stack Trace: at Spotfire.Dxp.Data.ColumnFactory.CreateColumns(DataRowReader reader, String documentTitleForOrigin, IDataPropertyContainer defaultProperties, DataPropertyRegistry dataPropertyRegistry, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport loadReport, ResultProperties resultProperties, PendingViewRequestsManager pendingViewRequestsManager, Boolean mangleColumnNames) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.c__DisplayClass76_0.b__0() at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.CreateView(CxxSession session, DataPropertyRegistry propertyRegistry, GlobalMethodRegistry globalMethodRegistry, DataSourceConnection connection, IDataPropertyContainer defaultColumnProperties, PartialDataLoadReport& partialLoadReport) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.GetColumnsAndProperties(DataSourceConnection connection) at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(SourceColumnProducer producer, DataSourceConnection connection) at Spotfire.Dxp.Data.Persistence.DataItem.Update(SourceColumnProducer producer, DataSourceConnection connection) at Spotfire.Dxp.Data.Persistence.DataPool.d__15.MoveNext() at Spotfire.Dxp.Data.Producers.SourceColumnProducer.OnConfigure() at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node) at Spotfire.Dxp.Framework.DocumentModel.UndoableListAvlLeaf`1.ForEachChild(Action`1 action, Boolean includeFrozen) at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node) at Spotfire.Dxp.Framework.DocumentModel.UndoableList`1.ForEachChild(Action`1 action, Boolean includeFrozen) at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node) at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass92_0.b__0(IDocumentNodeChild documentNodeChild) at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.ForEachChild(IDocumentNodeChild[] children, Action`1 action) at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree() at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation) at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew() at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNodeBase newOwner) at Spotfire.Dxp.Framework.DocumentModel.UndoableNode.Spotfire.Dxp.Framework.DocumentModel.IUndoableNode.AttachItemToUndoableNode(Object item) at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass43_0.b__0() at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty) at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item) at Spotfire.Dxp.Data.DataTableCollection.c__DisplayClass94_0.b__0() at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty) at Spotfire.Dxp.Data.DataTableCollection.Add(DataTable dataTable) at Spotfire.Dxp.Application.PartiallyOpenedDataSource.d__9.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__99.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__92.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.ConsumeDataLoadPromptRequests(IEnumerable`1 prompts) at Spotfire.Dxp.Application.AnalysisApplication.Open(DataSource source, DocumentOpenSettings settings) at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSourceWithoutPrompting(DataSource dataSource, DocumentOpenSettings documentOpenSettings, IServiceProvider serviceProvider) at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSource(InformationLinkDataSource dataSource, DocumentOpenSettings documentOpenSettings, IServiceProvider serviceProvider) at Spotfire.Dxp.Framework.ApplicationModel.Progress.c__DisplayClass22_0.b__0() at Spotfire.Dxp.Framework.ApplicationModel.MonitorableProgress.Start[T](Func`1 action) at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop() InformationModelException at Spotfire.Dxp.Data: Failed to execute query: [simba][bigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request POST https://bigquery.googleapis.com/bigquery/v2/projects/irn-11829-gre-shl-o... { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "Syntax error: Unexpected ")" at [1:2620]", "reason": "invalidQuery" } ], "message": "Syntax error: Unexpected ")" at [1:2620]", "status": "INVALID_ARGUMENT" } (HRESULT: 80131500) Stack Trace: at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock() at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BinaryReader.FillBuffer(Int32 numBytes) at System.IO.BinaryReader.ReadUInt16() at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadMagicNumber(BinaryReader reader) at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType) at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit() at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteInformationLink() at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.KnownColumnsInformationLinkDataRowReader.TryCreateCxxRepresentation(CxxSession session, Int64 exclusiveStartRowIndex, UInt64 maxRowsThatWillBeRead, PendingViewRequestsManager pendingViewRequestsManager, CxxTable& table) at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.CreateTable(DataRowReader dataRowReader, CxxSession session, PartialDataLoadReport report, Advancer rowAdvancer, Boolean needsReset, Int64 exclusiveStartRowIndex, UInt64 maxRowsThatWillBeRead, PendingViewRequestsManager partiallyLoadedConsumers) at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.CreateTable(DataRowReader dataRowReader, CxxSession session, PartialDataLoadReport report, PendingViewRequestsManager pendingViewRequestsManager, Boolean needsReset, UInt64 maxRowsToConsume) at Spotfire.Dxp.Data.ColumnFactory.CreateColumns(DataRowReader reader, String documentTitleForOrigin, IDataPropertyContainer defaultProperties, DataPropertyRegistry dataPropertyRegistry, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport loadReport, ResultProperties resultProperties, PendingViewRequestsManager pendingViewRequestsManager, Boolean mangleColumnNames) InformationModelServiceException at Spotfire.Dxp.Services: Failed to execute query: [simba][bigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request POST https://bigquery.googleapis.com/bigquery/v2/projects/irn-11829-gre-shl-o... { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "Syntax error: Unexpected ")" at [1:2620]", "reason": "invalidQuery" } ], "message": "Syntax error: Unexpected ")" at [1:2620]", "status": "INVALID_ARGUMENT" } (HRESULT: 80131509) Stack Trace: at Spotfire.Dxp.Services.WcfSoapService`2.InvokeService[T](Func`1 serviceMethod, String customMethodNameForLogging) at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock() Edited May 21 by Jose Leviaguirre Link to comment Share on other sites More sharing options...
Navaneetha Gudlavaram Posted May 21 Share Posted May 21 Do we get answer for the above query? Thanks in advance! Link to comment Share on other sites More sharing options...
Solution David Boot-Olazabal Posted May 21 Solution Share Posted May 21 (edited) Hi Navaneetha, Without knowing any further context, I can see that the error message provided, speaks of: "Failed to execute query: [simba][bigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request". So, somewhere in the provided SQL statement, there is something off. Not sure where this exactly is, but the provided query is invalid: { "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "Syntax error: Unexpected ")" at [1:2620]", "reason": "invalidQuery" : "status": "INVALID_ARGUMENT" } (HRESULT: 80131509) If possible, I would advise to run the same query directly on the database, so it may be easier to find out where the root cause lies for the invalid query. Kind regards, David Edited May 21 by Jose Leviaguirre Link to comment Share on other sites More sharing options...
Navaneetha Gudlavaram Posted May 21 Share Posted May 21 Hello David, Thank you for your response, this helped me to find out the error in query. Now issue has been resolved. Thanks again! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now