Prezados, bom dia!
Estou com problemas na importação de dados par ao Excel.
Quando utilizo um grande volume de informações ocorre erro no Contêiner Microsof.Mashup.
"O erro não ocorre quando importo uma quantidade menor de registros."
Segue descrição do Erro abaixo:
Feedback Type:
Frown (Error)
Error Message:
O contêiner saiu inesperadamente com o código 0xC0000005.
Recursos usados: Odbc.DataSource/Simba ODBC Driver for Google BigQuery/2.4.6.1015/BigQuery/2.
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: O contêiner saiu inesperadamente com o código 0xC0000005.
Recursos usados: Odbc.DataSource/Simba ODBC Driver for Google BigQuery/2.4.6.1015/BigQuery/2. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: O contêiner saiu inesperadamente com o código 0xC0000005.
em Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
em Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
--- Fim do rastreamento de pilha de exceções internas ---
em Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
em Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
em Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
em Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitForT
em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
em Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
em Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
em Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult21 result, Func1 getStaleSince, Func`1 getSampled)
Stack Trace Message:
O contêiner saiu inesperadamente com o código 0xC0000005.
Recursos usados: Odbc.DataSource/Simba ODBC Driver for Google BigQuery/2.4.6.1015/BigQuery/2.
Invocation Stack Trace:
em Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
em Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo)
em Microsoft.Mashup.Client.Excel.Native.NativeUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
em System.Delegate.DynamicInvokeImpl(Object[] args)
em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
em System.Windows.Forms.Control.WndProc(Message& m)
em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
em System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
em System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
em Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
em Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalT
em Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries, IUndoScope undoScope)
em Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.<>c__DisplayClass5.<ShowModalQueriesEditorWindow>b__1(IUndoScope undoScope)
em Microsoft.Mashup.Client.Excel.Shim.NativeUndoServices.InvokeUndoableAction(IWorkbook workbook, UndoableActionType actionType, Action`1 action)
em Microsoft.Mashup.Client.Excel.QueriesEditorWindowManager.ShowModalQueriesEditorWindow(IWindowHandle ownerWindow, IWorkbookIdentity workbookIdentity, QueriesEditorParameters queriesEditorParameters, Queries queries)
em Microsoft.Mashup.Client.Excel.DialogManager.TryShowModalEditor(IWindowHandle ownerWindow, IWorkbook workbook, Query query, Boolean isNewQuery, Boolean navigatorExpanded)
em Microsoft.Mashup.Client.Excel.ExcelQueryServices.<>c__DisplayClass1b.<EditQuery>b__1a(IWorkbook workbook)
em Microsoft.Mashup.Client.Excel.ExcelQueryServices.TryInvokeOnWorkbook(Action`1 action)
em Microsoft.Mashup.Client.Excel.TaskPaneControls.TaskPaneControl.NotifyGetDataPresence(Action action)
em Microsoft.Mashup.Client.Excel.TaskPaneControls.QueriesTaskPaneControlBase.<>c__DisplayClass53.<EditQueryAsync>b__52()
em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
em System.Delegate.DynamicInvokeImpl(Object[] args)
em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
em System.Windows.Forms.Control.WndProc(Message& m)
em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Supports Premium Content:
False
Formulas:
section Section1;
shared Base = let
Fonte = Odbc.Query("dsn=GCP", "select \* from `br-apps-intelig-comercial-prd.Movimentacao.Fun_Cria_View_Venda_Estoque_NAL_v2`('CASA')#(lf)"),
#"Consultas Mescladas" = Table.NestedJoin(Fonte,{"COD\_LOJA"},Store,{"store\_key"},"Store",JoinKind.LeftOuter),
#"Consultas Mescladas1" = Table.NestedJoin(#"Consultas Mescladas",{"COD\_RMS"},Produto,{"cod\_product\_rms"},"Produto",JoinKind.LeftOuter),
#"Store Expandido" = Table.ExpandTableColumn(#"Consultas Mescladas1", "Store", {"store\_key", "TP\_LJ", "LOJA", "SIGLA", "FORMATO", "REGIAO", "DIVISAO"}, {"store\_key", "TP\_LJ", "LOJA", "SIGLA", "FORMATO", "REGIAO", "DIVISAO"}),
#"Produto Expandido" = Table.ExpandTableColumn(#"Store Expandido", "Produto", {"cod\_product\_rms", "SUB", "FAMILIA", "GRP", "SETOR", "DPTO", "DESCRICAO"}, {"cod\_product\_rms", "SUB", "FAMILIA", "GRP", "SETOR", "DPTO", "DESCRICAO"})
in
#"Produto Expandido";
shared Store = let
Fonte = Odbc.Query("dsn=GCP", "#(tab)Select#(lf)#(tab)C.store\_key#(lf) ,C.TIP\_UNID TP\_LJ#(lf) ,C.NOM\_UNIDADE LOJA#(lf) ,Case when C.DSC\_FORMATO = 'CD' then substr(C.NOM\_UNIDADE,1,4) else C.SGL\_UNIDADE end SIGLA#(lf) ,C.DSC\_FORMATO FORMATO#(lf) ,C.DSC\_REGIAO REGIAO#(lf) ,C.DSC\_DIVISAO DIVISAO#(lf)#(tab)from `br-apps-intelig-comercial-prd.Cadastros.Tbl_Lojas_CD` C #(lf)")
in
Fonte;
shared Produto = let
Fonte = Odbc.Query("dsn=GCP", "#(tab)Select#(lf)#(tab) B.cod\_product\_rms#(lf) ,B.ds\_sub\_category SUB#(lf) ,B.ds\_category FAMILIA#(lf) ,B.ds\_group GRP#(lf) ,B.ds\_sector SETOR#(lf) ,B.ds\_departament DPTO#(lf) ,B.ds\_product DESCRICAO #(lf)#(tab)From `br-apps-intelig-comercial-prd.Cadastros.Tbl_Produto` B #(lf)")
in
Fonte;
shared Supplier = let
Fonte = Odbc.Query("dsn=GCP", "#(tab)select#(lf)#(tab) D.SUPPLIER\_KEY#(lf)#(tab),D.SUPPLIER\_DESC FORNECEDOR#(lf)#(tab)from `br-apps-mandala-prod.db_mandala_metric.D_SUPPLIER` D ")
in
Fonte;
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
