Hello Jia,
Have you specified SQL statement in Power Query? If not, Power Query will launch the import wizard to execute some ‘select * from TABLE’ to load tables, and Apache Kylin does not support ‘select *’ well, which might cause errors like you met. Please specify a SQL statement in the ‘From ODBC’ dialog: http://kylin.apache.org/images/tutorial/odbc/ms_tool/Picture2.png Thanks, Dong Li Original Message Sender:Jia" [email protected] Recipient:[email protected][email protected] Date:Friday, Aug 12, 2016 18:05 Subject:Kylin connect to Excel and report " Value was either too large ortoo small for an Int32." 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! 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.EnsureInitializedb__0(IOdbcConnection connection) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.c__DisplayClassf.Connectb__e(IOdbcConnection connection) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.c__DisplayClassc`1.Connectb__b() at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action) at Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.Connect[T](String currentCatalog, Func`2 func) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.Connect(Action`1 action) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection.EnsureInitialized() at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain.NewQuery(OdbcTableInfo table, List`1 fromItems) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTableValue.OdbcTableValueBuilder.CreateTableValue(OdbcTableInfo tableInfo) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcHierarchicalNavigationTableValue.c__DisplayClass9.CreateOdbcTableb__8() at Microsoft.Mashup.Engine1.Runtime.DelayedValue.get_Value() at Microsoft.Mashup.Engine1.Library.Odbc.OdbcHierarchicalNavigationTableValue.OdbcTableLevelNavigationTableValue.c__DisplayClass1f.NewLazyRowb__1d(Int32 i) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key) at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2) at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args) at Microsoft.Mashup.Engine1.Language.ExpressionInvocationExpression.Execute(MembersFrame0 frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key) at Microsoft.Mashup.Engine1.Runtime.Library.List.ElementWithListCheckFunctionValue.Invoke(Value collection, Value key) at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(MembersFrame1 frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value frame) at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value frame) at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame) at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field) at Microsoft.Mashup.Engine1.Language.FieldAccessExpression.Execute(MembersFrame0 frame) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args) at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception) at Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List`1 partitionsToBuffer, Int32 nextPartition, Action`1 callback) at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.EvaluationHost.Run() at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.CreateThreadStartb__1(Object o) at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args) at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result() at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.c__DisplayClass1.BeginGetResultb__0(EvaluationResult2`1 result) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.c__DisplayClass1.BeginGetResultb__0(EvaluationResult2`1 result) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception) at Microsoft.Mashup.Evaluator.Firewall.BufferNextPartition(List`1 partitionsToBuffer, Int32 nextPartition, Action`1 callback) at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.EvaluationHost.Run() at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.CreateThreadStartb__1(Object o) at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args) at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result() at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.c__DisplayClass15.c__DisplayClass17.OnBeginGetPreviewValueSourceb__14() at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.c__DisplayClass5.RunStubb__3() at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.EvaluationHost.c__DisplayClass7.TryReportExceptionb__6() at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IHostTrace trace, Action action) at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception) at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.c__DisplayClass15.OnBeginGetPreviewValueSourceb__13(EvaluationResult2`1 result) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.c__DisplayClass28`1.OnBeginGetResultb__25() at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.EvaluationHost.Run() at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.CreateThreadStartb__0(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass15.CreateActionb__14(Object o) at Microsoft.Mashup.Evaluator.SafeThread2.c__DisplayClass2.CreateThreadStartb__1(Object o) at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args) at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message) at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel channel, ExceptionMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.c__DisplayClassa`1.AddHandlerb__8(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_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."
image001.png
Description: Binary data
