You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Bhanu Prakash Sunkesula <bp...@gmail.com> on 2016/10/21 07:17:02 UTC
Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excel or
Power BI for Visualization and some dimensions are not showing up.
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.OdbcHierarchicalNavigationTableValue.<>c__DisplayClass9.<CreateOdbcTable>b__8()
at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value()
at
Microsoft.Mashup.Engine1.Library.Odbc.OdbcHierarchicalNavigationTableValue.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.RemoteEvaluationContainerFactory.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.SynchronizationContextExtensions.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.SynchronizationContextExtensions.<>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.SynchronizationContextExtensions.<>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*
Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excel
or Power BI for Visualization and some dimensions are not showing up.
Posted by Alberto Ramón <a....@gmail.com>.
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 <lu...@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....@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.<
> > > 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>*
> > >
> >
>
Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excel
or Power BI for Visualization and some dimensions are not showing up.
Posted by Luke Han <lu...@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....@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.<
> > 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>*
> >
>
Re: Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excel
or Power BI for Visualization and some dimensions are not showing up.
Posted by Alberto Ramón <a....@gmail.com>.
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 <bp...@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.<
> 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>*
>