Hi folks,
I tried to connect Excel 2010 (with Power Query installed) with Kylin 1.5.3
using odbc driver. The model and cube has been successfully built through
kylin web UI. (see the screen below )
Database:Credit
Table: T_CREDIT_ACCOUNT_INFO
Columns: GENDER(varchar)
CITY(varchar)
ISSUERBRANDID(varchar)
RECRUITCHANNEL(varchar)
BALANCE(bigint)
BALANCE2(bigint)
After I successfully created the DSN, and input the options with
“project=Project1” Excel reports following error. Anyone can shed some light
in this error ? Thanks!
[cid:[email protected]]
Unexpected error: Value was either too large or too small for an Int32.
Details:
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.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_TableSource()
at
Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
at
Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
at
Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
at
Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource()
at
Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1
result, Func`1 getStaleSince, Func`1 getSampled)
Fei Jia(费伽)
Yum! China, IT
021-24078997
________________________________
"This communication is confidential and may be legally privileged. If you are
not the intended recipient, (i) please do not read or disclose to others, (ii)
please notify the sender by reply mail, and (iii) please delete this
communication from your system. Failure to follow this process may be unlawful.
Thank you for your cooperation."
