To reproduce, you can use this video <https://www.youtube.com/watch?v=v9of5N3TcTw&feature=youtu.be> and kylin cube example:
select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt (The load data process never will finisfh, as in video, but you can see Error in log "Value was either too large or too small for an Int32" ) 2016-10-23 15:06 GMT+02:00 Luke Han <[email protected]>: > Please help to create one JIRA for this issue, we will follow up for the > root cause and try to fix it if possible. > > Thanks. > > > Best Regards! > --------------------- > > Luke Han > > On Sat, Oct 22, 2016 at 4:41 AM, Alberto Ramón <[email protected]> > wrote: > > > jeje > > > > Yes, The new version of Microsoft Power BI is not working with Kylin > > ..... :( > > See this > > video <https://youtu.be/v9of5N3TcTw> > > mailLIst (you can see ScreenShoots) > > <http://mail-archives.apache.org/mod_mbox/kylin-user/ > > 201609.mbox/%3CCAEcyM16%3Dd9%2Bdc5equz8pFUowEQg3ntsPm0_Goe% > > 3DoBBTLKtQg%3DQ%40mail.gmail.com%3E> > > > > After 3 days testing and view logs, ... I cant solved it > > > > I discoverd this: > > > > > > Query with *limit 5*, the preview data run OK, but load data ... > never > > > > finished > > > > > > > > > > > > 2016-10-21 9:17 GMT+02:00 Bhanu Prakash Sunkesula < > [email protected] > > >: > > > > > Hi all, > > > > > > I am unable to load data from KYLIN CUbe to Excel / power BI, > > > i have installed all required drivers ( Microsoft Visual C++ 2012 > > > Redistributable > > > <http://www.microsoft.com/en-us/download/details.aspx?id=30679> & > KYLIN > > > ODBC drivers ). i am able to connect successfully to KYLIN CUBE, but > the > > > data is not loading to excel / power BI because of below issue and also > > > some dimensions are not showing up in Excel. > > > > > > Error Message: > > > > > > Value was either too large or too small for an Int32. > > > > > > Stack Trace: > > > > > > Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either > > too > > > large or too small for an Int32. ---> Microsoft.Mashup.Evaluator. > > Interface.ErrorException: > > > Value was either too large or too small for an Int32. ---> > > > Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either > > too > > > large or too small for an Int32. ---> Microsoft.Mashup.Evaluator. > > Interface.ErrorException: > > > Value was either too large or too small for an Int32. ---> > > > Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either > > too > > > large or too small for an Int32. ---> System.OverflowException: Value > was > > > either too large or too small for an Int32. ---> > > System.OverflowException: > > > Value was either too large or too small for an Int32. > > > at System.Convert.ToInt32(Int64 value) > > > at System.Int64.System.IConvertible.ToInt32(IFormatProvider > provider) > > > at System.Convert.ToInt32(Object value, IFormatProvider provider) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.< > > > EnsureInitialized>b__0(IOdbcConnection connection) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<> > > > c__DisplayClassf.<Connect>b__e(IOdbcConnection connection) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.<> > > > c__DisplayClassc`1.<Connect>b__b() > > > at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler. > > RunWithRetryGuard[T](Int32 > > > maxRetryAttempts, Func`1 action) > > > at Microsoft.Mashup.Engine1.Library.Common. > > > DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. > > Connect[T](String > > > currentCatalog, Func`2 func) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. > > Connect(Action`1 > > > action) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection. > > > EnsureInitialized() > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain. > > NewQuery(OdbcTableInfo > > > table, List`1 fromItems) > > > at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTableValue. > > > OdbcTableValueBuilder.CreateTableValue(OdbcTableInfo tableInfo) > > > at Microsoft.Mashup.Engine1.Library.Odbc. > > OdbcHierarchicalNavigationTabl > > > eValue.<>c__DisplayClass9.<CreateOdbcTable>b__8() > > > at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value() > > > at Microsoft.Mashup.Engine1.Library.Odbc. > > OdbcHierarchicalNavigationTabl > > > eValue.OdbcTableLevelNavigationTableValue.<>c__DisplayClass1f.< > > NewLazyRow>b__1d(Int32 > > > i) > > > at Microsoft.Mashup.Engine1.Runtime.RecordValue. > > > DemandRecordValue.get_Item(Int32 index) > > > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String > > field) > > > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute( > > Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2. > > Execute(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke( > > Value > > > arg0) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > RuntimeRecordValue.Force(Int32 > > > index) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > > RuntimeRecordValue.get_Item(Int32 index) > > > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String > > field) > > > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute( > > Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke( > > Value > > > arg0) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > RuntimeRecordValue.Force(Int32 > > > index) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > > RuntimeRecordValue.get_Item(Int32 index) > > > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key) > > > at Microsoft.Mashup.Engine1.Runtime.Library.Linker. > > > BindFunctionValue.TypedInvoke(RecordValue environment, Value section, > > > TextValue name) > > > at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3` > > 4.Invoke(Value > > > arg0, Value arg1, Value arg2) > > > at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] > > args) > > > at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression > > .Execute(MembersFrame0& > > > frame) > > > at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() > > > at Microsoft.Mashup.Engine1.Language.ListExpression. > > RuntimeListValue.Force(Int32 > > > index) > > > at Microsoft.Mashup.Engine1.Language.ListExpression. > > > RuntimeListValue.get_Item(Int32 index) > > > at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key) > > > at Microsoft.Mashup.Engine1.Runtime.Library.List. > > > ElementWithListCheckFunctionValue.Invoke(Value collection, Value key) > > > at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2. > > Execute(MembersFrame1& > > > frame) > > > at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke( > > Value > > > arg0) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > RuntimeRecordValue.Force(Int32 > > > index) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > > RuntimeRecordValue.get_Item(Int32 index) > > > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String > > field) > > > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute( > > Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2. > > Execute(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.Expression. > > ExecuteCondition(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.DebugExpression. > > ExecuteCondition(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value > > frame) > > > at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value > > > frame) > > > at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke( > > Value > > > arg0) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > RuntimeRecordValue.Force(Int32 > > > index) > > > at Microsoft.Mashup.Engine1.Language.RecordExpression. > > > RuntimeRecordValue.get_Item(Int32 index) > > > at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String > > field) > > > at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute( > > MembersFrame0& > > > frame) > > > at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() > > > at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] > > args) > > > at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup. > > > Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments) > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator. > BeginGetResult( > > DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > --- End of inner exception stack trace --- > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator. > BeginGetResult( > > DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator. > BeginGetResult( > > DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.FirewallPartition. > > BeginGetResult[T](Action`1 > > > callback) > > > at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator. > > > Evaluation`1.OnBufferComplete(Exception exception) > > > at Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List`1 > > > partitionsToBuffer, Int32 nextPartition, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.Firewall. > BeginBufferPartitions(Action`1 > > > callback) > > > at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator. > > > BeginGetResultInternal[T](DocumentEvaluationParameters parameters, > > > Action`1 callback) > > > at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator. > > BeginGetResult(DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.Interface. > IDocumentEvaluatorExtensions. > > > GetResult[T](IDocumentEvaluator`1 evaluator, > > DocumentEvaluationParameters > > > parameters) > > > 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.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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.EvaluationHost.Run() > > > at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object > > args) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.< > > CreateThreadStart>b__0(Object > > > o) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__ > > > DisplayClass15.<CreateAction>b__14(Object o) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.< > > CreateThreadStart>b__1(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.Interface.EvaluationResult2`1. > > > get_Result() > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__ > > > DisplayClass1.<BeginGetResult>b__0(EvaluationResult2`1 result) > > > --- End of inner exception stack trace --- > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__ > > > DisplayClass1.<BeginGetResult>b__0(EvaluationResult2`1 result) > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator. > BeginGetResult( > > DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator. > BeginGetResult( > > DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.FirewallPartition. > > BeginGetResult[T](Action`1 > > > callback) > > > at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator. > > > Evaluation`1.OnBufferComplete(Exception exception) > > > at Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List`1 > > > partitionsToBuffer, Int32 nextPartition, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.Firewall. > BeginBufferPartitions(Action`1 > > > callback) > > > at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator. > > > BeginGetResultInternal[T](DocumentEvaluationParameters parameters, > > > Action`1 callback) > > > at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator. > > BeginGetResult(DocumentEvaluationParameters > > > parameters, Action`1 callback) > > > at Microsoft.Mashup.Evaluator.Interface. > IDocumentEvaluatorExtensions. > > > GetResult[T](IDocumentEvaluator`1 evaluator, > > DocumentEvaluationParameters > > > parameters) > > > 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.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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.EvaluationHost.Run() > > > at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object > > args) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.< > > CreateThreadStart>b__0(Object > > > o) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__ > > > DisplayClass15.<CreateAction>b__14(Object o) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.< > > CreateThreadStart>b__1(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.Interface.EvaluationResult2`1. > > > get_Result() > > > at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator. > > > Service.<>c__DisplayClass15.<>c__DisplayClass17.< > > > OnBeginGetPreviewValueSource>b__14() > > > at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__ > > > DisplayClass5.<RunStub>b__3() > > > 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__DisplayClass7.< > > > TryReportException>b__6() > > > at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions( > > 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__DisplayClass15.<OnBeginGetPreviewValueSource> > > b__13(EvaluationResult2`1 > > > result) > > > at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator. > > > Service.<>c__DisplayClass28`1.<OnBeginGetResult>b__25() > > > 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.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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.EvaluationHost.Run() > > > at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object > > args) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.< > > CreateThreadStart>b__0(Object > > > o) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__ > > > DisplayClass15.<CreateAction>b__14(Object o) > > > at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass2.< > > CreateThreadStart>b__1(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.RemoteEvaluationContainerFacto > > > ry.Container.OnException(IMessageChannel channel, ExceptionMessage > > > message) > > > at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__ > > > DisplayClassa`1.<AddHandler>b__8(IMessageChannel channel, Message > > 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_Value() > > > at Microsoft.Mashup.Evaluator.Interface. > NotifyingPreviewValueSource. > > > get_Value() > > > at Microsoft.Mashup.Evaluator.Interface. > NotifyingPreviewValueSource. > > > get_Value() > > > at Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__ > > > DisplayClassb.<StartEvaluation>b__8(EvaluationResult2`1 result) > > > > > > Invocation Stack Trace: > > > > > > at Microsoft.Mashup.Host.Document.ExceptionExtensions. > > > GetCurrentInvocationStackTrace() > > > at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String > > > exceptionStackTrace, String invocationStackTrace) > > > at Microsoft.Mashup.Client.ClientShared. > > FeedbackErrorInfo..ctor(String > > > message, Nullable`1 errorCode, String requestId, Exception exception) > > > at Microsoft.Mashup.Client.ClientShared. > UnexpectedExceptionHandler.<> > > > c__DisplayClass1.<HandleException>b__0() > > > at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio > > > ns.SendAndMarshalExceptions(SynchronizationContext context, Action > > > callback) > > > at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler. > > HandleException(Exception > > > e) > > > at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm. > > > DelayedInitializationExceptionHandler.HandleException(Exception e) > > > at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm.<>c__ > > > DisplayClass6.<OnAjaxException>b__5() > > > at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. > > > HandleExceptions(IExceptionHandler exceptionHandler, Action action) > > > at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio > > > ns.<>c__DisplayClassf.<Post>b__e(Object null) > > > at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] > > > arguments, Signature sig, Boolean constructor) > > > at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object > > > obj, Object[] parameters, Object[] arguments) > > > at System.Delegate.DynamicInvokeImpl(Object[] args) > > > at System.Windows.Forms.Control.InvokeMarshaledCallbackDo( > > ThreadMethodEntry > > > tme) > > > at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper( > Object > > > obj) > > > at System.Threading.ExecutionContext.RunInternal(ExecutionContext > > > executionContext, ContextCallback callback, Object state, Boolean > > > preserveSyncCtx) > > > at System.Threading.ExecutionContext.Run(ExecutionContext > > > executionContext, ContextCallback callback, Object state, Boolean > > > preserveSyncCtx) > > > at System.Threading.ExecutionContext.Run(ExecutionContext > > > executionContext, ContextCallback callback, Object state) > > > at System.Windows.Forms.Control.InvokeMarshaledCallback( > > ThreadMethodEntry > > > tme) > > > at System.Windows.Forms.Control.InvokeMarshaledCallbacks() > > > at System.Windows.Forms.Control.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) > > > at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& > > msg) > > > at System.Windows.Forms.Application.ThreadContext. > > LocalModalMessageLoop(Form > > > form) > > > at System.Windows.Forms.Application.ThreadContext. > > RunMessageLoopInner(Int32 > > > reason, ApplicationContext context) > > > at System.Windows.Forms.Application.ThreadContext. > > RunMessageLoop(Int32 > > > reason, ApplicationContext context) > > > at System.Windows.Forms.Application.RunDialog(Form form) > > > at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) > > > at Microsoft.Mashup.Client.ClientShared.WindowManager. > ShowDialog[T](T > > > form, IWin32Window owner) > > > at Microsoft.Mashup.Client.ClientShared.Ux.HtmlForm. > > ShowDialog(IWin32Window > > > owner) > > > at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog. > > > NavigatorFloatingDialog.ShowEditLoadTo(IWin32Window owner, WindowsHost > > > windowsHost, Query query, ITelemetryService telemetryService) > > > at Microsoft.Mashup.Client.Excel.ExcelDataImporter. > > ShowNavigator(Query > > > query) > > > at Microsoft.Mashup.Client.ClientShared.DataImporter. > > > ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& > importedQueries) > > > at Microsoft.Mashup.Client.ClientShared.DataImporter. > > ImportNavigationSource(Query > > > query) > > > at Microsoft.Mashup.Client.ClientShared.DataImporter. > > > OnGetPreviewResult(PreviewResult preview, Query query, String > sourceID, > > > String formulaTitle, Nullable`1 explicitImportDestination, Boolean > > > isNewQuery, Boolean isFromEditor) > > > at Microsoft.Mashup.Client.ClientShared.DataImporter.<>c_ > > > _DisplayClass1d.<OnQuerySettingsResolved>b__1a() > > > at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. > > > HandleExceptions(IExceptionHandler exceptionHandler, Action action) > > > at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio > > > ns.<>c__DisplayClassf.<Post>b__e(Object null) > > > at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] > > > arguments, Signature sig, Boolean constructor) > > > at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object > > > obj, Object[] parameters, Object[] arguments) > > > at System.Delegate.DynamicInvokeImpl(Object[] args) > > > at System.Windows.Forms.Control.InvokeMarshaledCallbackDo( > > ThreadMethodEntry > > > tme) > > > at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper( > Object > > > obj) > > > at System.Threading.ExecutionContext.RunInternal(ExecutionContext > > > executionContext, ContextCallback callback, Object state, Boolean > > > preserveSyncCtx) > > > at System.Threading.ExecutionContext.Run(ExecutionContext > > > executionContext, ContextCallback callback, Object state, Boolean > > > preserveSyncCtx) > > > at System.Threading.ExecutionContext.Run(ExecutionContext > > > executionContext, ContextCallback callback, Object state) > > > at System.Windows.Forms.Control.InvokeMarshaledCallback( > > ThreadMethodEntry > > > tme) > > > at System.Windows.Forms.Control.InvokeMarshaledCallbacks() > > > at System.Windows.Forms.Control.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) > > > > > > [image: Inline image 1] > > > > > > > > > > > > Thanks & Regards, > > > *Bhanu Prakash Sunkesula*. > > > +91 *7795395099 <7795395099>* > > > > > >
