Error: "Index was outside the bounds of the array" when loading tables from Netsuite ODBC connection

[Reine]

Hi - I am trying to connect to my data in Netsuite via ODBC connection.  When I load a table, in the query editor I am getting the error below:
Unexpected error: Index was outside the bounds of the array.
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Index was outside the bounds of the array. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Microsoft.Mashup.Engine1.Runtime.Keys.DictionaryStringKeys.get_Item(Int32 index)
at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.ApplyStableOrder(OdbcQuery query)
at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.<GetRows>b__57_0()
at Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.IndexNestedJoinAlgorithm.Join(NestedJoinParameters parameters)
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRowsets>d__47.MoveNext()
at Microsoft.Mashup.Engine1.Language.Query.ExpandListColumnQuery.<GetRows>d__40.MoveNext()
at Microsoft.Mashup.Engine1.Runtime.RetryQuery.RetryEnumerator.MoveNext()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass17_0.<TryReportException>b__1()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Feedback Type:
Frown (Error)

Timestamp:
2022-06-23T19:22:06.0284663Z

Local Time:
2022-06-23T12:22:06.0284663-07:00

Session ID:
364ee7b9-828a-4621-ae75-6b5ec75701b2

Release:
June 2022

Product Version:
2.106.582.0 (22.06) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.106.582.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult","MethodDef":"OnException","ErrorOffset":""}

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
54.2 GB

Private Memory:
650 MB

Peak Working Set:
899 MB

IE Version:
11.789.19041.0

[v-yingjl]

As the error message 'Index was outside the bounds of the array', you can consider whether you have imported too large data into Power BI in this issue.

You can try to use a small sample with the same data source to try to import it into Power BI Dekstop to check that whether it related to the data size.

Best Regards,
Community Support Team _ Yingjie Li

[Reine]

Hi @v-yingjl 

This error occurs even with a table that has only 4 rows of data

[ballofwax]

@Reine I am having this same issue -- did you ever come to a resolution?

[Reine]

@ballofwax no solution to date 😞