You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Dong Li <li...@apache.org> on 2016/10/24 13:21:46 UTC
Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excelor Power BI for Visualization and some dimensions are not showing up.
Thanks Alberto, I created JIRA to track this:
https://issues.apache.org/jira/browse/KYLIN-2121
Thanks,
Dong Li
Original Message
Sender:Alberto Ramóna.ramonportoles@gmail.com
Recipient:devdev@kylin.apache.org
Date:Monday, Oct 24, 2016 20:31
Subject:Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excelor Power BI for Visualization and some dimensions are not showing up.
To reproduce, you can use this video https://www.youtube.com/watch?v=v9of5N3TcTwfeature=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 luke.hq@gmail.com: 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 a.ramonportoles@gmail.com 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 bps.sunkesula@gmail.com : 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. EnsureInitializedb__0(IOdbcConnection connection) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. c__DisplayClassf.Connectb__e(IOdbcConnection connection) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. c__DisplayClassc`1.Connectb__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.CreateOdbcTableb__8() at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value() at Microsoft.Mashup.Engine1.Library.Odbc. OdbcHierarchicalNavigationTabl eValue.OdbcTableLevelNavigationTableValue.c__DisplayClass1f. NewLazyRowb__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.AddHandlerb__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.AddHandlerb__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. CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__ DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2. CreateThreadStartb__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.BeginGetResultb__0(EvaluationResult2`1 result) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.c__ DisplayClass1.BeginGetResultb__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.AddHandlerb__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.AddHandlerb__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. CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__ DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2. CreateThreadStartb__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. OnBeginGetPreviewValueSourceb__14() at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.c__ DisplayClass5.RunStubb__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. TryReportExceptionb__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.OnBeginGetResultb__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.AddHandlerb__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.AddHandlerb__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. CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__ DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2. CreateThreadStartb__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.AddHandlerb__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.StartEvaluationb__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.HandleExceptionb__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.OnAjaxExceptionb__5() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio ns.c__DisplayClassf.Postb__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.OnQuerySettingsResolvedb__1a() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions. HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensio ns.c__DisplayClassf.Postb__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*
Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to
Excelor Power BI for Visualization and some dimensions are not showing up.
Posted by Alberto Ramón <a....@gmail.com>.
upssss.. priority: Minor
I have learned trip after trip:
1º - The UI, its the most important key to adopt a new BI Tool ( . .
.most importantly, pretty colors)
2º - All the leaders, who decide how to use the money, uses excel (and some
of them have a good knowledge about it)
remember: This is a joke based in the real world :)
2016-10-24 15:21 GMT+02:00 Dong Li <li...@apache.org>:
> Thanks Alberto, I created JIRA to track this:
> https://issues.apache.org/jira/browse/KYLIN-2121
>
>
> Thanks,
> Dong Li
>
>
> Original Message
> Sender:Alberto Ramóna.ramonportoles@gmail.com
> Recipient:devdev@kylin.apache.org
> Date:Monday, Oct 24, 2016 20:31
> Subject:Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to
> Excelor Power BI for Visualization and some dimensions are not showing up.
>
>
> To reproduce, you can use this video https://www.youtube.com/watch?
> v=v9of5N3TcTwfeature=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
> luke.hq@gmail.com: 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 a.ramonportoles@gmail.com 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
> bps.sunkesula@gmail.com : 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.
> EnsureInitializedb__0(IOdbcConnection connection) at
> Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.
> c__DisplayClassf.Connectb__e(IOdbcConnection connection) at
> Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.
> c__DisplayClassc`1.Connectb__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.CreateOdbcTableb__8() at
> Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value() at
> Microsoft.Mashup.Engine1.Library.Odbc. OdbcHierarchicalNavigationTabl
> eValue.OdbcTableLevelNavigationTableValue.c__DisplayClass1f.
> NewLazyRowb__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.AddHandlerb__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.AddHandlerb__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.
> CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__
> DisplayClass15.CreateActionb__14(Object o) at
> Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.
> CreateThreadStartb__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.BeginGetResultb__0(EvaluationResult2`1 result) --- End
> of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.c__
> DisplayClass1.BeginGetResultb__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.AddHandlerb__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.AddHandlerb__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.
> CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__
> DisplayClass15.CreateActionb__14(Object o) at
> Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.
> CreateThreadStartb__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.
> OnBeginGetPreviewValueSourceb__14() at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.c__
> DisplayClass5.RunStubb__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.
> TryReportExceptionb__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.OnBeginGetResultb__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.AddHandlerb__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.AddHandlerb__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.
> CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__
> DisplayClass15.CreateActionb__14(Object o) at
> Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.
> CreateThreadStartb__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.AddHandlerb__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.StartEvaluationb__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.HandleExceptionb__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.OnAjaxExceptionb__5()
> at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.
> HandleExceptions(IExceptionHandler exceptionHandler, Action action) at
> Microsoft.Mashup.Host.Document.SynchronizationContextExtensio
> ns.c__DisplayClassf.Postb__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.OnQuerySettingsResolvedb__1a() at
> Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.
> HandleExceptions(IExceptionHandler exceptionHandler, Action action) at
> Microsoft.Mashup.Host.Document.SynchronizationContextExtensio
> ns.c__DisplayClassf.Postb__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*